Re: [ADMIN] postgres user with automate rsync and private/public key pairs

2013-06-14 Thread Scott Ribe
On Jun 14, 2013, at 5:31 AM, Ian Lawrence Barwick wrote: > Looking at /var/log/auth.log might provide more clues. as might ssh -vvv -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or

Re: [ADMIN] postgres user with automate rsync and private/public key pairs

2013-06-14 Thread Ian Lawrence Barwick
2013/6/14 Daniel Vázquez : > Hi here! > > Centos 6.4 > Postgres 9.1 > > I want to automate rsync backups from server1 to server2 via ssh using the > postgres(linux deamon user) and a pair of private/public keys generated by > ssh-keygen > > I generated the keys in Server1 and copy and added id_rsa.

[ADMIN] postgres user with automate rsync and private/public key pairs

2013-06-14 Thread Daniel Vázquez
Hi here! Centos 6.4 Postgres 9.1 I want to automate rsync backups from server1 to server2 via ssh using the postgres(linux deamon user) and a pair of private/public keys generated by ssh-keygen I generated the keys in Server1 and copy and added id_rsa.pub to /var/lib/pgsql/.ssh/authorized_keys i