Re: User access to start and stop postmaster

"Andy Marden" <amarden@usa.net> writes:

> I'm running a batch load on PostgreSQL 7.1.3 on Linux as a given OS user. As
> part of this, I want to restart postmaster with -i access removed and at the
> end, restart with -i added on (denying network access during the load
> process). Trouble is, it seems that I have to be the postgres user to do
> this - I'd hoped that being part of the postgres group would be enough. Has
> anyone thoughts on how to achieve this (short of running everything as the
> postgres user.
>
> Load scripts are Perl, by the way.

Hmmm, instead of shutting off network access, maybe you could just get
an exclusive lock on all your tables in the load script?  You'd have
to do all the loading in one transaction but that's the fastest way to
do it anyhow.

Thought I'd suggest it...

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863