Sven Willenberger <sven(at)dmv(dot)com> writes:
> ERROR: out of memory
> DETAIL: Failed on request of size 536870910.
That's a server-side failure ...
> 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
That's fairly hard to believe, assuming that you are talking to the same
server in both cases (I have seen trouble reports that turned out to be
because the complainant was accidentally using two different servers...)
The ulimit the backend is running under couldn't change depending on
where the client is su'd to.
Is it possible that you've got per-user configuration settings that
affect this, like a different maintenance_mem value for the root user?
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Douglas McNaught||Date: 2005-06-29 15:29:05|
|Subject: Re: how to use pg_dump and then restored onto development server|
|Previous:||From: Tom Lane||Date: 2005-06-29 15:16:50|
|Subject: Re: CVS Build - No Doc |