Re: PostgreSQL under Cygwin...

try adding the -h <hostname> argument to createdb and psql or set the PGHOST
environment variable. I don't think this was required with 7.1 but seems to
be with 7.2

"Randy Widell" <nospam_rwidell(at)bellsouth(dot)net_mapson> wrote in message
news:ksrg8(dot)43009$sH1(dot)2880833(at)e3500-atl2(dot)usenetserver(dot)com(dot)(dot)(dot)
> I am running (or attempting to run) PostgreSQL 7.2 under Cygwin
> under WindowsXP. I have the latest version of everything for Cygwin, I
have
> the ipc-daemon service running, and I installed postmaster as a service
> using the command:
>
> cygrunsrv --install PostgreSQL --path /bin/postmaster --args "-D
> /usr/local/share/postdb"
> --user Randy --dep ipc-daemon --termsig INT
>
> This service starts fine too...
>
> Then I tried to create a new database: createdb Randy.
> createdb fails with the message:
>
> psql: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> createdb: database creation failed
>
> ...and the PostgreSQL service stops.
>
> I tried: psql template0 ...and got basically the same message, and the
> service stopped again.
>
> So... Any ideas? Any at all would be greatly appreciated.
>
> Thanks,
> Randy Widell
>
>
>
>