Postgres Pro
Downloads
Home   >   mailing lists

Re: Data backup to local duplicate without resetting permissions - Mailing list pgsql-general

From Jasen Betts
Subject Re: Data backup to local duplicate without resetting permissions
Date
Msg-id if12v1$sag$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Data backup to local duplicate without resetting permissions  (gvim <gvimrc@gmail.com>)
List pgsql-general
Tree view 
On 2010-12-23, gvim <gvimrc@gmail.com> wrote:
> What's the easiest way, in PostgreSQL 9.0, to keep a duplicate
> database on my local machine updated at intervals from another on a
> remote machine without having to reset permissions after a
> backup/restore.

create roles matching the names of the remote roles and grant those
roles to your local users.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: When the trigger is called my application is awaiting the finish
Next
From: Jasen Betts
Date:
Subject: Re: How to calculate length of path data without diagonals?