Re: postgresql & sid

[Florian Kulzer <florian.kulzer+debian@icfo.es>]

On Fri, Apr 10, 2009 at 00:58:05 +0430, Mohsen Pahlevanzadeh wrote:
> Dear all,
> When i use dpkg -l "postgresql*" i see following output:

[ snip: the relevant packages seem to be installed ]

> When i use debian:/home/mohsen# /etc/init.d/postgresql-8.3 start
> debian:/home/mohsen# 
> 
> I didn't see any output.
> Then i run su postgres
> & run psql & see following output:
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
> ////////////////////////////////////////////
> What's my problem?Please help me.....

Did you check the documentation in /usr/share/doc/postgresql-8.3* ,
especially "README.Debian(.gz)" files? (It's been a while since I used
postgresql myself, so I lost track of its current status in Debian.)

You should also check if the process is actually running, as well as
which ports and sockets it has open. Run as root:

ps -ef | grep [p]ostgresql

lsof -U | grep [p]ostgresql

lsof -i | grep [p]ostgresql

-- 
Regards,            | http://users.icfo.es/Florian.Kulzer
          Florian   |