Thread: 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