Re: [ADMIN] Postgres process terminating

2006-03-14 Thread Cory Vokey
On 3/14/06, Guido Barosio <[EMAIL PROTECTED]> wrote: Indeed, from the pg_ctl man pages:``Immediate'' mode will abort all server processes without a cleanshutdown. This will lead to a recovery run on restart.Regards,Guido BarosioOn 3/14/06, Scott Marlowe < [EMAIL PROTECTED]> wrote:> On Tue, 2006-03-

Re: [ADMIN] [pgsql-advocacy] Wisconsin Circuit Court Access (WCCA) on

2006-03-14 Thread Kevin Grittner
>>> On Tue, Mar 14, 2006 at 2:08 am, in message <[EMAIL PROTECTED]>, Simon Riggs <[EMAIL PROTECTED]> wrote: > On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote: >> Even more important is the fast response we have had when posting >> problems to the lists. We have normally had a fix with

Re: [ADMIN] PITR as Online Backup Solution

2006-03-14 Thread Thomas F. O'Connell
On Mar 4, 2006, at 3:56 AM, Simon Riggs wrote: On Fri, 2006-03-03 at 12:03 -0600, Thomas F. O'Connell wrote: On Mar 3, 2006, at 11:54 AM, Simon Riggs wrote: On Thu, 2006-03-02 at 16:38 -0600, Thomas F. O'Connell wrote: Ideally, I'd be able to take a base backup of a production system, copy

Re: [ADMIN] Postgres process terminating

2006-03-14 Thread Guido Barosio
Indeed, from the pg_ctl man pages: ``Immediate'' mode will abort all server processes without a clean shutdown. This will lead to a recovery run on restart. Regards, Guido Barosio On 3/14/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Tue, 2006-03-14 at 14:05, Guido Barosio wrote: > > Hi Cory

Re: [ADMIN] Postgres process terminating

2006-03-14 Thread Scott Marlowe
On Tue, 2006-03-14 at 14:05, Guido Barosio wrote: > Hi Cory, > > Actually it seems that the database wasn't shut down properly, and > while it was doing the recovery, it refused connections. Expected and > what needs to happen, indeed. > > That's why if you are a client about to connect, you'll r

Re: [ADMIN] Postgres process terminating

2006-03-14 Thread Guido Barosio
Hi Cory, Actually it seems that the database wasn't shut down properly, and while it was doing the recovery, it refused connections. Expected and what needs to happen, indeed. That's why if you are a client about to connect, you'll recieve the " FATAL ...database is starting up " message. Ideall

[ADMIN] Postgres process terminating

2006-03-14 Thread Cory Vokey
Hi all, I'm currently running postgres-7.4.12 with slony-1.0.5 and am seeing the below postgres errors: Mar 14 00:00:25 master postgres[27357]: [12-1] FATAL:  57P03: the database system is starting up Mar 14 00:00:25 master postgres[27357]: [12-2] LOCATION:  ProcessStartupPacket, postmaster.c:1437

Re: [ADMIN] [pgsql-advocacy] Wisconsin Circuit Court Access (WCCA) on

2006-03-14 Thread Simon Riggs
On Mon, 2006-03-13 at 13:27 -0600, Kevin Grittner wrote: > Even more important is the fast response we have had when posting > problems to the lists. We have normally had a fix within 24 hours. > Frankly, the support has been amazing. Kevin, well done. We've all watched your progress with intere