Hi Karsten.. On Sun, Mar 13, 2016 at 12:09 AM, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> wrote: > I am trying to pg_restore from a directory dump. > However, despite using > > --clean > --create > --if-exists > > I am getting an error because schema PUBLIC already exists. ....snip, snip.... Have you tried the classic combo pg_restore -l > toc.dat, your_favorite_editor toc.dat pg_restore -L toc.dat? I've had great success with that in the past, even splitting the TOC in several chunks to be able to make adjustements between them, but I've never used the directory format for ( serious, I've tried all when learning ) backups. Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
