| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Remote Connection |
| Date: | 2009-02-13 23:13:59 |
| Message-ID: | 4995FEB7.8050503@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Mason | 2009-02-14 02:55:32 | Re: can't figure string compare result (using also custom C function) |
| Previous Message | Edoardo Panfili | 2009-02-13 22:54:04 | Re: can't figure string compare result (using also custom C function) |