473,320 Members | 1,858 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.

Nov 23 '05 #1
4 2860
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Code4u | last post by:
We have a mature project that suffers long build times because many modules pull in far more than they need. In the long term I would like to refactor to break some of the dependencies, but I would...
0
by: Bill J. | last post by:
I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname...
0
by: Bill J. | last post by:
I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname...
39
by: Kaarel | last post by:
I don't feel very confident when it comes to software licenses. But there are some cases I would like to make myself clear. What I am particulary interested in is when does GPL license become...
10
by: Lyle Fairfield | last post by:
I am preparing to write a small utility which will identify redundant objects in an ADP and its SQL db. Suppose my code finds two objects, A and B, which refer only to each other, that is each...
2
by: Chris Travers | last post by:
Hi; I was wondering if anyone can recommend accouting software (preferably open source) that runs on PostgreSQL. The business would be based in the USA. Best Wishes, Chris Travers ...
0
by: Tatsuo Ishii | last post by:
pgpool 1.0, yet another open source replication software for PostgreSQL is now available at: ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-1.0.tar.gz pgpool is a single master/query...
0
by: Greg Sabino Mullane | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for following PostgreSQL versions: 7.4.5 7.4.4 7.3.7
2
by: Bob Powell | last post by:
Hello everyone, I would like to know if anyone has found or developed any monitoring software for Postgres. I would like to be able to gather statistics about the database. How often certain...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.