×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do you address backups in 24x7 environment

How do you address backups in 24x7 environment

How do you address backups in 24x7 environment

(OP)
Hi All,

I am an Oracle guy and quite new to PostgreSQL.
I have do develop a huge but very low budget project,
so the imperative is to 'cut corners'.

I am trying to make a trade-off between PostgreSQL & mySQL.
mySQL scares me because it does not seem to have transactional mechanism (when either all your changes
apply or none); PostgreSql seems to be capable of
doing that (transaction support is very important
because we will be dealing with creadit cards and
financial records and will have situations where
updates of several tables as an atomic operation will be
required).

However I found a point of concern with PostgreSQL
as well:
suppose you performed a full open database backup
at 6:00am in the morning and at 4pm in the afternoon
the database crashed. We have this 6:00am backup
and we have PostgreSQL log files. But PostgreSQL
does not seem to be capable to restore to it's pre-crash
status based on this.   How do you hadle such
recoveries in mission critical applications where
a loss of several hour of work is NOT ACCEPTABLE  ?


Thank you in advance.

RE: How do you address backups in 24x7 environment

You are definitely right to stay away from MySQL.

Here are a few links with info on High Availability and replication for PostgreSQL:

http://pgreplicator.sourceforge.net/
http://www.taygeta.com/ha-postgresql.html
http://www.erserver.com/
http://usogres.good-day.net/
http://dbbalancer.sourceforge.net/
http://gborg.postgresql.org/project/pgreplication/projdisplay.php

And in general, browse through the links at http://techdocs.postgresql.org/ -- there are some gold mines in there .

-------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student

RE: How do you address backups in 24x7 environment

Also, do some reading about WAL (Write-Ahead Logging), in the PostgreSQL documentation.

-------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close