From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
Cc: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Error while creating subscription when server is running in single user mode |
Date: | 2017-05-31 18:20:13 |
Message-ID: | CAB7nPqQWaRRYLcEsZN15W9b_QhTJOA0ckRsfsKaQ2NxfeOQ1sA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, May 31, 2017 at 7:01 AM, Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
> On Wed, May 31, 2017 at 7:54 AM, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> wrote:
>> centos(at)centos-cpula bin]$ ./postgres --single postgres -D m1data
>> PostgreSQL stand-alone backend 10beta1
>> backend> create subscription sub connection 'dbname=postgres port=5433
>> user=centos' publication p with (create_slot=0,enabled=off);
>> 2017-05-31 12:53:09.318 BST [10469] LOG: statement: create subscription sub
>> connection 'dbname=postgres port=5433 user=centos' publication p with
>> (create_slot=0,enabled=off);
>>
>> 2017-05-31 12:53:09.326 BST [10469] ERROR: epoll_ctl() failed: Bad file
>> descriptor
>
> IMHO, In single user mode, it can not support replication (it can not
> have background WALReciver task). However, I believe there should be a
> proper error if the above statement is correct.
Yeah, see 0e0f43d6 for example. A simple fix is to look at
IsUnderPostmaster when creating, altering or dropping a subscription
in subscriptioncmds.c.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-05-31 18:26:44 | Re: An incomplete comment sentence in subtrans.c |
Previous Message | Andres Freund | 2017-05-31 18:18:01 | Re: Re: [GENERAL] pg_basebackup error: replication slot "pg_basebackup_2194" already exists |