Postgresql connection error on Debian

[jimbobx]

Hi all,

I get an postgres error during install on a debain etch server. When I try to configure the database user, the folloeing error occurs:

Etch:/opt/scalix-postgres/bin# ./sxpsql-setpwd <mypassword>

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/opt/scalix/e4/postgres/data/.s.PGSQL.5733"?

Postgres server runs:

Etch:/opt/scalix-postgres/bin# ps -ef | grep postgres
postgres 14863 1 0 13:03 ? 00:00:00 /usr/lib/postgresql/7.4/bin/postmaster -D /var/lib/postgresql/7.4/main
postgres 14870 14863 0 13:03 ? 00:00:00 postgres: stats buffer process
postgres 14871 14870 0 13:03 ? 00:00:00 postgres: stats collector process
postgres 14883 1 0 13:03 ? 00:00:00 /usr/lib/postgresql/7.4/bin/pg_autovacuum -p 5432 -H /var/run/postgresql -L /var/log/postgresql/pg_autovacuum-7.4-main.log

The directory has write access to the everyone, but the file ".s.PGSQL.5733" is not created.
Postgres server configuration is the debian packages default.

I use the "Manual Installation on Debian Etch" script installing Scalix 11.1.0.

Any help would be appreciated,

Martin

[jimbobx]

Ok, no socket connection can be established on Port 5733:

/var/opt/scalix/e4/postgres/pgstartup.log
LOG: could not bind IPv4 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5733? If not, wait a few seconds and retry.
FATAL: could not create listen socket for "xxx.yyy.com"

netstat output looks like this:

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:5729 0.0.0.0:* LISTEN 17483/advmail.sckd
tcp 0 0 127.0.0.1:8005 0.0.0.0:* LISTEN 17607/java
tcp 0 0 0.0.0.0:389 0.0.0.0:* LISTEN 17498/omslapd
tcp 0 0 0.0.0.0:5768 0.0.0.0:* LISTEN 17517/sxeventserver
tcp 0 0 127.0.0.1:587 0.0.0.0:* LISTEN 18236/sendmail: MTA
tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 17549/pop3.server
tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 17506/in.imap41d
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 10878/apache2
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 948/sshd
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 18293/postmaster
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 18236/sendmail: MTA
tcp 0 0 10.255.46.208:25 0.0.0.0:* LISTEN 17510/omsmtpd SMTP
tcp 0 0 127.0.0.1:5757 0.0.0.0:* LISTEN 7911/ldapmapper
udp 0 0 10.255.46.208:5766 0.0.0.0:* 17494/omnssck
udp 0 0 127.0.0.1:5766 0.0.0.0:* 17494/omnssck
udp 0 0 127.0.0.1:32923 127.0.0.1:32923 ESTABLISHED18293/postmaster
udp 0 0 0.0.0.0:68 0.0.0.0:* 17978/dhclient3
udp 0 0 0.0.0.0:5757 0.0.0.0:* 17501/omdrs

[jimbobx]

Ok, solved.

I was using a Amazon EC2 node for testing and I had to add this to the /etc/hosts file:

127.0.0.1 xxx.yyy.com

Then It worked.