Re: [Spacewalk-list] Postgres Backup

2015-08-11 Thread Dewangga Bachrul Alam
Hello! I'm having same problem while backing up using pg_dumpall, then I ignore it, the dump progress should be running. And I do second backup for specific database using pg_dump (eg. rhnschema and postgres). Then the line should be $ su - postgres -c 'pg_dump rhnschema > /backup/rhnschema_back

[Spacewalk-list] Postgres Backup

2015-08-11 Thread Deepjoy Choudhury
Dear All, As per link https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup We can take full backup of DB as below: #su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql' But,I am getting the same error as mentioned in below thread. https://www.redha