Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > On 4/21/19 9:35 AM, Daulat Ram wrote: >> 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. It's expected only if you made a dump file with 9.6's pg_dump and restored it with a later pg_restore; there were some changes in how the public schema got handled between the two versions. The usual recommendation when you are doing a version migration is to use the newer release's pg_dump to suck the data out of the older server. If you can't do that, it'll (probably) still work, but you may have cosmetic issues like this one. regards, tom lane
