Can you do that if you have functions tied to the table? Also would that be
in a transaction? I need to allow seamless usability to the data while I'm
doing this snapshot. Not sure the -c option (Clean Drop schema) would work
here. I want to only drop a table and not the entire db so that I'm
On Mon, Aug 21, 2006 at 06:40:22AM -0700, Paul Silveira wrote:
>
> Yes the needs are simple. I was also thinking about using DBI. The most
> important thing to me is that everything is kept in a transaction so that
> users can still read the data while I'm snapshotting it at the same time.
> If
Yes the needs are simple. I was also thinking about using DBI. The most
important thing to me is that everything is kept in a transaction so that
users can still read the data while I'm snapshotting it at the same time.
If my transaction is isolated from all the reads happening, then it
shouldn
[EMAIL PROTECTED] (Paul Silveira) writes:
> Does anyone have any good examples of implementing "snapshot"
> replication. I know that PostgreSQL does not have snapshot
> replication and that Slony-I is the recomended replication senario
> but I've configured it and it seems rather advanced for a sho
Hello,
Does anyone have any good examples of implementing "snapshot" replication.
I know that PostgreSQL does not have snapshot replication and that Slony-I
is the recomended replication senario but I've configured it and it seems
rather advanced for a shop that is implementing PostgreSQL for th