How do I move a postgres database (lets call it "mydb") from server
"foo" to server "bar".
I tried "pg_dump -f mydb.dmp -F c -b mydb" on foo and "pg_restore -F c
-d mydb mydb.dmp" on bar (after scping it over) but I get strange errors :
pg_restore: creating FUNCTION "tree_ancestor_keys" (bit varying,integer)
pg_restore: [archiver (db)] could not execute query: ERROR: Function
'tree_ancestor_keys(varbit, int4)' does not exist
Unable to identify a function that satisfies the given
argument types
You may need to add explicit typecasts
Any idea, maybe a quick howto how you do it normally ?