Re: [GENERAL] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

2013-04-18 Thread Ned Wolpert
on to secondary DB? > Maybe some configuration parameter that sets the time interval for being > stuck because of unavailable secondary Postgres? > > Please help, > > Thanks, > > > *Yuval Sofer* > *BMC Software* > *CTM&D Business Unit* > *DBA Team* > *97

Re: [GENERAL] Connection limit exceeded for non-superusers when there are plenty of available slots

2013-02-28 Thread Ned Wolpert
normal >> use? >> >> ChrisA >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > -- Virtually, Ned Wolpert "Settle thy studies, Faustus, and begin..." --Marlowe

Re: [GENERAL] Database corruption event, unlockable rows, possibly bogus virtual xids? Invalid backend server xid

2013-02-21 Thread Ned Wolpert
ories nightly to accompany the wal files we store, using pg_start_backup/pg_stop_backup. :-) Full restores are tested monthly. On Thu, Feb 21, 2013 at 2:06 PM, Tom Lane wrote: > Ned Wolpert writes: > > Event: Running 9.1.6 with hot-standby, archiving 4 months of wal files, > >

[GENERAL] Database corruption event, unlockable rows, possibly bogus virtual xids? Invalid backend server xid

2013-02-21 Thread Ned Wolpert
pg_locks table/view. (-1/verylargenumber) -- Virtually, Ned Wolpert "Settle thy studies, Faustus, and begin..." --Marlowe