Re:

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re:
Дата
Msg-id Pine.LNX.4.30.0111091643590.31182-100000@chapelperilous.net
обсуждение исходный текст
Ответ на ...  (Guido <lampo.14@iol.it>)
Список pgsql-novice
On Thu, 8 Nov 2001, Guido wrote:

> I can't run postmaster.
>
> The terms of the problems are:
>
> Distro - RH 7.1
> PGSQL - 7.1.3
> I've setup the rc.d script with <chkconfig -add> so to have Postgresql
> start at system boot and it works fine!
> Now, in order to connect to the DB with a Java application, I need to
> configure the Postgres server in order to accept TCP/IP connection. The
> Programmer's Guide says to supply the -i flag when starting the postmaster,
> but, I think, I'm already running the postmaster.
> My question is :
>     How can I enable the TCP/IP connection with the database already
> running?
>
> I've tried with the postmaster -i but I receive the following message:
>     Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
>     Is another postmaster (pid 801) running in "/var/lib/pgsql/data"?

You need to shut the postmaster down ('kill 801' will do it), then start
it back up with the -i parameter.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Another megabytes the dust.


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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Using output of pg_ctl for benchmarking?
Следующее
От: Francisco Reyes
Дата:
Сообщение: Different results based on number of records out of same query