Re: serverless postgresql

Tom Lane wrote:

>Jeff Bowden <jlb(at)houseofdistraction(dot)com> writes:
>
>
>>What about the notion of running postmaster on-demand as the user?
>>
>>
>
>Possibly. You'd have to think carefully about what conditions the
>postmaster should be shut down under, and especially what conditions
>it should NOT be shut down under --- eg, a kill to the parent client
>application shouldn't cause an ungraceful postmaster exit. It could
>be tricky to get the signal handling right, especially under shells that
>try to deliver signals to all children of a process being signaled.
>On the whole I suspect it'd be easier just to leave the postmaster
>running in the background...
>
>

Details, details.... :-)

>>Oh yeah, that brings me to another question. I was looking at the
>>postmaster command-line switches and I couldn't find any that would
>>allow me to point it at an arbitrary config file
>>
>>
>
>The config files all live in $PGDATA and so are determined by the -D
>switch. There was some talk of changing this, awhile back, but it
>foundered on lack of consensus about exactly what to do instead.
>
>

As long as it can be done.