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

Juergen Dankoweit Juergen.Dankoweit at T-Online.de
Wed Jun 29 20:06:14 GMT 2005


Hello,

Am Mittwoch, den 29.06.2005, 14:59 -0400 schrieb Vivek Khera:
> 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.

Sorry for that possible stupid question. But why do you think that the
PG backend does not generate the error?
I use PostgreSQL since many years under FreeBSD and it is the first time
to hear from such an error.

Best regards

Jürgen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20050629/ba1bd12b/attachment.bin


More information about the freebsd-stable mailing list