Re: Problem starting postmaster on Win XP Home

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