Re: [ADMIN] Restore db with multi-tablespaces

2012-09-10 Thread Rural Hunter
Thanks! 于 2012/9/7 20:20, Sergey Konoplev 写道: On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter wrote: base_20120902.tar.gz 27781958.tar.gz 27781959.tar.gz Now I want to restore it on another server with only one disk. I'm confused how to handle those tablespace files. Is there a guideline or doc

Re: [ADMIN] Restore db with multi-tablespaces

2012-09-07 Thread Sergey Konoplev
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter wrote: > base_20120902.tar.gz > 27781958.tar.gz > 27781959.tar.gz > > Now I want to restore it on another server with only one disk. I'm confused > how to handle those tablespace files. Is there a guideline or doc for this > kind of restore? Unpack bas

[ADMIN] Restore db with multi-tablespaces

2012-09-06 Thread Rural Hunter
Hi, I have a database with several tablespaces on different disks and backup-ed it with pg_basebackup. I have theses files: base_20120902.tar.gz 27781958.tar.gz 27781959.tar.gz Now I want to restore it on another server with only one disk. I'm confused how to handle those tablespace files. Is

[ADMIN] Restore db

2011-11-14 Thread Alexander Burbello
Hi folks, My server has a daily routine to import a dump file, however its taking long time to finish it. The original db has around 200 MB and takes 3~4 minutes to export (there are many blob fields), however it takes 4 hours to import using pg_restore. What can I do to tune this database to spe

[ADMIN] Restore db

2011-11-13 Thread Alexander Burbello
Hi folks, My server has a daily routine to import a dump file, however its taking long time to finish it. The original db has around 200 MB and takes 3~4 minutes to export (there are many blob fields), however it takes 4 hours to import using pg_restore. What can I do to tune this database to spe

[ADMIN] restore db from files

2002-09-27 Thread Jens Pilemand Ottesen
I am fairly new to Postgres. And seems to have made a big mistake trying to backup the DB. I copied all the files in the database folder. Now that the DB crashed, i reinstalled Postgres and copied the files back but postgres can't find them. Can anybody help to restore my Db from those files? B