Logical replication error

[Efraín Déctor]

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

[Andreas Kretschmer]

Post by Efraín Déctor
Hello.
I am triying to setup logical replication between 2 servers,
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

[Efraín Déctor]

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;

Post by Andreas Kretschmer

Post by Efraín Déctor
Hello.
I am triying to setup logical replication between 2 servers,
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

* which version you are using
* which command you called
Regards, Andreas

[Alvaro Herrera]

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

This turned out to be a bug in the FreeBSD port that Efraín reported and
has been fixed.

[Andreas Kretschmer]

Post by Alvaro Herrera

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

This turned out to be a bug in the FreeBSD port that Efraín reported and
has been fixed.

Whow ;-)


Andreas