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 036435639E for ; Thu, 3 Mar 2005 08:45:51 +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 87057-06 for ; Thu, 3 Mar 2005 08:45:48 +0000 (GMT) Received: from resmta01.ono.com (smtp.ono.com [62.42.230.12]) by svr1.postgresql.org (Postfix) with ESMTP id 7F76A56146 for ; Thu, 3 Mar 2005 08:45:47 +0000 (GMT) Received: from [80.58.11.235] by resmta01.ono.com with HTTP; Thu, 3 Mar 2005 09:45:47 +0100 Date: Thu, 3 Mar 2005 09:45:47 +0100 Message-ID: <421310210000F6B1@resmta01.ono.com> From: juanmime@ono.com Subject: How to deny remote backups ? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.928 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200503/37 X-Sequence-Number: 16535 Hello, First of all sorry about my bad command in english. I have an Internet server with postgres 7.4.7, planned to give remote db services. I have several offices, with client programs that connect to the internet= DB server v=EDa a SSH tunnel. The user DB that connects to the remote DB has insert and delete permissi= ons (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. Is there a method (with SQL user permitions, templates, newest version of= postgres, ...) that forbides the remote dump of database or its structure= ? I want , for example, only the postgres user can make a local backup insi= de the server. Thanks.