On Jun 29, 2005, at 9:01 AM, Sven Willenberger wrote:
Unix user root (and any psql superuser) the vacuum runs fine. It is
when
the unix user is non-root (e.g. su -l pgsql -c "vacuumdb -a -z") that
this memory error occurs. All users use the "default" class for
login.conf purposes which has not been modified from its installed
settings. Any ideas on how to a) troubleshoot this or b) fix this
(if it
is something obvious that I just cannot see).
This doesn't make sense: the actual command is executed by the
backend postgres server, so the uid of the client program doens't
make a bit of difference.
You need to see exactly who is generating that error. It certainly
is not the Pg backend.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
