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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
