I am going to move a database from the old server to a new one.
- the old one runs PostgreSQL 9.1, the new one has 9.3.
- I want to change the database name.
- I want the new database to be in a dedicated tablespace (the old one is in default) - including indices, etc.
Unfortunately, I have no chance to experiment (and HDDs of the old server start to fail) so I ask for the options for pg_dump/pg_restore that would work in my case.