Actually, a subject. There is a dump made using pg_dump.
There are two questions:
1) In off the dock it is written:
psql dbname < infile The database dbname will not be created by this command, so you must create it yourself from template0 before executing psql (e.g., with createdb -T template0 dbname).
I.e., the database must be created. Is it possible to see how was created the portable database (similar to SHOW CREATE DATABASE db_name MySQL) or all instances can be safely created using createdb -T template0 dbname ?
2) Again, in off the dock it is written:
Before restoring an SQL dump, all the users who own objects or were granted permissions on objects in the dumped database must already exist. If they do not, the restore will fail to recreate the objects with the original ownership and/or permissions. (Sometimes this is what you want, but usually it is not.
Ie needs to be created the same users on the server from the portable database. As they migrate users, is it possible to automate the process?