Alexandre Leclerc wrote: > Thank you Scott for this note. > > I wanted to give some feedback on the situation: > > - The vacuum completed after about 6-7 hours (by 16:15 PM). We > immediately made a backup before proceeding further. Then we vacuumed > the postgres et template1 databases. > > - We were then successful at restarting postmaster and working with the > database. Everything works as expected. > > Among all the help received (thank you all) I want to specially thank > Kevin and Tom for their excellent help and time through this urgent > problem we had to fix. I want to underline their detailed and precise > posts that were of great value for acting and taking decisions to > recover the DB. Thank you guys! As another followup item, it would be good for your organization to get some Postgres training and a commercial support contract from someone who is paid to help you in such a crisis, or help you long before it becomes a crisis. These kind of problems make everyone look bad. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
