pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedrepmgr error trying to clone - permission denied
2+ messages / 1 participants
[nested] [flat]
* repmgr error trying to clone - permission denied
@ 2015-09-28 17:35 CS DBA <cs_dba@consistentstate.com>
2015-09-28 20:47 ` Re: repmgr error trying to clone - permission denied (SOLVED) CS DBA <cs_dba@consistentstate.com>
0 siblings, 1 reply; 2+ messages in thread
From: CS DBA @ 2015-09-28 17:35 UTC (permalink / raw)
To: 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...
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: repmgr error trying to clone - permission denied (SOLVED)
2015-09-28 17:35 repmgr error trying to clone - permission denied CS DBA <cs_dba@consistentstate.com>
@ 2015-09-28 20:47 ` CS DBA <cs_dba@consistentstate.com>
0 siblings, 0 replies; 2+ messages in thread
From: CS DBA @ 2015-09-28 20:47 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-09-28 20:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-09-28 17:35 repmgr error trying to clone - permission denied CS DBA <cs_dba@consistentstate.com>
2015-09-28 20:47 ` Re: repmgr error trying to clone - permission denied (SOLVED) CS DBA <cs_dba@consistentstate.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox