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
Dear Ramesh PAtel ,
Will you like to tell us what version are you using
i have three database on one server. when i backup is done complete.
but after backup my pc's speed is very slow. it is requery to restart PC.
try doing vaccumdb
Regards,
V kashyap
---(end o
Hi ALL
i have problem after backup
i have three database on one server. when i backup is done complete.
but after backup my pc's speed is very slow. it is requery to restart PC.
please give some ans.
Ramesh Patel
---(end of broadcast)---
TIP 6: H
