Connection error with PostgreSQL

[Marcelo Xavier Santana]

Hello people, I could perform the installation barman in my environment, but when trying to perform some tests showing this error when connecting to postgresql, already realized the configuration of postgresql connection file the pg_hba freeing access to the barman server, but even presenting this error below:

Starting backup for server "IP DO SERVIDOR" in /var/lib/barman/"IP DO SERVIDOR"/base/20141130T221803

EXCEPTION: Backup failed detecting data directory: could not connect to server: No route to host

        Is the server running on host "IP DO SERVIDOR" and accepting

        TCP/IP connections on port 5432?

Has anyone gone through this situation, the to be done, still can not find the bug.

Thank you.

[Marco Nenciarini]

Il 01/12/14 18:54, Marcelo Xavier Santana ha scritto:

The error "could not connect to server: No route to host" looks like a
networking error.

You can verify your "conninfo" setting for a particular server
installing the PostgreSQL client and running the following command as
barman user:

psql "<CONNINFO>"

where <CONNINFO> is the actual conninfo setting.

However, could you please send the output of the "barman diagnose" command?

Regards,
Marco

--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco.ne...@2ndQuadrant.it | www.2ndQuadrant.it

[Marcelo Xavier Santana]

Individual excuse the delay in responding could resolve the error that was presenting was struggling to make it to the PostgreSQL server but this is already solved, managing to make backups everything working perfect, but now is presenting another mistake, I am simulating a situation where the Database server loses all information attempts to perform a recupeção disaster, but this time I have not been able to progress he's made the following error:

[root@backup ~]# barman recover 'IP SERVER" 20141201T181648 /var/lib/pgsql/data

Starting local restore for server 'IP SERVER" using backup 20141201T181648

Destination directory: /var/lib/pgsql/data

Copying the base backup.

Failure copying base backup: data transfer failure on directory 'var/lib/pgsql/data'

rsync error:

.d..tp..... ./

.d..tp..... base/

.d..tp..... base/1/

.d..tp..... base/11563/

.d..tp..... base/11564/

.d..tp..... global/

.d..tp..... pg_clog/

.d..tp..... pg_log/

.d..tp..... pg_multixact/

.d..tp..... pg_multixact/members/

.d..tp..... pg_multixact/offsets/

.d..tp..... pg_stat_tmp/

.d..tp..... pg_subtrans/

.d..tp..... pg_tblspc/

.d..tp..... pg_twophase/

.d..tp..... pg_xlog/

rsync: failed to set times on "/var/lib/pgsql/data/.": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/base": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/base/1": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/base/11563": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/base/11564": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/global": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_clog": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_log": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_multixact": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_multixact/members": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_multixact/offsets": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_stat_tmp": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_subtrans": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_tblspc": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_twophase": Operation not permitted (1)

rsync: failed to set times on "/var/lib/pgsql/data/pg_xlog": Operation not permitted (1)

rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1039) [sender=3.0.6]

when I try to perform the recovery remotely presents this error:

[barman@backup ~]$ barman recover --remote-ssh-command="ssh post...@192.168.78.129" 192.168.78.129 last /var/lib/pgsql/9.3/data/

The authenticity of host '192.168.78.129 (192.168.78.129)' can't be established.

RSA key fingerprint is 35:ce:c7:91:5a:aa:a3:7e:6f:ff:63:d0:2f:86:06:56.

Are you sure you want to continue connecting (yes/no)? yes

Starting remote restore for server 192.168.78.129 using backup 20141203T172746

Destination directory: /var/lib/pgsql/9.3/data/

Using safe horizon time for smart rsync copy: 2014-12-03 01:16:32.928745-02:00

Copying the base backup.

Copying required wal segments.

The archive_command was set to 'false' to prevent data losses.

Your PostgreSQL server has been successfully prepared for recovery!

Please review network and archive related settings in the PostgreSQL

configuration file before starting the just recovered instance.