PostgreSQL's vacuumdb fails to allocate memory for non-root users

Vivek Khera vivek at
Wed Jun 29 18:59:49 GMT 2005

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.

More information about the freebsd-stable mailing list