pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-admin@postgresql.org
Subject: Re: running a SQL command at startup time
Date: Wed, 17 Oct 2007 08:04:09 -0600
Message-ID: <200710170804.09748.kevin@kevinkempterllc.com> (raw)
In-Reply-To: <20071017094445.59E779FB981@postgresql.org>
References: <20071017094445.59E779FB981@postgresql.org>

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] ?
---------------------------------------------------------------------------





view thread (2+ messages)

Message-ID: <200710170804.09748.kevin@kevinkempterllc.com>
Permalink:  ../200710170804.09748.kevin@kevinkempterllc.com/
Also on:    postgresql.org/message-id/200710170804.09748.kevin@kevinkempterllc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: kevin@kevinkempterllc.com
  Subject: Re: running a SQL command at startup time
  In-Reply-To: <200710170804.09748.kevin@kevinkempterllc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox