Re: replication
От | Daryl Chance |
---|---|
Тема | Re: replication |
Дата | |
Msg-id | 000f01c023d0$b8c8a1e0$0200000a@mike обсуждение исходный текст |
Ответ на | replication ("Adam Lang" <aalang@rutgersinsurance.com>) |
Ответы |
Re: replication
|
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: