Thread: Problem starting postmaster on Win XP Home
Have followed the Win XP Install readme as far as step 9 without problem
net start postmaster fails with
FATAL: File /usr/share/postgresql/data/PG_VERSION is missing. This is not a valid data directory.
The database was initialised ok acording to messages received at step 8.
Any idea what I am doing wrong please? Have run out of thing to try
Thanks
Roger
Roger, There is no need to post twice within two days -- especially on the weekend. Sorry, but I don't get paid enough to provide support on the weekends. Oh, I just remembered, I don't get paid anything on week days either. :,( or :,) On Mon, Jul 14, 2003 at 12:41:19PM +0100, Roger Ackroyd wrote: > Have followed the Win XP Install readme as far as step 9 without > problem > > net start postmaster fails with > FATAL: File /usr/share/postgresql/data/PG_VERSION is missing. This is > not a valid data directory. > > The database was initialised ok acording to messages received at step > 8. > > Any idea what I am doing wrong please? Is the postmaster running under the same account as the one that ran initdb? What are the permissions of /usr/share/postgresql/data and the files contained in it: $ ls -dl /usr/share/postgresql/data drwx------+ 6 postgres None 4096 Jul 14 07:50 /usr/share/postgresql/data $ ls -l /usr/share/postgresql/data total 14 -rw------- 1 postgres None 4 May 29 07:31 PG_VERSION drwx------+ 4 postgres None 0 May 29 07:32 base drwx------+ 2 postgres None 4096 Jul 14 07:50 global drwx------+ 2 postgres None 0 May 29 07:32 pg_clog -rw------- 1 postgres None 2329 May 29 07:32 pg_hba.conf -rw------- 1 postgres None 1441 May 29 07:32 pg_ident.conf drwx------+ 2 postgres None 0 May 29 07:32 pg_xlog -rw------- 1 postgres None 5178 May 29 07:32 postgresql.conf -rw------- 1 postgres None 59 Jul 14 07:50 postmaster.opts -rw------- 1 postgres None 52 Jul 14 07:50 postmaster.pid Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Roger, Please keep your replies on-list. On Mon, Jul 14, 2003 at 01:54:20PM +0100, Roger @ LetsGetSet wrote: > ----- Original Message ----- > From: "Jason Tishler" <jason@tishler.net> > To: "Roger Ackroyd" <postgresql@ackroyd.freeserve.co.uk> > Cc: <pgsql-cygwin@postgresql.org> > Sent: Monday, July 14, 2003 1:28 PM > Subject: Re: [CYGWIN] Problem starting postmaster on Win XP Home > > > > Any idea what I am doing wrong please? > > > > Is the postmaster running under the same account as the one that ran > > initdb? What are the permissions of /usr/share/postgresql/data and > > the files contained in it: > > Did everything from step 1 (in NT services section) to step 7. (net > start ipc-daemon) in Owner account then switched to postgres account > for initdb, then switched back to Owner to start the postmaster > following is from Owner account > > > > $ ls -dl /usr/share/postgresql/data > > [snip] > > > From postgres account it is same. the only permissions I changed > > were the chmod for /tmp /usr/bin /usr/bin/* I have seen similar reports by other XP Home users. Sorry, but I do not have access to this platform. Hopefully, another XP Home user will help you out. Otherwise, you will have to debug this yourself. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
As might have been expected, getting postmaster running was not end of story. Attached is result of attempting step [10] (psql ...) from each account and current listing of .../data directory from each account. Roger p.s. I will get the proper drill-down on posting to this this list - promise.
Attachment
See note [16] http://archives.postgresql.org/pgsql-cygwin/2003-07/msg00004.php -----Original Message----- From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Roger Ackroyd Sent: Wednesday, July 16, 2003 5:24 AM To: pgsql-cygwin@postgresql.org Subject: Re: [CYGWIN] Problem starting postmaster on Win XP Home As might have been expected, getting postmaster running was not end of story. Attached is result of attempting step [10] (psql ...) from each account and current listing of .../data directory from each account. Roger p.s. I will get the proper drill-down on posting to this this list - promise.
Roger, On Wed, Jul 16, 2003 at 10:23:50AM +0100, Roger Ackroyd wrote: > Owner@gabriel / > $ psql -U postgres template1 > psql: could not connect to server: Bad file descriptor > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > postgres@gabriel / > $ psql -U postgres template1 > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. See the following: http://cygwin.com/ml/cygwin/2003-07/msg00920.html > Owner@gabriel / > $ ls -dl /usr/share/postgresql/data > drwx------+ 2 postgres None 0 Jul 16 02:53 /usr/share/postgresql/data > > Owner@gabriel / > $ ls -l /usr/share/postgresql/data > total 0 The above is as expected. > postgres@gabriel / > $ ls -dl /usr/share/postgresql/data > drwx------+ 6 postgres None 0 Jul 16 02:53 /usr/share/postgresql/data > > postgres@gabriel / > $ ls -l /usr/share/postgresql/data > total 14 > -rw------- 1 postgres None 4 Jul 16 02:50 PG_VERSION > drwx------+ 4 postgres None 0 Jul 16 02:51 base > drwx------+ 2 postgres None 0 Jul 16 02:53 global > drwx------+ 2 postgres None 0 Jul 16 02:50 pg_clog > -rw------- 1 postgres None 2329 Jul 16 02:50 pg_hba.conf > -rw------- 1 postgres None 1441 Jul 16 02:50 pg_ident.conf > drwx------+ 2 postgres None 0 Jul 16 02:50 pg_xlog > -rw------- 1 postgres None 5178 Jul 16 02:50 postgresql.conf > -rw------- 1 postgres None 59 Jul 16 02:53 postmaster.opts > -rw------- 1 postgres None 51 Jul 16 02:53 postmaster.pid Ditto. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Jason, Seth, ... It was indeed the cygwin1.dll Easily got my JDBC driver connection Ok. Apologies to Jason over my confusion with regard interpretation of cygrunsrv atts. Thanks for your help and patience. I learned a lot, so I am also indebted to you for that tutorage. Regards Roger Start on JBoss now! If you have any comments on that.
Roger, On Wed, Jul 16, 2003 at 10:43:06PM +0100, Roger Ackroyd wrote: > Thanks for your help and patience. You are welcome. > I learned a lot, IMO, the knowledge gained is usually correlated to the pain felt... :,) > so I am also indebted to you for that tutorage. Are you willing to return the favor? If so, can you summarize what you needed to do to get PostgreSQL running under XP Home? Or, at least confirm that Seth's version of my README is accurate? Or, tweak his README, if necessary? Thanks, Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Yes that would would be good for some help on how people have managed to get this to work. Jason Tishler <jason@tishler.net> wrote: > Roger, > > On Wed, Jul 16, 2003 at 10:43:06PM +0100, Roger Ackroyd wrote: > > Thanks for your help and patience. > > You are welcome. > > > I learned a lot, > > IMO, the knowledge gained is usually correlated to the pain felt... :,) > > > so I am also indebted to you for that tutorage. > > Are you willing to return the favor? If so, can you summarize what you > needed to do to get PostgreSQL running under XP Home? Or, at least > confirm that Seth's version of my README is accurate? Or, tweak his > README, if necessary? > > Thanks, > Jason