Re: Backup and Restore (pg_dump & pg_restore)

On 4/21/19 1:46 PM, Adrian Klaver wrote:
> On 4/21/19 9:35 AM, Daulat Ram wrote:
>> Hello Team,
>>
>> We are getting below error while migrating pg_dump from Postgresql 9.6 to
>> Postgresql 11.2 via pg_restore in docker environment.
>>
>> 90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19"
>>
>> pg_restore: [archiver (db)] Error while PROCESSING TOC:
>>
>> pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA
>> public postgres
>>
>> pg_restore: [archiver (db)] could not execute query: ERROR: schema
>> "public" already exists
>>
>> Command was: CREATE SCHEMA public;
>
> Expected as the public schema is there by default. It is an informational
> error, you can ignore it.

"Informational error" is a contradiction in terms.

--
Angular momentum makes the world go 'round.