Re: [ADMIN] pd_dump server mismatch error

2013/9/26 Thara Vadakkeveedu : > Hi, > When you say preinstalled with the system, you mean preinstalled with RedHat > Linux? > > I seem to have the right version ... I had to use the full path to identify > the version. > > -bash-4.1$ /usr/pgsql-9.2/bin/pg_dump --version > pg_dump (PostgreSQL) 9.2.

Re: [ADMIN] pg_dump, pg_restore from 9.2 on 8.4 server

2013/7/3 Jiří Hlinka : > Hi All, > > I have a 8.4 server and I'd like to use --section parameter of pg_dump and > pg_restore, which is available only in 9.2. > > 1. Is it, in general, safe to use 9.2 tools on 8.4 server? AFAIK the tools > are backward compatible, at least in case of plain SQL comm

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

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.

Re: [ADMIN] database role for backups?

2013/5/7 Kamil Jońca : > > I tried to create make backup my postrgresql cluster with amanda. > And I had to create database superuser. > > I tried to create no-superuser role with only "replication" privillege, > but after run backup I got: > > --8<---cut here---start---