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
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
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