What's the easiest way, in PostgreSQL 9.0, to keep a duplicate database on my local machine updated at intervals from
anotheron a remote machine without having to reset permissions after a backup/restore. Also which type of backup? Plain
textor compressed? Data-only or complete shema? Setup duplicate users or can I use a distinct set of users? I would
ideallylike to have the same schemas setup with distinct users then simply have a data-only backup from the remote
serverwhich I can restore to the local machine without resetting privileges/permissions.
gvim