repmgr error trying to clone - permission denied
От | CS DBA |
---|---|
Тема | repmgr error trying to clone - permission denied |
Дата | |
Msg-id | 56097A57.10907@consistentstate.com обсуждение исходный текст |
Ответы |
Re: repmgr error trying to clone - permission denied (SOLVED)
(CS DBA <cs_dba@consistentstate.com>)
|
Список | pgsql-admin |
All; I've installed repmgr, registered the master successfully and now I want to clone the master as a standby. My Master repmgr.cfg file looks like this: $ cat repmgr.cfg cluster=pg_test node=1 node_name=node1 conninfo='host=192.168.182.132 user=postgres dbname=postgres' pg_bindir=/usr/pgsql-9.3/bin My master pg_hba.conf file: # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 192.168.182.133/32 trust # IPv6 local connections: host all all ::1/128 trust # Allow replication connections from localhost, by a user with the # replication privilege. #local replication postgres trust host replication postgres 127.0.0.1/32 trust host replication postgres 192.168.182.133/32 trust host replication postgres ::1/128 trust The master is running on 192.168.182.132 I want the standby to be cloned onto 192.168.182.133 I ran this to register the master: $ repmgr -f /var/lib/pgsql/9.3/repmgr/repmgr.cfg --verbose master register Opening configuration file: /var/lib/pgsql/9.3/repmgr/repmgr.cfg [2015-09-28 11:05:20] [INFO] repmgr connecting to master database [2015-09-28 11:05:20] [INFO] repmgr connected to master, checking its state [2015-09-28 11:05:20] [INFO] master register: creating database objects inside the repmgr_pg_test schema [2015-09-28 11:05:20] [NOTICE] Master node correctly registered for cluster pg_test with id 1 (conninfo: host=192.168.182.132 user=postgres dbname=postgres) Here's my clone command: $ repmgr -D /var/lib/pgsql/9.3/data -d postgres -U postgres -R postgres --verbose standby clone 192.168.182.132 Opening configuration file: ./repmgr.conf [2015-09-28 11:25:39] [ERROR] Did not find the configuration file './repmgr.conf', continuing [2015-09-28 11:25:39] [NOTICE] repmgr Destination directory /var/lib/pgsql/9.3/data provided, try to clone everything in it. [2015-09-28 11:25:39] [INFO] repmgr connecting to master database [2015-09-28 11:25:39] [INFO] repmgr connected to master, checking its state [2015-09-28 11:25:39] [INFO] Successfully connected to primary. Current installation size is 19 MB Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password). [2015-09-28 11:25:39] [INFO] Can not connect to the remote host (192.168.182.132) [2015-09-28 11:25:39] [ERROR] repmgr: Aborting, remote host 192.168.182.132 is not reachable. I tried it without the -R as well, same result. I can connect from the standby to the master via psql -h : $ psql -h 192.168.182.132 psql (9.3.9) Type "help" for help. postgres=# Thoughts? Thanks in advance...
В списке pgsql-admin по дате отправления: