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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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 <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@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