To: pgsql-admin <pgsql-admin@postgresql.org>
From: CS DBA <cs_dba@consistentstate.com>
Subject: repmgr error trying to clone - permission denied
Message-ID: <56097A57.10907@consistentstate.com>
Date: Mon, 28 Sep 2015 11:35:19 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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...


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin