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