| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
| Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Backup and Restore (pg_dump & pg_restore) |
| Date: | 2019-04-21 16:18:24 |
| Message-ID: | 20190421161824.aybvezdn6lzsdj2a@development |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Sat, Apr 20, 2019 at 06:50:47PM +0000, 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;
>
>
How is this related to performance? Please send it to pgsql-general, and
include information about how you created the dump.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daulat Ram | 2019-04-21 16:35:59 | Backup and Restore (pg_dump & pg_restore) |
| Previous Message | Pavan Kumar | 2019-04-20 21:34:17 | postgres database complete recovery |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daulat Ram | 2019-04-21 16:35:59 | Backup and Restore (pg_dump & pg_restore) |
| Previous Message | Tomas Vondra | 2019-04-21 16:15:25 | Re: Out of Memory errors are frustrating as heck! |