Обсуждение: Redundancy software for PostgreSQL
Hello Forum,
I would appreciate it if you could recommend software to build redundancy in my application (my application stores data in a PostgreSQL v7.3.x database running in Linux RedHat) The software would replicate or copy the database from a main server into a second server. And when the main server goes down, the redundant database could still be available in a view mode -- where most tables cannot be updated and only a couple of tables can be modified. In this way, when the main server goes down, the users could still view data and when the main server goes back on-line, I can update a couple of tables of the main database with the data from the redundant database.
Thanks in advance for your response.
Carlos wrote: > Hello Forum, > > I would appreciate it if you could recommend software to build > redundancy in my application (my application stores data in a PostgreSQL > v7.3.x database running in Linux RedHat) The software would replicate > or copy the database from a main server into a second server. And when > the main server goes down, the redundant database could still be > available in a view mode -- where most tables cannot be updated and only > a couple of tables can be modified. In this way, when the main server > goes down, the users could still view data and when the main server goes > back on-line, I can update a couple of tables of the main database with > the data from the redundant database. > > Thanks in advance for your response. > Hi, Take a look at this: http://gborg.postgresql.org/project/pgreplication/projdisplay.php Pascal PS: I don't use it so I can't tell you more, sorry.
Carlos wrote: > Hello Forum, > > I would appreciate it if you could recommend software to build redundancy in > my application (my application stores data in a PostgreSQL v7.3.x database > running in Linux RedHat) The software would replicate or copy the database > from a main server into a second server. And when the main server goes > down, the redundant database could still be available in a view mode -- > where most tables cannot be updated and only a couple of tables can be > modified. In this way, when the main server goes down, the users could > still view data and when the main server goes back on-line, I can update a > couple of tables of the main database with the data from the redundant > database. > > Thanks in advance for your response. > Why not doing a full failover? http://gborg.postgresql.org/project/slony1/projdisplay.php Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #