[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

postgres upgrade failed.....


i got used to the automatic postgres upgrade... and stopped making
myself dumps before upgrading... :(

    and now i am stuck.. the automatic upgrade failed, and i don't know
    how to get this back...

i tried the migration file, but couldn't get something usable out of
postgresql-dump -t db.out -dcivlp $PGDATA/../data.save issues an empty

so i tried fiddling by myself...
i restored the pg_hba.conf file, started :
dumpall/7.2/postmaster -i and tried:
dumpall/7.2/pg_dumpall but get:
psql: FATAL 1:  No pg_hba.conf entry for host localhost, user postgres,
  database template1

but there is a line for localhost set to trust in the access file....
again, i am a bit clueless...

ciao bboett

Reply to: