Thread: Problem with pg_basebackup and streaming replication. (9.2.3 / win64)
Hi,
I'm having problem setting up a slave on windows.--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2013 Tore Halvorsen || +052 0553034554
<demo> 2013 Tore Halvorsen || +052 0553034554
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
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
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:CCing the list.Good idea, but both master and the two slaves are separate machines.
On the second machine does the tablespace path already exist and does it already have files in it?<mailto:adrian.klaver@gmail.com>> wrote:adrian.klaver@gmail.com <mailto:adrian.klaver@gmail.com>
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
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
<demo> 2013 Tore Halvorsen || +052 0553034554