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

User error, didnt RTFM, this is the result of not having ssh keys in place


On 09/28/2015 11:35 AM, CS DBA wrote:
> 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