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

From Douglas McNaught
Subject Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users
Date
Msg-id m2ekal2puy.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Re: PostgreSQL's vacuumdb fails to allocate memory for  (Sven Willenberger <sven@dmv.com>)
List pgsql-general
Sven Willenberger <sven@dmv.com> writes:

>                           Again, if I log in as myself and try to run
> the command vaccumdb -a -z it fails; if I su to root and repeat it works
> fine. I am trying to narrow this down to a PostgreSQL issue vs FreeBSD
> issue.

That's really weird, because in both cases the actual VACUUM work
happens in the backend, which should be running as 'postgres'.  I
don't see how the client user could possibly make a difference.

-Doug

pgsql-general by date:

Previous
From: "Peter L. Berghold"
Date:
Subject: Memory tuning for linux (Suffering CRS...)
Next
From: David Fetter
Date:
Subject: Re: faking writable views as tables