Thread: pg_basebackup skips pg_replslot directory
Hi all, I found strange behavior of PostgreSQL of HEAD while using pg_basebackup. pg_basebackup skips pg_replslot directory since 858ec11858a914d4c380971985709b6d6b7dd6fc commit. But pg_repslot direcotry is needed to start replication. So the standby server which is created by pg_baseback can not start. I got following FATAL error when the standby server starts. FATAL: could not open directory "pg_replslot": No such file or directory Is this a bug? Attached file solves it by including pg_replslot directory as empty directory. Please give feedback. Regards, ------- Sawada Masahiko
Attachment
Hi, On 2014-02-18 02:01:58 +0900, Sawada Masahiko wrote: > I found strange behavior of PostgreSQL of HEAD while using pg_basebackup. > pg_basebackup skips pg_replslot directory since > 858ec11858a914d4c380971985709b6d6b7dd6fc commit. > > But pg_repslot direcotry is needed to start replication. So the > standby server which is created by > pg_baseback can not start. > I got following FATAL error when the standby server starts. Yes. Fujuii has submitted a similar patch, I was hoping he'd commit it... Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
On Tue, Feb 18, 2014 at 2:07 AM, Andres Freund <andres@2ndquadrant.com> wrote: > Hi, > > On 2014-02-18 02:01:58 +0900, Sawada Masahiko wrote: >> I found strange behavior of PostgreSQL of HEAD while using pg_basebackup. >> pg_basebackup skips pg_replslot directory since >> 858ec11858a914d4c380971985709b6d6b7dd6fc commit. >> >> But pg_repslot direcotry is needed to start replication. So the >> standby server which is created by >> pg_baseback can not start. >> I got following FATAL error when the standby server starts. > > Yes. Fujuii has submitted a similar patch, I was hoping he'd commit > it... > I did not notice it. Thank you for info! Regards, ------- Sawada Masahiko
On 2014-02-18 02:16:19 +0900, Sawada Masahiko wrote: > On Tue, Feb 18, 2014 at 2:07 AM, Andres Freund <andres@2ndquadrant.com> wrote: > > Hi, > > > > On 2014-02-18 02:01:58 +0900, Sawada Masahiko wrote: > >> I found strange behavior of PostgreSQL of HEAD while using pg_basebackup. > >> pg_basebackup skips pg_replslot directory since > >> 858ec11858a914d4c380971985709b6d6b7dd6fc commit. > >> > >> But pg_repslot direcotry is needed to start replication. So the > >> standby server which is created by > >> pg_baseback can not start. > >> I got following FATAL error when the standby server starts. > > > > Yes. Fujuii has submitted a similar patch, I was hoping he'd commit > > it... > > > > I did not notice it. > Thank you for info! His patch and some discussion is at/around http://archives.postgresql.org/message-id/CAHGQGwGvb0qXP7Q76xLUkGO%2BwE9SyJzvzF%3DQBOS-mxgiz0vfKw%40mail.gmail.com Thanks for the patch, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services