X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 971419FB394; Sat, 9 Sep 2006 09:06:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19806-10; Sat, 9 Sep 2006 09:06:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from svana.org (svana.org [125.62.87.134]) by postgresql.org (Postfix) with ESMTP id DEEE79FB25A; Sat, 9 Sep 2006 09:06:31 -0300 (ADT) Received: from kleptog by svana.org with local (Exim 4.50) id 1GM1bB-00037o-CE; Sat, 09 Sep 2006 22:06:13 +1000 Date: Sat, 9 Sep 2006 14:06:13 +0200 From: Martijn van Oosterhout To: Purusothaman A Cc: "Milen A. Radev" , pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. Message-ID: <20060909120613.GA10336@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: Purusothaman A , "Milen A. Radev" , pgsql-admin@postgresql.org, pgsql-general@postgresql.org References: <3650d0d50609090407j237bb710h9bde1675c773925d@mail.gmail.com> <3650d0d50609090449q2aec1098xc3b62dd169de5843@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="MGYHOYXEY6WxJCY8" Content-Disposition: inline In-Reply-To: <3650d0d50609090449q2aec1098xc3b62dd169de5843@mail.gmail.com> X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: User-Agent: Mutt/1.5.9i X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: kleptog@svana.org X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.085 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/75 X-Sequence-Number: 22989 --MGYHOYXEY6WxJCY8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Sep 09, 2006 at 05:19:26PM +0530, Purusothaman A wrote: > I usually log in to postgresql server with admin username. >=20 > But whatever its, according to documentation, if client machine's user has > write access > permission, this query should successfully be executed. Read carefully, you are using the server-side functions, therefore: "These two functions read and write files in the server's file system, using the permissions of the database's owning user." What your client user is is irrelevent. Perhaps you actually want to use the client-side functions? Have a nice day, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to l= itigate. --MGYHOYXEY6WxJCY8 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFFAq41IB7bNG8LQkwRAsptAKCDSWuRI5T+JMqpWEQt7r69kJE6CwCfVTOO mOqGDNQBTZZDs4WVf6NM+wQ= =kT4s -----END PGP SIGNATURE----- --MGYHOYXEY6WxJCY8--