Yes, that is possible to take the backup from one instance and restore that in another postgresql instance and for that purpose you use pg_dump (for taking full dump use pg_dumpall) and pg_restore utilities.Thanks,
Shoaib MirEnterpriseDB (www.enterprisedb.com)On 7/25/06, JieJun Xu <
[EMAIL PROTECTE
Thanks for helping. My postgresql DB is actually part of the OME system which stores Image Metadata. The system overview is as following:
http://www.openmicroscopy.org/system-overview/. So I am actually using the option provided by OME to backup/restore my system.
http://www.openmicroscopy.org/sys
You can also try using 'pg_dumpall' (http://www.postgresql.org/docs/8.1/static/app-pg-dumpall.html) that will take the dump of all the users, groups and databases.
Thanks,Shoaib MirEnterpriseDBOn 7/25/06, Paul S <[EMAIL PROTECTED]> wrote:
It looks like it's a user configuration issue. I have hit u
It looks like it's a user configuration issue. I have hit user setup issues
while restoring DB's before and generally I find it useful to create the
Users and/or Groups manually on the new server first before restoring the
DB's whenever I hit problems like that. Try syncing the users manually,
(
Hi all, I am trying to backup a psql database in one system(Debian), and restore it to another system(ubuntu) which has a fresh installed psql db. However, I got the following errors. Can anyone give me some help on solving it. Many thanks.
- OME Restore- \_ Extracti
