Re: pgsql with cygwin 1.3.6.6

hi Jason and all,

I have succeeded in launching the postgresql, I have removed all installed
components, removed all registry entries and rebooted.

next I have downloaded all the components to my hard drive, I have chosen
the newest available versions and then installed it all from my hard drive.

I know that not all is required but I wanted to make sure it will go
smoothly as it probably went to the developers and testers that supplied
this installation package.

next I have created a file called: .bashrc in my home directory containing:

set PATH $PATH:/usr/local/pgsql/bin:/usr/local/bin
set PGDATA /usr/local/pgsql/data
set PGLIB /usr/local/pgsql/lib
set LD_LIBRARY_PATH /usr/local/pgsql/lib:/usr/local/lib
export LD_LIBRARY_PATH PATH PGDATA PGLIB

next I have executed the next lines (this lines actually creates a new
database default called: template1):

source .bashrc
ipc-daemon &
initdb  /database

and last I have called these lines in order to launch the database:

/usr/bin/pg_ctl -D /database -l logfile.txt -o -i start &

the last step was to download the PgExplorer from:
http://www.davecentral.com/projects/pgexplorer1/

and connected to the database and created tables etc.

all worked fine, I have also connected through JDBC its perfect.

if any one have problems with this explanation or need to ask questions you
are more then welcome.

Jason - again thanks for the help and replies.

Shay.

-----Original Message-----
From: Jason Tishler [mailto:jason@tishler.net]
Sent: Friday, February 01, 2002 4:25 PM
To: Shay
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] pgsql with cygwin 1.3.6.6


Shay,

On Fri, Feb 01, 2002 at 09:38:30AM +0200, Shay wrote:
> thanks for the swift answer,

You are welcome.

> i have downloaded through setup only the 1.3.9 CygWin component and

Good.

> installed only it and still the problem remains,

Bummers!

> i would like to point out i am using Windows XP maybe that is my problem -
> is XP not supported?

XP is supported because Cygwin supports XP.  Sorry, but I don't have
access to XP, so I can't help to debug this problem.  However, note that
others have reported success with XP.

> if any one has another idea it would be much help,

Try to use strace to debug.  Note that you will have to temporarily
replace the postmaster symlink with a copy of postgres.exe:

    $ rm /usr/bin/postmaster
    $ cp /usr/bin/postgres.exe /usr/bin/postmaster.exe

This is because strace is *not* a Cygwin app, it's a Mingw app, and does
not understand symlinks.

Run strace as follows:

    $ strace -o postmaster.log postmaster -i -D /database

You can also try posting your problem to the cygwin@cygwin.com list.

BTW, did you really initdb into /database?

Jason