PostgreSQL under Cygwin...
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
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@bellsouth.net_mapson> wrote in message
news:ksrg8.43009$sH1.2880833@e3500-atl2.usenetserver.com...
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
Show quoted text
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 INTThis 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
It gives me
psql: could not connect to server: Connection refused
Is the server running on host superfly and accepting
TCP/IP connections on port 5432?
if I use the --host option without using the -i option when starting
postmaster. However, if I start postmaster with the -i option and use
the --host option on psql, I get the same error message as stated before and
the PostgreSQL service stops.
"Michael Ben-David" <nospam_mikebd@iname.com_mapson> wrote in message
news:a667fe$2fpp$1@jupiter.hub.org...
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
Show quoted text
be with 7.2
"Randy Widell" <nospam_rwidell@bellsouth.net_mapson> wrote in message
news:ksrg8.43009$sH1.2880833@e3500-atl2.usenetserver.com...I am running (or attempting to run) PostgreSQL 7.2 under Cygwin
under WindowsXP. I have the latest version of everything for Cygwin, Ihave
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 INTThis 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