How to check whether PostgreSQL server is up and running?

Поиск
Список
Период
Сортировка
От Jan Muhammad
Тема How to check whether PostgreSQL server is up and running?
Дата
Msg-id 476250.40203.qm@web38704.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: How to check whether PostgreSQL server is up and running?  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Re: How to check whether PostgreSQL server is up and running?  ("dayat" <sql.muda@yahoo.co.id>)
Список pgsql-admin
Дерево обсуждения
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Andy Shellam
Дата:
Сообщение: Re: Getting image from a DB
Следующее
От: Michael Monnerie
Дата:
Сообщение: Re: How to check whether PostgreSQL server is up and running?