Re: SQL on startup - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: SQL on startup
Date
Msg-id Pine.LNX.4.30.0101192357400.1322-100000@peter.localdomain
Whole thread Raw
In response to SQL on startup  (Nathan Heagy <nathan@frontlogic.com>)
List 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 by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Re: is PG able to handle a >500 GB Database?
Next
From: Jan Wieck
Date:
Subject: Re: Re: initdb doesn not create template1 database