Message-ID: <000f01c023d0$b8c8a1e0$0200000a@mike>
From: "Daryl Chance" <dchance@valuedata.net>
To: <pgsql-general@postgresql.org>
References: <001d01c023ca$e37d9cc0$330a0a0a@Adam>
Subject: Re: replication
Date: Thu, 21 Sep 2000 08:34:52 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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
>
>