Re: [ADMIN] postgres pg_basebackup - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: [ADMIN] postgres pg_basebackup
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53A37793@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: [ADMIN] postgres pg_basebackup  ("Brandl, Wolfgang" <wolfgang.brandl@brz.gv.at>)
List pgsql-admin
I wrote:
>> During an online backup, a file "tablespace_map" is created in the data directory that
>> contains the original locations of the tablespaces.
>> 
>> During recovery, the symbolic links are restored from that directory.
>> 
>> So you have to un-tar the tablespaces into the same location as in the original database
>> cluster.  The good news is that you can find the locations in the "tablespace_map" file
>> and don't need to document them somewhere.

Wolfgang Brandl wrote:
> Thanks it is working perfectly.
> Even if i choose to redirect the database to new location and adapting the tablespace_map
> file to this new locations it is working.
> Do you think there are any concerns doing this redirect restore?

That should be fine.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Steven Chang
Date:
Subject: Re: [ADMIN] wal segment size
Next
From: Adrian Klaver
Date:
Subject: Re: [ADMIN] [SQL] exporting query result