Re: Remote Connection - Mailing list pgsql-general

From John R Pierce
Subject Re: Remote Connection
Date
Msg-id 4995FEB7.8050503@hogranch.com
Whole thread Raw
In response to Re: Remote Connection  ("Bob Pawley" <rjpawley@shaw.ca>)
List 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 by date:

Previous
From: Edoardo Panfili
Date:
Subject: Re: can't figure string compare result (using also custom C function)
Next
From: Sam Mason
Date:
Subject: Re: can't figure string compare result (using also custom C function)