X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2812652A74 for ; Fri, 4 Mar 2005 14:40:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78642-07 for ; Fri, 4 Mar 2005 14:40:15 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 985B952A68 for ; Fri, 4 Mar 2005 14:40:14 +0000 (GMT) Received: (qmail 19210 invoked by uid 500); 4 Mar 2005 14:56:00 -0000 Date: Fri, 4 Mar 2005 08:56:00 -0600 From: Bruno Wolff III To: juanmime@ono.com Cc: pgsql-admin@postgresql.org Subject: Re: How to deny remote backups ? Message-ID: <20050304145600.GB17492@wolff.to> Mail-Followup-To: juanmime@ono.com, pgsql-admin@postgresql.org References: <421310210000F6B1@resmta01.ono.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <421310210000F6B1@resmta01.ono.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/42 X-Sequence-Number: 16540 On Thu, Mar 03, 2005 at 09:45:47 +0100, juanmime@ono.com wrote: > > The user DB that connects to the remote DB has insert and delete permissions > (he is the owner of the DB). > > The question is ... how can I block or forbide the remote DB duplication > ?. I think that a remote person that knows the user DB and his password, > can connect to the DB and make a pg_dump of the DB. Only by not letting the user SELECT the data. If they can see it, they can copy it. If the users really only need INSERT and DELETE access, you can do this.