running a SQL command at startup time - Mailing list pgsql-admin

From Alexis Beuraud
Subject running a SQL command at startup time
Date
Msg-id 20071017094445.59E779FB981@postgresql.org
Whole thread Raw
Responses Re: running a SQL command at startup time  (Kevin Kempter <kevin@kevinkempterllc.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Greg Caulton"
Date:
Subject: Re: installation automation
Next
From: "Moiz Kothari"
Date:
Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list?