Re: [ADMIN] Legacy foreign keys

2008-01-31 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > I finally found more time to test this more extensively. i'm still > running into an issue with this, although it's different this time. > There are no errors printed to the terminal, but neither the foreign > key nor the trigger get made. It looks like

[ADMIN] PITR and Failover

2008-01-31 Thread Brad Nicholson
Say I'm using pg_standby to feed wal files from database A into both database B and database C. At some point, I lose A, so I bring Database B up and start the wal archiving from there. Can I then continue streaming the wal files from B into C, or do I need to take a new base backup from B and st

Re: [ADMIN] Legacy foreign keys

2008-01-31 Thread Peter Koczan
> > [ squint... ] Which 8.3beta are you testing, exactly? This was dealt > > with in beta3. > > > > If it is beta3 or later, please send the output of "pg_dump -s -t wspolicy" > > from the 8.2 database. > > *lightbulb* beta2. I haven't had much time to dedicate to testing new > betas yet (I was j

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Simon Riggs
On Thu, 2008-01-31 at 10:02 -0500, Chander Ganesan wrote: > Magnus Hagander wrote: > > On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote: > > > >> On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote: > >> > >>> That sentence has no place in any discussion about

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Simon Riggs
On Thu, 2008-01-31 at 12:09 -0300, Alvaro Herrera wrote: > > Simon Riggs wrote: > > >> As far as I am concerned, if any Postgres user loses data then we're all > >> responsible. > > Remember, our license says this software is given without any warranty > whatsoever, implicit or explicit, written

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Alvaro Herrera
> Simon Riggs wrote: >> As far as I am concerned, if any Postgres user loses data then we're all >> responsible. Remember, our license says this software is given without any warranty whatsoever, implicit or explicit, written or implied, given or sold, alive or deceased. -- Alvaro Herrera

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Chander Ganesan
Magnus Hagander wrote: On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote: On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote: That sentence has no place in any discussion about "backup" because the risk is not just a few transactions, it is a corrupt and in

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Chander Ganesan
Simon Riggs wrote: On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote: If you don't mind if you lose some transactions That sentence has no place in any discussion about "backup" because the risk is not just a few transactions, it is a corrupt and inconsistent database from which

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Magnus Hagander
On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote: > On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote: > > That sentence has no place in any discussion about "backup" because the > > risk is not just a few transactions, it is a corrupt and inconsistent > > database f

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Martijn van Oosterhout
On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote: > That sentence has no place in any discussion about "backup" because the > risk is not just a few transactions, it is a corrupt and inconsistent > database from which both old and new data would be inaccessible. Hmm? I thought the whole

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Simon Riggs
On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote: > If you don't mind if you lose some transactions That sentence has no place in any discussion about "backup" because the risk is not just a few transactions, it is a corrupt and inconsistent database from which both old and new data would

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Chander Ganesan
Simon Riggs wrote: On Fri, 2008-01-25 at 11:34 +1100, Phillip Smith wrote: We have a center in Europe who has just started to use PostgreSQL and was asking me if there are any Symantec product or other products that backup this type of database. It doesn't appear to. The design