Обсуждение: problems with win2k...

i'm new at this but i'll at least be thorough ;)

i was reading the instructions for installing on win2k
at http://postgresql.cokernet.com/docs/faq-mswin.

so i download the latest cygwinsetup.exe and run the
full install (including source files which takes for
freakin' ever).

i then install cygipc 1.09-2 into the cygwin/usr
directory and start the daemon (not as a service but
just straight up).

i launch the cygwin bash shell and cd to the postgres
7.1.2 directory and start running the commands per the
admin manual (pdf version). the commands are...
   ./configure
   gmake
   gmake install
   adduser postgres
   su - postgres
   /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
   /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
   /usr/local/pgsql/bin/createdb test
   /usr/local/pgsql/bin/psql test

first, there isn't a gmake. but, being the bright sort of
bear that i am i just used make instead and it seems to
work. well, mostly. i get lots of good stuff being dumped
to stdout that says that things are being built up until
the very end where i get the following...

************** error msgs start here **************
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations command.o
common.o help.o input.o stringutils.o mainloop.o copy.o startup.o
prompt.o variables.o large_obj.o print.o describe.o
tab-complete.o -L../../../src/interfaces/libpq -lpq -L
/usr/local/lib -g  -lz -lcrypt -lreadline -lcygipc -o psql
tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to
`filename_co
mpletion_function'
collect2: ld returned 1 exit status
make[3]: *** [psql] Error 1
make[3]: Leaving directory `/cygdrive/c/postgresql-7.1.2/src/bin/psql'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/cygdrive/c/postgresql-7.1.2/src/bin'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/cygdrive/c/postgresql-7.1.2/src'
make: *** [all] Error 2
************** error msgs end here **************

in cygwin/usr/local/pgsql/bin i have the following files that have
been created...
08/08/2001  03:47p             298,036 ecpg.exe
08/08/2001  03:47p              20,698 initdb
08/08/2001  03:47p               4,886 initlocation
08/08/2001  03:47p               2,862 ipcclean
08/08/2001  03:47p               9,131 pg_ctl
08/08/2001  03:47p             159,415 pg_dump.exe
08/08/2001  03:47p               6,895 pg_dumpall
08/08/2001  03:47p              24,282 pg_id.exe
08/08/2001  03:47p              35,913 pg_passwd.exe
08/08/2001  03:47p              93,699 pg_restore.exe
08/08/2001  03:47p           1,747,642 postgres.exe
08/08/2001  03:47p                 104 postmaster.lnk

reading from the instructions that say...
   /usr/local/pgsql/bin/createdb test
   /usr/local/pgsql/bin/psql test

i notice that createdb and psql don't exist. i'm figuring that
the compiler errors above are responsible for that.

i'm guessing that something in cygwin is not properly configured
but since i am new at this i have no idea...

many thanks!

rjsjr

ps - the adduser and su commands don't exist either. i'm guessing
that since i'm on win2k that there isn't a real need for them
since everyone is a superuser?

Robert,

On Wed, Aug 08, 2001 at 04:53:16PM -0500, Robert J. Sanford, Jr. wrote:
> so i download the latest cygwinsetup.exe and run the
> full install (including source files which takes for
> freakin' ever).

There is no need to download the source since you just downloaded the
pre-built binaries for all packages -- including PostgreSQL 7.1.2.

> ************** error msgs start here **************
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations command.o
> common.o help.o input.o stringutils.o mainloop.o copy.o startup.o
> prompt.o variables.o large_obj.o print.o describe.o
> tab-complete.o -L../../../src/interfaces/libpq -lpq -L
> /usr/local/lib -g  -lz -lcrypt -lreadline -lcygipc -o psql
> tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to
> `filename_completion_function'
> [snip]
> ************** error msgs end here **************

The above is due to building against readline 4.2 instead of 4.1.
Search the pgsql-patches list for a patch that I have contributed and has
already been accepted into the PostgreSQL CVS that fixes this problem.
Note that my pre-built PostgreSQL 7.1.2-3 binary already has this patch
applied.  What version of the source were you trying to build?

> i'm guessing that something in cygwin is not properly configured
> but since i am new at this i have no idea...

Please read the Cygwin PostgreSQL README:

    /usr/doc/Cygwin/postgresql-7.1.2.README

> ps - the adduser and su commands don't exist either.

On NT/2000, adduser is User Manager and su doesn't exist yet (but may in
the future).

> i'm guessing
> that since i'm on win2k that there isn't a real need for them
> since everyone is a superuser?

Kinda -- at least that is how I run (under Windows).

Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: jason@tishler.net
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

Robert,

In the future, please post to pgsql-cygwin@postgresql.org instead of
sending private email so others can benefit too.

On Thu, Aug 09, 2001 at 07:46:09AM -0500, robert sanford wrote:
> On 8/8/01 at 11:16 PM, jason@tishler.net (Jason Tishler) wrote:
>
> > I tried to provide pre-built binaries on the PostgreSQL mirrors.
> > I really tried.  Sigh...  So, I went the Cygwin route.  Which in
> > hindsight, is probably the better way to go.  But, yes, I
> > completely agree with you.  The fact that the Cygwin PostgreSQL
> > binaries exist should be better documented on the PostgreSQL
> > mirrors.  How would you like to fight that battle?
>
> first - thanks a million for the info on the binaries. that will
> save me much heartache.
>
> second - thanks for putting in the time to make it part of cygwin!

You are welcome.

> where should i look to find out who is in charge of documention and
> faqs?

Sorry, but I can only recommend the obvious:

    www.postgresql.org

> where would i start a discussion about modifying them?

    pgsql-cygwin@postgresql.org
    pgsql-patches@postgresql.org

Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: jason@tishler.net
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com