Re: Postgres Wierdness

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(at)conducivetech(dot)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(at)conducivetech(dot)com
>
> Voice: 503.445.4233
> Fax: 503.274.0939
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>