Re: How to check whether PostgreSQL server is up and running?

[Jan Muhammad <janmuhd@xxxxxxxxx>]

Hi,

Got it working now, though after several searches and hit-n-trials....

The problem was in my "/pgsql/data/pg_hba.conf"; where it needed my machine's IP.
Now got it working.

But the real issue of service is not yet being recognized  with in the command:
# service postgresql status
postgresql: unrecognized service
Or even:
#service pg_ctl status
pg_ctl: unrecognized service

And strange is  when I do:
# /sbin/service --status-all
I can see among other service (pg_ctl) running:
pg_ctl: server is running (PID: 29330)
/usr/local/pgsql/bin/postgres "-i" "-D" "/usr/local/pgsql/data"


Don't know what is/was issue; but anyways Thanks for helping.

Regards

-Jan Muhammad
--- On Fri, 5/8/09, dayat <sql.muda@xxxxxxxxxxx> wrote:

From: dayat <sql.muda@xxxxxxxxxxx>
Subject: Re: How to check whether PostgreSQL server is up and running?
To: pgsql-admin@xxxxxxxxxxxxxx
Date: Friday, May 8, 2009, 9:42 PM

Ok let's to create a cluster for you, be sure the pg8 directory owned by postgres user and the directory is empty.

 

[postgres@callisto]$ initdb -D /usr/local/pgsql/postgresql-8.3.7/pg8 -U postgres -W

 

Type your password if they ask, wait initdb process until finish.

 

And try the server:

[postgres@callisto]$ pg_ctl -D /usr/local/pgsql/postgresql-8.3.7/pg8 start

 

enter to database postgres with user postgres and type your password

[postgres@callisto]$ psql postgres postgres -W

 

Tell me if this not work.

 

Regards

Hidayat

 

----- Original Message -----

From: Jan Muhammad

To: pgsql-admin@xxxxxxxxxxxxxx

Sent: Friday, May 08, 2009 4:11 PM

Subject: How to check whether PostgreSQL server is up and running?

Hi,

After having various error message in starting PostgreSQL version 8.2.11; finally uninstalled/deleted it. Now trying my luck on  8.3.7, but things haven't changed for me.
When I try to check that postmaster server is running or not? I get the following error:
$ postmaster -D /usr/local/pgsql/data
LOG:  could not translate host name "localhost", service "5432" to address: Name or service not known
WARNING:  could not create listen socket for "localhost"
FATAL:  could not create any TCP/IP sockets
.......................................................................
Similarly when I try to start postgres server with
[postgres@callisto postgresql-8.3.7]$ pg_ctl -D pg8 start
postgres cannot access the server configuration file "/usr/local/pgsql/postgresql-8.3.7/pg8/postgresql.conf": No such file or directory
server starting

Have no idea what's wrong and where the problem is? Do I need to change/edit some of Environment variable settings or what? Or should I reinstall PostgreSQL with Yum?? Or should give up using PostgreSQL and switch to some other DB like MySQL etc... No idea what to do.....?

Thanks in advance for help.

-Jan Muhammad