Re: How to deny remote backups ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: juanmime(at)ono(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to deny remote backups ?
Date: 2005-03-04 14:56:00
Message-ID: 20050304145600.GB17492@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Mar 03, 2005 at 09:45:47 +0100,
juanmime(at)ono(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message juanmime 2005-03-04 16:33:02 Re: How to deny remote backups ?
Previous Message David Wagoner 2005-03-04 14:45:20 User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf