On Wed, Oct 11, 2006 at 10:28:44AM -0400, Andrew Sullivan wrote:
> On Thu, Oct 05, 2006 at 08:43:21PM -0500, Jim Nasby wrote:
> > Isn't it entirely possible that if the master gets trashed it would
> > start sending garbage to the Slony slave as well?
>
> Well, maybe, but unlikely. What happens
On Wed, Oct 11, 2006 at 13:30:22 +0200,
Fourat Zouari <[EMAIL PROTECTED]> wrote:
> what's the benefits using a serialized trans ?
All of the queries in the transaction see a consistant view of the database.
So that two identical select queries will return the same information
within a serialized
Hi,
>
> I think this highlights exactly what I'm trying to emphasise: in
> actual, shared-nothing systems like this, there's no possible
> guarantee of "never". There are possible guarantees of "very
> rarely". The problem is, you're already trying to address a teeny
> portion of the likely eve
On Tue, Oct 10, 2006 at 10:11:08AM -0500, Jim C. Nasby wrote:
> couldn't setup HA on OpenBSD. The key is just to make sure that you
> never bring up two servers on the same data directory.
I think this highlights exactly what I'm trying to emphasise: in
actual, shared-nothing systems like this, th
On Thu, Oct 05, 2006 at 08:43:21PM -0500, Jim Nasby wrote:
> Isn't it entirely possible that if the master gets trashed it would
> start sending garbage to the Slony slave as well?
Well, maybe, but unlikely. What happens in a shared-disc failover is
that the second machine re-mounts the same pa
On Tue, 10 Oct 2006, Tom Lane wrote:
Richard Ray <[EMAIL PROTECTED]> writes:
I can reassign the view but not the type.
You don't need to reassign the type's ownership, because it's just part
of the view.
After I reassigned all the views I was allowed to drop the user.
Thanks
what's the benefits using a serialized trans ?On 10/10/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Tue, Oct 10, 2006 at 10:24:57AM -0500, Jim C. Nasby wrote:> > If you just want to copy the data across to the other table:> > begin;> > insert into table2 select * from table1 where ;
> > commit;>
