Re: Data backup to local duplicate without resetting permissions

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Data backup to local duplicate without resetting permissions
Date: 2010-12-24 03:10:25
Message-ID: if12v1$sag$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2010-12-23, gvim <gvimrc(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2010-12-24 03:14:36 Re: How to calculate length of path data without diagonals?
Previous Message Jasen Betts 2010-12-24 03:07:04 Re: When the trigger is called my application is awaiting the finish