James B. Byrne wrote:
Hi,
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4; 2615 2200 SCHEMA
public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
drop
schema public because other objects depend on it
HINT:
I move a compressed pg_dump archives across the wire to a remote
host on a regular schedule. The process completes and the archives
are restored on the remote site and the resulting database performs
as expected.
However, I get this returned to me at the end of each
dump/transfer/restore