Date: Wed, 29 Jun 2005 21:54:33 +0200 From: Juergen Dankoweit <Juergen.Dankoweit@T-Online.de> To: freebsd-stable@freebsd.org Subject: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users Message-ID: <1120074873.1720.3.camel@primergy470.juergendankoweit.net> In-Reply-To: <58067976-00C6-4380-90DF-F448D9008C81@khera.org> References: <1120050088.19603.7.camel@lanshark.dmv.com> <58067976-00C6-4380-90DF-F448D9008C81@khera.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--=-kf7HwcHL6wZVq/mR9Cha Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, Am Mittwoch, den 29.06.2005, 14:59 -0400 schrieb Vivek Khera: > On Jun 29, 2005, at 9:01 AM, Sven Willenberger wrote: >=20 > > Unix user root (and any psql superuser) the vacuum runs fine. It is =20 > > 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 =20 > > (if it > > is something obvious that I just cannot see). >=20 > This doesn't make sense: the actual command is executed by the =20 > backend postgres server, so the uid of the client program doens't =20 > make a bit of difference. >=20 > You need to see exactly who is generating that error. It certainly =20 > 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=C3=BCrgen --=-kf7HwcHL6wZVq/mR9Cha Content-Type: application/pgp-signature; name=signature.asc Content-Description: Dies ist ein digital signierter Nachrichtenteil -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iD8DBQBCwvx5oKqsUmo8Y68RAlDuAKDr0pps13VCUcKTyLWNnvmalHV/+wCg01Tp vwCl5xemaI27qPU1Bs6azkM= =WbWf -----END PGP SIGNATURE----- --=-kf7HwcHL6wZVq/mR9Cha--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1120074873.1720.3.camel>