Troublesome handling of dropped connection
От | Francisco Reyes |
---|---|
Тема | Troublesome handling of dropped connection |
Дата | |
Msg-id | 20011126140004.X93780-100000@zoraida.natserv.net обсуждение исходный текст |
Ответы |
Re: Troublesome handling of dropped connection
|
Список | 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.
В списке pgsql-general по дате отправления: