[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: postgresql & sid

On Sun, Apr 12, 2009 at 07:08:03PM +0200, Florian Kulzer wrote:
> On Fri, Apr 10, 2009 at 00:58:05 +0430, Mohsen Pahlevanzadeh wrote:
> > When i use debian:/home/mohsen# /etc/init.d/postgresql-8.3 start
> > debian:/home/mohsen# 
> > 
> > I didn't see any output.
> 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.)

Even if it is running you should get something. I get:

root@box:~# /etc/init.d/postgresql-8.3 start
Starting PostgreSQL 8.3 database server: main.

And if the file doesn't exist, well you get the usual:
/etc/init.d/postgresql-8.3: No such file or directory

So the OP should read thru that file, and see what is going on.

i.e. there is:
[ -r /usr/share/postgresql-common/init.d-functions ] || exit

It doesn't seem to be a "stock" install.

Disclaimer: I'm running Lenny, don't know status of Sid.
but http://bugs.debian.org/postgresql doesn't cast any light.

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

On lenny I get (maybe handy for comparison.)

> ps -ef | grep [p]ostgresql

postgres  2234     1  0 00:22 ?        00:00:01
/usr/lib/postgresql/8.3/bin/postgres -D /var/lib/postgresql/8.3/main -c

> lsof -U | grep [p]ostgresql

postgres 2234 postgres    6u  unix 0xc7818580      4554

> lsof -i | grep [p]ostgresql

postgres 2234 postgres    3u  IPv4   4552       TCP box:postgresql

Please excuse line wrapping.

I contend that we are both atheists. I just believe in one fewer god
than you do. When you understand why you dismiss all the other
possible gods, you will understand why I dismiss yours.
                                           -- Stephen F Roberts

Reply to: