cat /path/to/database/postmaster.pid
the first line should be your process id.
ps -aux | grep "process id"
you should get something back like /usr/bin/postmaster, if you don't
your database is not running, you need to delete the file and stop/start
postgresql
Robert Treat
On Sat, 2003-02-01 at 19:05, news.verizon.net wrote:
> Erwin Moller,
>
> I made the configuration settings you mentioned in the thread below, but I'm
> still getting the same error message below. It seems that I've now setup the
> server to accept TCP/IP connections ans except connections/requests from all
> local users on my system, but I'm still getting the same error message.....
> I don't understand what's wrong because when I go into the 'services' on my
> redhat linux 8 machine and restart the service postgresql, it restarts the
> server acceptionally - without any problems reported.... is their anything
> I'm missing that needs to be done to setup a user account and define the
> area where their database info and all is.... I've bought this book on
> postgre sql, but the book assumes you already have ther server setup to
> accept users.
>