Thread: Logical replication error
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
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 -- 2ndQuadrant - The PostgreSQL Support Company
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 > >
Efraín Déctor wrote: > 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 This turned out to be a bug in the FreeBSD port that Efraín reported and has been fixed. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Am 21.12.2017 um 15:40 schrieb Alvaro Herrera: > Efraín Déctor wrote: > >> 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 > This turned out to be a bug in the FreeBSD port that Efraín reported and > has been fixed. > Whow ;-) Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com