pg-restore

Exactly like @Eelke said – you’ve got in file wrote ‘create database’ so this database does not exist when you’re running script… That’s what for there is always ‘postgres’ database. Try this: pg_restore -C -d postgres -v -h xxhostxx -p 5432 -U xxuserxx test_pg_dump.dmp** And this should: connect to postgres database Create test database Disconnect … Read more

this did the trick pg_dump database_name -c -Ft -f file_name.tar pg_restore -d database_name -c file_name.tar before this i was trying to restore with out including -c(clean) even though -c is included in pg_dump it is not used in pg_restore unless we say to use…

pg_restore, when run without a database name, outputs a text dump to stdout; you can send that elsewhere with -f or with I/O redirection. pg_restore -f mydatabase.sql mydatabase.dump Note that you must ensure there’s no PGDATABASE environment variable set, or it’ll try to connect to that database.

You have to add the name of a valid database to initially connect to or it will just dump the contents to STDOUT: pg_restore –create –exit-on-error –verbose –dbname=postgres <backup_file>

A quick and dirty way: 1) rename default schema: alter schema public rename to public_save; 2) create new schema as default schema: create schema public; 3) restore data pg_restore -f pub.backup db_temp [and whatever other options] 4) rename schemas according to need: alter schema public rename to temp_schema; alter schema public_save rename to public;