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

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(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com
>> <mailto:adrian(dot)klaver(at)gmail(dot)**com <adrian(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com <mailto:adrian(dot)klaver(at)gmail(dot)**com<adrian(dot)klaver(at)gmail(dot)com>
>> >
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

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