Re: Problem with pg_basebackup and streaming replication. (9.2.3 / win64)

[Tore Halvorsen <tore.halvorsen@xxxxxxxxx>]

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

<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@xxxxxxxxx <mailto:adrian.klaver@gmail.com>

--
Adrian Klaver
adrian.klaver@xxxxxxxxx

--

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