In response to Jaime Silvela <JSilvela@xxxxxxxx>: > I know you've probably discussed this in many places, but I have a crash > right now I need to recover from, and I'm not finding documentation that > fast. > Where should I go? > > Here are the details on starting, after a kill -9 of a process brought > Postgres down. > > Is there a page/s with information on quick recovery after corruption? > LOG: could not create IPv6 socket: Address family not supported by protocol > LOG: database system was interrupted while in recovery at 2007-04-05 > 08:18:47 EDT > HINT: This probably means that some data is corrupted and you will have > to use the last backup for recovery. Do you have dumps? Hopefully you do, in which case your best bet may be to backup your config files, then blow away the cluster directory and re-initdb, then restore from dump. -- Bill Moran http://www.potentialtech.com
