Re: Remote Connection

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Remote Connection
Дата
Msg-id 4995FEB7.8050503@hogranch.com
обсуждение исходный текст
Ответ на Re: Remote Connection  ("Bob Pawley" <rjpawley@shaw.ca>)
Список pgsql-general
Bob Pawley wrote:
> In pg_hba there is a reference to reloading postmaster using pg_ctl.
>
> Does postmaster reload when the server is restarted??


depending on your OS, there's a variety of ways of forcing the
postmaster to reload or restart....

some changes require a restart, like LISTEN_ADDRESS, others just a
reload (pg_hba.conf changes), so for a restart, just replace the word
reload with restart in the following...

RHEL, Fedora, CentOS...

    # service postgresql reload

other SysV init based systems...

    # /etc/init.d/postgresql reload

Solaris 10, using SMF...

   # svcadm refresh svc:/application/database/postgresql:version_82_64bit
(or restart instead of refresh, and the service name will vary per the
version)

most Unix systems without a OS specific service manager script...

    # su - postgres -c "pg_ctl reload -D /path/to/pg/data"



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

Предыдущее
От: Edoardo Panfili
Дата:
Сообщение: Re: can't figure string compare result (using also custom C function)
Следующее
От: Sam Mason
Дата:
Сообщение: Re: can't figure string compare result (using also custom C function)