Re: Backup and Restore (pg_dump & pg_restore)

On 4/21/19 3:58 PM, Adrian Klaver wrote:
> On 4/21/19 1:42 PM, Ron wrote:
>> 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.
>>
>
>
> 1) Well the public schema was in the dump, so the OP wanted it.
> 2) It also existed in the target database.
> 3) The error let you know 1) & 2)
> 4) To my way of thinking it was a 'no harm, no foul' situation where the
> error just informed you that the target database took a side track to get
> where you wanted to be anyway.
>
> I see this sort of thing in monitoring systems e.g. environmental controls
> all the time. Things get flagged because they wander over set points
> intermittently. It is technically an error but unless they stay over the
> line it is just another data point.

Errors need to be fixed.  If the restore can proceed without harm, then it's
an Informational message.

--
Angular momentum makes the world go 'round.