[Spacewalk-list] Backing Spacewalk

[Pierre Casenove]

Thanks a lot for the advices. I've added the -c switch to pgdump command.

Pierre
Le 21 mars 2013 14:15, "Paul Robert Marino" <prmarino1 at gmail.com> a écrit :

> I'll check the flags latter but yes pgdump is the right tool.
> It can be done live thanks to PostgreSQLs MVCC but you may experience
> brief pauses to any operations that request a exclusive table lock on a
> table currently being backed up.
>
> Also you may want to consider using an external PostgreSQL 9.x database
> for streaming replication. In 9.2 you can do cascading streaming
> replication which allows you to use pgpool as a proxy the connections, pool
> the connection (many to one connection), loadballance the reads, and
> automate your failover and live recovery of a cluster of 3 or more if 2 of
> them have quorum.
> The one bathing about using 9.x is you need to recreate the links to the
> default PostgreSQL jdbc driver to the one for 9.x or you will run into
> errors.
>
>
>
> -- Sent from my HP Pre3
>
> ------------------------------
> On Mar 21, 2013 3:35 AM, Pierre Casenove <pcasenove at gmail.com> wrote:
>
> Hello,
> On the wiki, the following guide gives directions to backup oracle-xe:
> https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup
>
> I'm using, postgresql 8.4, and currently, I'm backing up the application
> using pg_dump command, to backup spacewalk database and postgres database.
> pg_dump spaceschema -Fc -f /data/backup/spaceschema.dmp
> pg_dump postgres -Fc -f /data/backup/postgres.dmp
>
> Is it sufficient to recover the database in case of a crash?
> Can the pg_dump be run with spacewalk running, or does it have to be a
> cold backup?
>
> Thanks in advance,
>
> Pierre
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130322/723d4c2e/attachment.htm>