From: Daryl Chance <dchance@valuedata.net>
To: pgsql-general@postgresql.org
Subject: Re: replication
Date: Thu, 21 Sep 2000 08:34:52 -0500
Message-ID: <000f01c023d0$b8c8a1e0$0200000a@mike> (raw)
References: <001d01c023ca$e37d9cc0$330a0a0a@Adam>
Could this possibly be done using triggers? I'm new to
postgres, but I know on a project I was doing using oracle
the dba could setup triggers to run on the OnInsert() (not
sure what it's actually called in oracle...). Do maybe
on the "OnInsert" of table foo you could do:
Insert into foo@remotesite1 ....
Is this possible in postgres? I'm looking at using postgres
for the next version of my SW and if replication isn't in,
I'm gonna need something like this :).
btw, remotesite could be setup in what oracle referred to
as "tnsnames.ora". It was a file that had a list of
hosts, ports and the database name so that you wouldn't
have to know all that info to connect to an oracle database,
just what you named it, your username and your password.
Thanks,
--------------------------------------------------------
| Daryl Chance | I have made this letter longer then |
| Valuedata, LLC | usual because I lacked the time to |
| Memphis, TN | make it shorter. -- Blaise Pascal |
--------------------------------------------------------
----- Original Message -----
From: "Adam Lang" <aalang@rutgersinsurance.com>
To: "PGSQL General" <pgsql-general@postgresql.org>
Sent: Thursday, September 21, 2000 7:52 AM
Subject: [GENERAL] replication
> Are there any type of replication features in postgresql 7.0?
>
> I would like it where two databases have the same structure, but say at
> midnight every night Database 1 synchs up database 2.
>
> Granted, I could always write code to do that, but it wouldn't be very
> sophisticated. (If I coded it, would do something like find rows in
table
> 1 which aren't in the second database, append them database two, same with
> the second table, etc.)
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: dchance@valuedata.net
Subject: Re: replication
In-Reply-To: <000f01c023d0$b8c8a1e0$0200000a@mike>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox