From: | Francisco Reyes <lists(at)natserv(dot)com> |
---|---|
To: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Troublesome handling of dropped connection |
Date: | 2001-11-26 19:09:38 |
Message-ID: | 20011126140004.X93780-100000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I had connected to a Postgresql database, running 7.1.3 on FreeBSD,
machine through ssh/psql. My machine crashed.
Upon restart of my machine I recconected to the database machine, again
ssh to the machine and then run psql.
The table I was loading data to at the time of the disconnection was
unresponsive. I tried to "truncate" it, tried to "vacuum <table> and psql
would just sit there for a long time. On the server log there were several
"MoveOfflineLogs" entries, but nothing else.
I tried to do a "smart" shutdown (pg_ctl stop) and that didn't seem to
work. I ended up doing "pg_ctl stop -m fast".
After the fast stop, the server came back up fine. Did a vacuum <table>
and it was instantaneous.
Any ideas what happened to the database prior to the shutdown?
I didn't have anyone else connected so it was not a problem shutting down
the server, however is there anything else I could have tried? In the
coming weeks this machine will go into production and then I will have
more users and a shutdown would not be convenient.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-26 19:20:32 | Re: pl/perl won't build under 7.1.3 |
Previous Message | Mike Harding | 2001-11-26 19:04:01 | Re: Strange performance issue |