From: | Kevin Kempter <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: running a SQL command at startup time |
Date: | 2007-10-17 14:04:09 |
Message-ID: | 200710170804.09748.kevin@kevinkempterllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wednesday 17 October 2007 03:05:22 Alexis Beuraud wrote:
> Hello all
>
> Is there a way to execute a SQL script whenever the Postgres server starts
> up?
> I would like to run the SQL command "analyze" at startup time. (I might use
> more complicated scripts in the future).
>
> I have not found any related entry in postgresql.conf.
> I have been looking for the keywords init, startup in the FAQ and the
> mailing lists but I have not found the answer.
> Please provide an answer which would work both on Windows and Linux.
> Regards,
> Alexis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
for a UNIX/Linux box you could tweak the postgresql service script
(i.e. /etc/init.d/postgresql) adding the analyze to the start (and restart if
desired) processes
/Kevin
--------------------------------------------------------------------------
Your mouse has moved.
Windows must restart to affect the change(s)
Reboot now [Y/y] ?
---------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Krogh | 2007-10-17 14:18:21 | Upgrade time, dump+restore trouble. |
Previous Message | Greg Caulton | 2007-10-17 12:26:56 | Re: installation automation |