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.
cheers
Andy