Re: Logical replication error - Mailing list pgsql-novice

From Efraín Déctor
Subject Re: Logical replication error
Date
Msg-id 86477617-a3bb-9f24-7f10-719104e8a167@motumweb.com
Whole thread Raw
In response to Re: Logical replication error  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Logical replication error
List pgsql-novice
Hello.

Sorry for the lack of information.

Both servers have PostgreSQL 10.1 installed:

Server 1:

Version string    PostgreSQL 10.1 on amd64-portbld-freebsd11.1, compiled 
by FreeBSD clang version 4.0.0 (tags/RELEASE_400/final 297347) (based on 
LLVM 4.0.0), 64-bit

Server 2:

Version string    PostgreSQL 10.1 on amd64-portbld-freebsd10.4, compiled 
by FreeBSD clang version 3.4.1 (tags/RELEASE_34/dot1-final 208032) 
20140512, 64-bit

I am executing the following command on server 2:

CREATE SUBSCRIPTION subtest
          CONNECTION 'host=domain.com port=5432 user=replicador 
password= dbname=testsub'
         PUBLICATION pubtest;


El 18/12/2017 a las 12:49 p. m., Andreas Kretschmer escribió:
> On 18 December 2017 18:17:57 CET, "Efraín Déctor" <efraindector@motumweb.com> wrote:
>> Hello.
>>
>> I am triying to setup logical replication between 2 servers,
>> unfortunately I am getting the following error:
>>
>> ERROR:  could not create replication slot "subtest": ERROR: could not
>> access file "pgoutput": No such file or directory
>>
>> I could not find any answer using google.
>>
>> Any help is apreciated
>>
>> Thanks
> Please provide more details:
>
> * which version you are using
> * which command you called
>
>
> Regards, Andreas
>
>



pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Logical replication error
Next
From: Alvaro Herrera
Date:
Subject: Re: Logical replication error