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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general