Thread: restart and postgres.conf
Should "restart" with pg_ctl or /etc/init.d/postgres cause postgres.conf to be reread? It doesn't appear to do so for me (another oddity - after "restart" the last line in the log is "database system is shut down"). "stop" followed by "start" works fine. Feature request - add "reload" to /etc/init.d/postgres :) CSN __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
El Vie 17 Oct 2003 16:43, escribió:
> Should "restart" with pg_ctl or /etc/init.d/postgres
> cause postgres.conf to be reread? It doesn't appear to
> do so for me (another oddity - after "restart" the
> last line in the log is "database system is shut
> down"). "stop" followed by "start" works fine.
Maybe you are editing the wrong postgresql.conf file.
> Feature request - add "reload" to /etc/init.d/postgres
# /etc/init.d/postgresql
Uso: /etc/init.d/postgresql
{start|stop|status|restart|condrestart|reload|force-reload}
You should tell us what OS you are using.
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------
> El Vie 17 Oct 2003 16:43, escribi�:
> >> Should "restart" with pg_ctl or
> /etc/init.d/postgres
> >> cause postgres.conf to be reread? It doesn't
> appear
> to
> >> do so for me (another oddity - after "restart"
> the
> >> last line in the log is "database system is shut
> >> down"). "stop" followed by "start" works fine.
>
> > Maybe you are editing the wrong postgresql.conf
> file.
There's only one postgresql.conf on my system.
> >> Feature request - add "reload" to
> /etc/init.d/postgres
>
> ># /etc/init.d/postgresql
> >Uso: /etc/init.d/postgresql
>
>{start|stop|status|restart|condrestart|reload|force-reload}
>
> >You should tell us what OS you are using.
Redhat 9. I just looked in contrib/startup-scripts
for PG 7.3.4 and both scripts there have just
start/stop/restart/status.
CSN
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--- CSN wrote:
> > >> Feature request - add "reload" to
> > /etc/init.d/postgres
> >
> > ># /etc/init.d/postgresql
> > >Uso: /etc/init.d/postgresql
> >
>
>{start|stop|status|restart|condrestart|reload|force-reload}
> >
> > >You should tell us what OS you are using.
>
> Redhat 9. I just looked in contrib/startup-scripts
> for PG 7.3.4 and both scripts there have just
> start/stop/restart/status.
I just got a new Redhat 9 server and the more
option-filled startup script was in /etc/init.d. I
vote contrib/startup-scripts be updated with this
version, if possible :).
CSN
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com