Re: Postgres Wierdness - Mailing list pgsql-general

From Alex Turner
Subject Re: Postgres Wierdness
Date
Msg-id 33c6269f0601181143q98e896dnd270573d7a4ce0f3@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Wierdness  (Michael Crozier <crozierm@conducivetech.com>)
List pgsql-general
Oh yeah - thanks - I guess I really wanted to be using fast, not
immediate.  Wierd I've gone all this time without noticing that
before.  I've on Postgresql since 6.5.

Alex.

On 1/18/06, Michael Crozier <crozierm@conducivetech.com> wrote:
>
> This is a natural consequence of shutting down with "immediate" mode.
>
> From the manual: http://www.postgresql.org/docs/7.4/static/app-pg-ctl.html
>
> ' "Immediate" mode will abort all server processes without a clean shutdown.
> This will lead to a recovery run on restart.'
>
> It has only to do with the state of the write ahead logs, not with the nature
> of your clients.
>
> -michael
>
>
> > I just started using JDBC to connect to postgres from Tomcat, and when
> > I pg_ctl stop -m immediate my server, I get a bunch of messages thus:
> >
> > WARNING: terminating connection because of crash of another server process
> > DETAIL: The postmaster has commanded this server process to roll back
> > the current transaction and exit, because another server process
> > exited abnormally and possibly corrupted shared memory.
> >
> > When the server comes back up, it claims:
> > LOG: database system was not propertly shut down; automatic recovery in
> > progress
> >
> > I'm using the Jdbc3PoolingDataSource to connection.  The code isn't
> > doing any write transactions at all at this point.
> >
> > Anyone any idea what might be happening here?
> >
> > Alex Turner
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
>
> --
>
> Conducive Technology Corporation
>  Taking air cargo information
>    to the next level
>
>      http://www.conducivetech.com
>       http://www.pathfinder-web.com
>
>         Michael Crozier crozierm@conducivetech.com
>
>           Voice: 503.445.4233
>             Fax:   503.274.0939
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

pgsql-general by date:

Previous
From: Michael Crozier
Date:
Subject: Re: Postgres Wierdness
Next
From: Assad Jarrahian
Date:
Subject: Updating rows (automatically) that are selected