Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Unhappy Unanswered: disaster recovery for postgreSQL how to?

    Disaster recovery for PostgreSQL how to?
    What backup software support PostgreSQL and disaster recovery?
    My servser is Sun fire 280R(sparc 64).

  2. #2
    Join Date
    Jul 2003
    Posts
    2

    Re: disaster recovery for postgreSQL how to?

    Originally posted by liu0130
    Disaster recovery for PostgreSQL how to?
    What backup software support PostgreSQL and disaster recovery?
    My servser is Sun fire 280R(sparc 64).
    Not sure what others do, nor if what I do is best. I have a relatively small database of just over 11GB (that is small compared to several oracle databases we have here at work). Anyhow, this is what I do:

    - Each night, shut down the database as the server is backed up. I am using Amanda http://www.amanda.org/ and backing up this server through the network to another linux server that is attached to a MTI tape robot (that has DLT tape drives in it). The Amanda backups automagically run at level 0, 1, 2, etc based on the tape rotation parameters I set.

    - Once a week perform a 'pg_dumpall', piping the output to gzip and writing the output file to a NFS server mount that is HUGE.

    Anyhow, that is most likely not the best option, but the data we're storing (statistical system performance data) is not business critical - thus if we had a disaster and lost a week's worth of data, no-one will lose sleep (or money) over it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •