Re: Starting new cluster from base backup

On 02/18/2015 11:51 AM, Guillaume Drolet wrote:

2015-02-18 13:40 GMT-05:00 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>:

    On 02/18/2015 10:24 AM, Guillaume Drolet wrote:



        2015-02-18 11:06 GMT-05:00 Adrian Klaver
        <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
        <mailto:adrian.klaver@aklaver.__com
        <mailto:adrian.klaver@aklaver.com>>>:



             So is E:\ a network drive shared by both machines?


        No, E:\ is a local drive on which I created a tablespace, in
        order to
        have enough space for my database. In my current setup on the source
        machine, PGDATA is in the default PGSQL installation on the OS
        disk so
        space is limited. On the destination machine, PGDATA will be on a
        different, larger disk than the OS disk.


    So is there an E:\ drive available on the destination machine?


Yes there is an E:\ drive available on the destination machine. But for
now, these two machines don't communicate. I take the backup on a hot
swap disk (F:\) and then swap it into the destination machine.
Ultimately when my database will be running on the destination machine,
I'll connect to it from other machines in my local network.

So if I understand correctly you have:

1) On source machine a directory E:\Data\Database.
2) On the source machine in Postgres you have a created a tablespace that points at E:\Data\Database.
3) On destination machine you have an E:\ drive also.

Then have you tried:

1) Create \Data\Database directory under E:\ on the destination machine.

2) Do the pg_basebackup.

Can't the dependency issue be fixed by creating a new junction in
data/pg_tblspc that would point to the relocated tablespace?

The docs say you can:

http://www.postgresql.org/docs/9.3/static/manage-ag-tablespaces.html

"The directory $PGDATA/pg_tblspc contains symbolic links that point to each of the non-built-in tablespaces defined in the cluster. Although not recommended, it is possible to adjust the tablespace layout by hand by redefining these links. Under no circumstances perform this operation while the server is running. Note that in PostgreSQL 9.1 and earlier you will also need to update the pg_tablespace catalog with the new locations. (If you do not, pg_dump will continue to output the old tablespace locations.)"


I have not done it and I see the "Although not recommended.." part above, so I would say that is a last resort solution.

                          Thanks.

--
Adrian Klaver
adrian.klaver@aklaver.com