Re: [GENERAL] Data backup to local duplicate without resetting permissions

2010-12-23 Thread Jasen Betts
On 2010-12-23, gvim 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

Re: [GENERAL] Data backup to local duplicate without resetting permissions

2010-12-23 Thread Adrian Klaver
On 12/23/2010 08:55 AM, gvim 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. Also which type of backup? Plain text or compressed? Da

[GENERAL] Data backup to local duplicate without resetting permissions

2010-12-23 Thread gvim
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. Also which type of backup? Plain text or compressed? Data-only or complete shema? Setup d