| From: | Jenny <jenny_tania(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | need help (not anymore) |
| Date: | 2005-12-06 09:41:15 |
| Message-ID: | 20051206094115.42113.qmail@web31502.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance pgsql-sql |
I run the VACUUM as you suggested, but still no response from the server. So, I
decided to DROP the database. I got a message that the database is being used.
I closed every application that accessing it. But, the message remains.
I checked the server processes (ps -ax). There were lots of 'UPDATE is waiting
...' on the list. I killed them all. I backuped current database and DROP the
database, restore to the backup file I just made.
Don't really know why this happened, but thankfully now, everything's normal.
Thank you, guys.
Regards,
Jenny Tania
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2005-12-06 09:41:55 | Re: Using a 250GB RAID10 server for postgres |
| Previous Message | Kathy Lo | 2005-12-06 09:22:30 | Memory Leakage Problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joost Kraaijeveld | 2005-12-06 09:43:49 | Can this query go faster??? |
| Previous Message | Rory Campbell-Lange | 2005-12-06 09:38:18 | LVM and Postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2005-12-06 10:45:48 | Re: need help |
| Previous Message | Tino Wildenhain | 2005-12-06 08:54:40 | Re: need help |