On Tue, 21 Jan 2003, codeWarrior wrote:
> So ... Any takers ???
I don't think anyone saw the original, or at least I never received the
quoted message.
> "codeWarrior" <GPatnude@adelphia.net> wrote in message
> news:b0hpc2$pd9$1@news.hub.org...
> > PG 7.2.1
> >
> > I have a co-programmer working on a separate Web-project that runs against
> a
> > shared postgreSQL data server... something keeps killing postgreSQL -- I
> > believe that he has a nested loop around a BEGIN {transaction} block that
> > never issues a COMMIT.... and then END or ROLLBACK...
> >
> > In the postgreSQL error logs -- (I have been restarting postgres with
> > 'pg_ctl restart -D /usr/local/pgsql/data -m smart -l pgdblog.log'.. ) I
> have
> > occasionally seen transaction ID's up in the 2 million + range -- shortly
million or billion? You should be fine up until you're in the billions.
At which point I think you need to vacuum everything.
Does the log show anything around the time it shuts down that might give a
hint?