Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 946582E304E for ; Thu, 3 Jan 2008 08:56:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 01673-03 for ; Thu, 3 Jan 2008 08:56:30 -0400 (AST) Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 10B582E2ED7 for ; Thu, 3 Jan 2008 08:56:37 -0400 (AST) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 17AA777528; Thu, 3 Jan 2008 13:56:34 +0100 (CET) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: get PGDATA as non-postgres user Date: Thu, 3 Jan 2008 13:56:32 +0100 User-Agent: KMail/1.9.7 Cc: "Sofer, Yuval" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200801031356.32607.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/40 X-Sequence-Number: 27814 Am Donnerstag, 3. Januar 2008 schrieb Sofer, Yuval: > I need to get PGDATA location when I logged in as non-postgres user. Consider writing a security-definer function that retrieves the information. -- Peter Eisentraut http://developer.postgresql.org/~petere/