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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster