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. 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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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
...
|
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...
|
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
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
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
|
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...
| |