Hi All,
I have a database dump that is created with the following command:
pg_dump IPADB -Ft -s -v -U postgres | gzip -9 > ${IPA_TMP_DIR}/IPADB.$(date +"%
Y%m%d.%H%M%S").tar.gz
I want to create a test database but I am having difficulty understanding how
to use pg_restore.
# pg_restore --create --dbname=IPA_TEST --schema-only --verbose -U postgres
TEST.tar
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "IPA_TEST" failed: FATAL:
Database "IPA_TEST" does not exist in the system catalog.
pg_restore: *** aborted because of error
The documentation indicates that the dumpfile is meant to be used by psql and
that I have to create the database manually prior to the restore. So what is
the purpose of pg_restore and it's --create option?
Any hints appreciated.
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com