By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,822 Members | 1,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,822 IT Pros & Developers. It's quick & easy.

Redundancy software for PostgreSQL

P: n/a
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.

Nov 23 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a
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/...rojdisplay.php

Pascal

PS: I don't use it so I can't tell you more, sorry.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

P: n/a
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/...rojdisplay.php

Pascal

PS: I don't use it so I can't tell you more, sorry.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #3

P: n/a
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/...rojdisplay.php
Jan

--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #4

P: n/a
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/...rojdisplay.php
Jan

--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.