View Single Post

   
  #1 (permalink)  
Old 04-09-2008, 10:16 AM
elein
 
Posts: n/a
Default Cannot restart postgres

7.x installation. (Yeah, yeah, upgrade.)

I have a disk which has only the database on it.
It has become full and postgres won't start.

Is there an option (besides restore from backup)
other than trying to move the data dir to a bigger
disk?

Would pg_resetxlog do the right thing to free up
some space so I can go in and vacuum and delete rows?

This is somewhat urgent.

Thanks for your help.

--elein
elein@varlena.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote