Re: How to catch a command - Mailing list pgsql-novice

From Mike Fahrenkrog
Subject Re: How to catch a command
Date
Msg-id 20050722172842.C92895280C@svr1.postgresql.org
Whole thread Raw
In response to Re: How to catch a command  (Humberto Carvalho <carvalho.humberto@gmail.com>)
List pgsql-novice
> On Jul 22, 2005, at 9:13 AM, Humberto Carvalho wrote:

> the db that i use don't have any data, only the structure.
> So i need to send the command to the real databases that are
> in a diferente server.

Interesting architecture. Is not having any data in the front db a design
constraint? If so, based on what -- very limited resources on the front db
server, e.g. embedded or mobile device? Just curious. If the front db server
is not actually constrained, you may want to consider using replication
instead.

As far as I know, your front db would have to contain the data for
replication to work. Perhaps someone knows of a simple or reliable way to
set up Slony replication while keeping data out of the publisher. In
general, though, replication would be the most straightforward and reliable
way to get your data to the "real" database.

Check out:
http://gborg.postgresql.org/project/slony1/projdisplay.phpalowing

Regards,
Mike



pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: dead tuples
Next
From: "Oren Mazor"
Date:
Subject: Re: dead tuples