| From: | Efraín Déctor <efraindector(at)motumweb(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-novice(at)lists(dot)postgresql(dot)org, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Logical replication error |
| Date: | 2017-12-18 18:53:48 |
| Message-ID: | 86477617-a3bb-9f24-7f10-719104e8a167@motumweb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)motumweb(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-12-21 14:40:15 | Re: Logical replication error |
| Previous Message | Andreas Kretschmer | 2017-12-18 18:49:43 | Re: Logical replication error |