Re: SQL on startup

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: SQL on startup
Дата
Msg-id Pine.LNX.4.30.0101192357400.1322-100000@peter.localdomain
обсуждение исходный текст
Ответ на SQL on startup  (Nathan Heagy <nathan@frontlogic.com>)
Список pgsql-general
Nathan Heagy writes:

> I have some sql that creates some operators which I want to be made
> available to every connection. Can I run this SQL when postmaster
> starts? Is there a way to execute it as the db root user so that the
> operators will be available to everyone that connects?

Once you have created the operators they are there persistently.  They do
not get dropped when the server is shut down.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


В списке pgsql-general по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Re: is PG able to handle a >500 GB Database?
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Re: initdb doesn not create template1 database