Isn't that basically what replication is supposed to do?
RobR, quite possibly revealing his ignorance about replication.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
I've seen lots of questions about this on the Internet, but no answers.
I've got PostgreSQL 8.4 and 9.1 both installed on my computer. I am trying to
set up a scheduled database job to support application testing. The problem is
that I do not seem to have any of the files required to install p
Very naïve question here: Why would you want to save the data from the first
insert?
I thought the purpose of a transaction was to make sure that all steps in the
transaction executed, or none of them executed. If Oracle saves half of the
data between the beginning and ending of the transact
Greetings!
I want to install the Postgres ODBC driver version 8.04 for a customer
that is currently using 8.01. However, I cannot make any change to the
customer's computer without being able to undo the change in case
something goes wrong. The customer has a spare computer that we have
been
Greetings!
I am putting together a formal installation package for a customer who
is not happy if he doesn't have one, even though he's got primary and
backup servers both running as expected.
I am writing instructions on how to install PGAgent. The download
package for PGAgent includes
I thought I sent this earlier, but it's not in my Sent box, so I'll try
again.
Your solution maintains an exact copy of two tables. Whenever a record
is updated in the first, it is updated in the second, and you have lost
information about the previous value.
Whenever I do anything like this,
I have a customer who is running PostgreSQL 8.1. I recently updated an
application there, and it is running extremely slowly. The previous
version of the application runs fine, and the new version runs fine on
my machine, which runs PostgresQL 8.4. The problem is that a query for
a single record
Greetings!
In an attempt to satisfy our client's requirements for redundancy, we
ended up with an unusual (at least to my inexperienced eyes) system
configuration. Our client has two buildings that use our application.
Each building has an application server and a storage server. All are
runnni