Hi list,
We have developed an application that makes extensive use of schema's in the
database. Some of the schemanames are uppercase, some are lowercase.
I make a backup using
pg_dump -f /tmp/dumpdb -F c -Z 5 cvix
When I try to restore this file, it fails with
postgres@linux:/tmp> pg_restore -O -d cvix2 /tmp/dumpdb
pg_restore: [archiver (db)] could not execute query: ERROR: schema "Lindix"
does not exist
What am I doing wrong, or is it a bug. After the restore the database does
contain the schema's but all in lowercase.
Hope someone knows what to do!
Cheers,
Dick Kniep