From: | "Wang, Hao" <Hao(dot)Wang(at)emc(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: File system level copy |
Date: | 2012-11-15 01:44:24 |
Message-ID: | 5924071B5F390F46934DECF517DFA371024889@MX101CL01.corp.emc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This is PITR, right?
I don't want to use this way because I'm not allowed to change the configuration parameter of database server. I just want to use some whole DB copy to restore db3 in another machine. And I don't want to use pg_dump because I think db3 is so large that pg_dump will probably have bad performance.
-----Original Message-----
From: Albe Laurenz [mailto:laurenz(dot)albe(at)wien(dot)gv(dot)at]
Sent: Wednesday, November 14, 2012 6:49 PM
To: Wang, Hao; pgsql-general(at)postgresql(dot)org
Subject: RE: [GENERAL] File system level copy
Hao Wang wrote:
> I installed PostgresSQL-8.3 on my linux machine.
>
> The cluster directory is /usr/local/data and I created three databases
named db1, db2, and db3. db1 is
> in the default tablespace 'pg_default'. db2 is in
'/home/tablespace/space1/' and db3 is in
> '/home/tablespace/space2/'. I want to copy the cluster directory and
the db3 tablespace
> folder('/home/tablespace/space2/') without stopping the database
server. Then I want to use the
> cluster directory and db3's tablespace in another linux machine to
recover 'db3' database. Does this
> way work? If not, why?
First, you need a correct backup for recovery.
Before copying, run pg_start_backup, and pg_stop_backup afterwards.
Then you need to have recovery.conf and WAL archives (or be lucky and all WALs are still in pg_xlog).
WAL contains changes to all databases in the cluster, so you cannot recover only one database, you'll have to recover them all.
Read
http://www.postgresql.org/docs/current/static/continuous-archiving.html
for background and details.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitriy Tyugaev | 2012-11-15 07:58:49 | Re: FATAL: index contains unexpected zero page at block |
Previous Message | Craig Ringer | 2012-11-15 01:24:51 | Re: Using Postgresql 9.2 on windows 7 and windows vista |