I'm trying import a database from a machine to another one. Both run debian, pg8.2, aolserver4.5 and oacs-5-3.
I ran the same installation script, created the same user, same psql role, same database name, even same homedir.
But, running
psql -f database-backup/"backdb-file-2007-08-22.dmp" "dbname"
i've got creation roles errors, table creations, relations and dependancies errors as well.
does anyone knows another way to import a database?