Hi,
I'm trying to backup a schema in a database which uses OIDs. Using
pg_dump | psql works fine, but I need to backup it to a file. So I
tried using pg_dump like this:
pg_dump -h localhost -U usr -F c -f dump.sql -o -n my_schema -b source_db_name
And then restoring it with:
pg_restore -d target_db_name -h localhost -U usr -W -F c dump.sql
And it always fails when restoring some of the OIDs or because of
foreign key restrictions.
How can I backup this successfully?
Thanks,
--
Khristian Alexander Schönrock