Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users - Mailing list pgsql-general

From Vivek Khera
Subject Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users
Date
Msg-id 58067976-00C6-4380-90DF-F448D9008C81@khera.org
Whole thread Raw
In response to PostgreSQL's vacuumdb fails to allocate memory for non-root users  (Sven Willenberger <sven@dmv.com>)
Responses Re: PostgreSQL's vacuumdb fails to allocate memory for  (Sven Willenberger <sven@dmv.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Zlatko Matic"
Date:
Subject: Re: how to use pg_dump and then restored onto development server
Next
From: Douglas McNaught
Date:
Subject: Re: how to use pg_dump and then restored onto development server