PG_restore

[Shawnt21]

I Keep getting a schema  'public' already exists error when I try to import the db, tried to drop the db and recreate, but no luck

[Benoit_C]

Hello @Shawnt21,

The export of the DB has been done with what version of Postgres ?

And the Import is done with what version of Postgres ?

Regards,

Benoit

[Benoit_C · Accepted solution]

Hello,

This error is most probably due to a mix of version, you need to import the db with the same postgres version than the one used for the export.

Regards,

Benoit

[LTIAT951]

Hi Team, I encounter the similar issue, while exporting the QSR from August 2022 version and restoring to Feb 2024 Version. 

PostgreSQL version during export was 9.6 and wanted to import in POSTGRESQL 14 version. 

Any workaround for this issue?