When doing a PostgreSQL database server upgrade, you first need to backup all of the databases because the format changes from version to version.
Postgresql documentation states you need to run the command:
pg_dumpall > outputfile
I ran this, and received the error message:
pg_dumpall: could not connect to database “template1″: FATAL: role “root” does not exist
So after [...]
Categories: Linux, MySQL, System Administration
Tagged: backup, postgresql
