Re: Problem starting postmaster on Win XP Home

Roger,

On Wed, Jul 16, 2003 at 10:23:50AM +0100, Roger Ackroyd wrote:
> Owner(at)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(at)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(at)gabriel /
> $ ls -dl /usr/share/postgresql/data
> drwx------+ 2 postgres None 0 Jul 16 02:53 /usr/share/postgresql/data
>
> Owner(at)gabriel /
> $ ls -l /usr/share/postgresql/data
> total 0

The above is as expected.

> postgres(at)gabriel /
> $ ls -dl /usr/share/postgresql/data
> drwx------+ 6 postgres None 0 Jul 16 02:53 /usr/share/postgresql/data
>
> postgres(at)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