Re: Multiple backends on a single physical database - Mailing list pgsql-admin

From Jeff
Subject Re: Multiple backends on a single physical database
Date
Msg-id 20021014114534.F59838-100000@torgo
Whole thread Raw
In response to Re: Multiple backends on a single physical database  (Ragnar Kjørstad <postgres@ragnark.vestdata.no>)
List pgsql-admin
On Sat, 12 Oct 2002, [iso-8859-1] Ragnar Kj�rstad wrote:

>
> If pulling the plug causes database-corruption that proves that there is
> something wrong with NFS-setup, but if it _doesn't_ cause
> database-corruption that doesn't prove that it's safe - it could be that
> you're just lucky.
>
> This should be obvious, but I've seen too many people argument like
> "I've tested it twice and it didn't break so it must be safe".
>

Also keep in mind if the Postgres box is running on linux the joys that is
what linux does when an nfs mount "goes away" (unpingable).  On our
machines linux simply blocks in the kernel so you cannot even kill -9 the
applications (or unmount the mount!) granted things will resume once nfs
comes back.. but by that time your machine may be in Big Trouble(tm)

------------------------------------------------------------------------------
Jeff Trout <jeff@jefftrout.com>                  http://www.jefftrout.com/
   Ronald McDonald, with the help of cheese soup,
       controls America from a secret volkswagon hidden in the past
-------------------------------------------------------------------------------



pgsql-admin by date:

Previous
From: Jeff Boes
Date:
Subject: Errors while vacuuming large tables
Next
From: Tom Lane
Date:
Subject: Re: Errors while vacuuming large tables