Date: Wed, 29 Jun 2005 14:59:46 -0400 From: Vivek Khera <vivek@khera.org> To: postgres general <pgsql-general@postgresql.org> Cc: stable@freebsd.org Subject: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users Message-ID: <58067976-00C6-4380-90DF-F448D9008C81@khera.org> In-Reply-To: <1120050088.19603.7.camel@lanshark.dmv.com> References: <1120050088.19603.7.camel@lanshark.dmv.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?58067976-00C6-4380-90DF-F448D9008C81>