From owner-freebsd-stable@FreeBSD.ORG Wed Jun 29 20:06:14 2005 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4B18316A41C for ; Wed, 29 Jun 2005 20:06:14 +0000 (GMT) (envelope-from Juergen.Dankoweit@t-online.de) Received: from mailout02.sul.t-online.com (mailout02.sul.t-online.com [194.25.134.17]) by mx1.FreeBSD.org (Postfix) with ESMTP id C465843D1D for ; Wed, 29 Jun 2005 20:06:13 +0000 (GMT) (envelope-from Juergen.Dankoweit@t-online.de) Received: from fwd19.aul.t-online.de by mailout02.sul.t-online.com with smtp id 1Dnidu-0002C7-03; Wed, 29 Jun 2005 21:54:42 +0200 Received: from mailsmtp.juergendankoweit.net (XBZNOeZUweQir5d1UQEfLXcBG8RXlakUiCyhNYqs+JqupOlUpO8oo+@[84.150.90.2]) by fwd19.sul.t-online.de with esmtp id 1Dnidn-17O69g0; Wed, 29 Jun 2005 21:54:35 +0200 Received: from localhost.juergendankoweit.net (localhost.juergendankoweit.net [127.0.0.1]) by mailsmtp.juergendankoweit.net (Postfix) with ESMTP id EF89833F96 for ; Wed, 29 Jun 2005 21:54:34 +0200 (CEST) Received: from mailsmtp.juergendankoweit.net (localhost.juergendankoweit.net [127.0.0.1]) by localhost.juergendankoweit.net (AvMailGate-2.0.2-9) id 03054-10AD0DFD; Wed, 29 Jun 2005 21:54:34 +0200 Received: from primergy470.juergendankoweit.net (primergy470.juergendankoweit.net [192.168.1.1]) by mailsmtp.juergendankoweit.net (Postfix) with ESMTP id 3723333F81 for ; Wed, 29 Jun 2005 21:54:34 +0200 (CEST) From: Juergen Dankoweit To: freebsd-stable@freebsd.org 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> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-kf7HwcHL6wZVq/mR9Cha" Date: Wed, 29 Jun 2005 21:54:33 +0200 Message-Id: <1120074873.1720.3.camel@primergy470.juergendankoweit.net> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 FreeBSD GNOME Team Port X-AntiVirus: checked by AntiVir MailGate (version: 2.0.2-9; AVE: 6.31.0.7; VDF: 6.31.0.122; host: primergy470.juergendankoweit.net) X-ID: XBZNOeZUweQir5d1UQEfLXcBG8RXlakUiCyhNYqs+JqupOlUpO8oo+ X-TOI-MSGID: ecc8256f-5ee0-447f-b640-cf87e3755a3f Subject: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Juergen.Dankoweit@T-Online.de List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 29 Jun 2005 20:06:14 -0000 --=-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--