public inbox for [email protected]
help / color / mirror / Atom feedFrom: jayakumar s <[email protected]>
To: Paul Foerster <[email protected]>
Cc: [email protected]
Subject: Re: DB Switchover using repmgr--Error
Date: Wed, 27 Nov 2024 11:47:16 +0530
Message-ID: <CAFPcKG0YDvQtxY5zh5LdSiWTOb=eGE5s7ycuR9kOFJN5dHTucQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFPcKG3rETDKASy6v1r_031qqSbwnNTL2L5O52NQ5yDfx8NK5Q@mail.gmail.com>
<[email protected]>
Hi Paul,
Thanks for your help. I have fixed that issue. Now I am getting one more
issue. Can you help to fix the below error?
[postgres@post1 bin]$ /usr/pgsql-16/bin/repmgr -f
/var/lib/pgsql/repmgr.conf cluster show
WARNING: node "standby" not found in "pg_stat_replication"
ID | Name | Role | Status | Upstream | Location | Priority |
Timeline | Connection string
----+---------+---------+-----------+-----------+----------+----------+----------+-----------------------------------------------------------------
1 | primary | primary | * running | | default | 100 | 8
| host=192.168.29.193 user=repmgr dbname=repmgr connect_timeout=2
2 | standby | standby | running | ! primary | default | 100 | 8
| host=192.168.29.9 user=repmgr dbname=repmgr connect_timeout=2
WARNING: following issues were detected
- node "standby" (ID: 2) is not attached to its upstream node "primary"
(ID: 1)
[postgres@post1 bin]$
On Tue, Nov 26, 2024 at 3:41 PM Paul Foerster <[email protected]>
wrote:
> Hi,
>
> > [postgres@post1 bin]$ ./repmgr -f /var/lib/pgsql/repmgr.conf primary
> register
> > ERROR: following errors were found in the configuration file:
> > syntax error in file "/var/lib/pgsql/repmgr.conf" line 3, near token
> "data_directory"
> > syntax error in file "/var/lib/pgsql/repmgr.conf" line 6, near token
> "log_file"
> > [postgres@post1 bin]$
> >
> > Conf file:
> >
> > [postgres@post1 data]$ cat /var/lib/pgsql/repmgr.conf
> > node_id=1
> > node_name=primary
> > conninfo='host=192.168.29.193 user=repmgr dbname=repmgr
> connect_timeout=2' data_directory='/application/pgsql/data'
> failover=automatic
> > promote_command='/usr/pgsql-16/bin/repmgr standby promote -f
> /var/lib/pgsql/repmgr.conf --log-to-file'
> > follow_command='/usr/pgsql-16/bin/repmgr standby follow -f
> /var/lib/pgsql/repmgr.conf --log-to-file --upstream-node-id=%n'
> > pg_bindir='/usr/pgsql-16/bin' log_file='/usr/pgsql-16/repmgr.log'
> > [postgres@post1 data]$
>
> I'm not a repmgr guru but at first glance I would say that your config
> lacks two line breaks. It should probably look like this:
>
> node_id=1
> node_name=primary
> conninfo='host=192.168.29.193 user=repmgr dbname=repmgr connect_timeout=2'
> data_directory='/application/pgsql/data'
> failover=automatic
> promote_command='/usr/pgsql-16/bin/repmgr standby promote -f
> /var/lib/pgsql/repmgr.conf --log-to-file'
> follow_command='/usr/pgsql-16/bin/repmgr standby follow -f
> /var/lib/pgsql/repmgr.conf --log-to-file --upstream-node-id=%n'
> pg_bindir='/usr/pgsql-16/bin' log_file='/usr/pgsql-16/repmgr.log'
>
> Cheers
> Paul
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: DB Switchover using repmgr--Error
In-Reply-To: <CAFPcKG0YDvQtxY5zh5LdSiWTOb=eGE5s7ycuR9kOFJN5dHTucQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox