Re: libc to libicu via pg_dump/pg_restore? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: libc to libicu via pg_dump/pg_restore?
Date
Msg-id CAKAnmmJT_3p+Dtbi7z63u1aYXjmR_D5FK9DKfxWf9hWwC60ovg@mail.gmail.com
Whole thread Raw
In response to Re: libc to libicu via pg_dump/pg_restore?  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
I'm not sure why we are focused on the other errors - the database fails to get dropped (or created), so future errors are to be expected. 

pg_restore should be run with the --exit-on-error flag, and handle the errors one by one as someone mentioned upthread.

I would use the --section=pre-data --section=data and --section=post-data flags to pg_dump to create (for the pre-data) a small and editable file so you can tweak the CREATE DATABASE as you please.

pg_dump mydb --clean --create --section=pre-data --file=mydb.pre.pg

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: libc to libicu via pg_dump/pg_restore?
Next
From: Adrian Klaver
Date:
Subject: Re: libc to libicu via pg_dump/pg_restore?