Re: Problem with pg_basebackup and streaming replication. (9.2.3 / win64) - Mailing list pgsql-general

From Tore Halvorsen
Subject Re: Problem with pg_basebackup and streaming replication. (9.2.3 / win64)
Date
Msg-id CADGw-Scn=iAHjFXiz9_6BJjQx61LowE0JVadtZQXyyv_WjTzfQ@mail.gmail.com
Whole thread Raw
In response to Re: Problem with pg_basebackup and streaming replication. (9.2.3 / win64)  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Ah, this was related to file permissions. The service is running as NETWORK SERVICE, but this user didn't have access to the tablespace-directory.


On Mon, Apr 1, 2013 at 3:14 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On 03/31/2013 04:47 PM, Tore Halvorsen wrote:
Good idea, but both master and the two slaves are separate machines.

CCing the list.
On the second machine does the tablespace path already exist and does it already have files in it?


On Mar 31, 2013 10:21 PM, "Adrian Klaver" <adrian.klaver@gmail.com
<mailto:adrian.klaver@gmail.com>> wrote:

    On 03/31/2013 01:15 PM, Tore Halvorsen wrote:

        Hi,

        I'm having problem setting up a slave on windows.
        I'm doing a pg_basebackup and this seems to work, but when I'm
        starting
        the slave with a recovery.conf-file, I'm getting a redo-error
        with FATAL
        creating file (path to tablespace) File Exists. This is
        reproducible.

        The first slave worked perfectly, but number two just fails with
        this -
        any ideas?


    Are you running both slaves on the same machine and pointing both at
    the same tablespace?




        --
        Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
        <demo> 2013 Tore Halvorsen || +052 0553034554



    --
    Adrian Klaver
    adrian.klaver@gmail.com <mailto:adrian.klaver@gmail.com>



--
Adrian Klaver
adrian.klaver@gmail.com



--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2013 Tore Halvorsen || +052 0553034554

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Money casting too liberal?
Next
From: Ray Stell
Date:
Subject: sql text