From: | "Mark Greenbank" <mark(dot)greenbank(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: server closed the connection unexpectedly |
Date: | 2006-10-06 15:20:56 |
Message-ID: | 4110a4f0610060820u247ed7d0u925def5a111d005c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Richard,
Thanks for the reply -- yeah, I know it's and old version but management has
been reluctant to update a production database.
As for the logs, I looked around an didn't see any. pg_ctl start is not
using the -l option for logging and output is redirected to /dev/null :(
Anyway, now I have some room to update, which leads to the following
questions:
1) I'm assuming that if I update 7.3.2 to 7.3.15 I can leave the data in
place (that is, without doing a dump/restore) -- is this correct?
2) If I up upgrade to 8.x can just copy the data files or do I have to do a
dump/restore? The latter would be hard since pg_dump also fails on this same
table and pg_dump doesn't seem to have an 'ignore table' option.
Mark
On 10/6/06, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> Mark Greenbank wrote:
> > # psql --version
> > psql (PostgreSQL) 7.3.2
>
> May I be the first to say "GODS ALIVE MAN! WHAT ARE YOU STILL DOING
> RUNNING 7.3.2!". Even if you can't upgrade from 7.3, the latest release
> is 7.3.15 - that's 13 sets of bug-fixes you're ignoring. There's a
> passing chance one of those bugs might be responsible for your error.
>
> > contains support for command-line editing
> >
> > # psql
> > mncis2-rel=# select count(*) from members;
> > count
> > -------
> > 22676
> > (1 row)
> >
> > mncis2-rel=# select count(*) from email_queue;
> > server closed the connection unexpectedly
> > This probably means the server terminated abnormally
> > before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
>
> What do the logs say?
>
> --
> Richard Huxton
> Archonet Ltd
>
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2006-10-06 15:32:39 | Re: server closed the connection unexpectedly |
Previous Message | Thomas Poindessous | 2006-10-06 15:15:55 | Problem with a date when restoring on postgresql 7.4.9 : date/time field value out of range |