Re: automatic restart on reboot

From: Dan Langille <dan(at)langille(dot)org>
To: "Aurangzeb M(dot) Agha" <aagha(at)bigfoot(dot)com>
Cc: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: automatic restart on reboot
Date: 2003-01-13 01:03:04
Message-ID: 20030112200046.D92090-100000@m20.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 12 Jan 2003, Aurangzeb M. Agha wrote:

> I'm deploying Postgres on a production environment and wanted to know if
> people could share what steps they've taken to have their DB's come back
> up on system reboot (either on purpose or accidental).
>
> Are there any things to check for?
>
> What about postmaster.pid, /tmp/blah..., etc... Any script examples would
> be appreciated.

On FreeBSD, this is handled by the script /usr/local/etc/rc.d/010.pgsql.sh
and you can view the latest copy at:

http://www.freebsd.org/cgi/cvsweb.cgi/~checkout~/ports/databases/postgresql7/files/pgsql.sh.tmpl?rev=1.14

Files in /usr/local/etc/rc.d/ which are +x and have a .sh suffx are
automatically run at boot time.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-13 01:39:03 Re: automatic restart on reboot
Previous Message Aurangzeb M. Agha 2003-01-12 21:47:50 automatic restart on reboot