Re: Remote Connection

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"