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