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
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
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
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
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
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