running a SQL command at startup time

Поиск
Список
Период
Сортировка
От Alexis Beuraud
Тема running a SQL command at startup time
Дата
Msg-id 20071017094445.59E779FB981@postgresql.org
обсуждение исходный текст
Ответы Re: running a SQL command at startup time  (Kevin Kempter <kevin@kevinkempterllc.com>)
Список 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 по дате отправления:

Предыдущее
От: "Greg Caulton"
Дата:
Сообщение: Re: installation automation
Следующее
От: "Moiz Kothari"
Дата:
Сообщение: Re: Is there a way to kill a connection from the pg_stat_activitly list?