[Spacewalk-list] Postgres Backup

[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_backup-`date
+%Y%m%d`.sql'
$ su - postgres -c 'pg_dump postgres > /backup/postgres_backup-`date
+%Y%m%d`.sql'

CMIIW.

On 08/12/2015 12:19 AM, Deepjoy Choudhury wrote:
> 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.redhat.com/archives/spacewalk-list/2014-September/msg00207.html
> 
>  
> 
> Although db-control works fine, is there any workaround to make
> pg_dumpall work?
> 
>  
> 
> *JDA named leader in all 4 Magic Quadrants across supply chain – learn
> more > <http://now.jda.com/2015-Gartner-Magic-Quadrant-JDA.html>*
> 
> 
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>