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 duplicate users or can I use a distinct set of users? I would ideally like to have the same schemas setup with distinct users then simply have a data-only backup from the remote server which I can restore to the local machine without resetting privileges/permissions.
gvim