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

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

From
Tore Halvorsen
Date:
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?



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

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

From
Adrian Klaver
Date:
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


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

From
Adrian Klaver
Date:
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


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

From
Tore Halvorsen
Date:
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