| From: | Nicola Contu <nicola(dot)contu(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Cc: | Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net> |
| Subject: | Pg_restore |
| Date: | 2019-03-01 08:17:57 |
| Message-ID: | CAMTZZh0fxVcWxSWSHG+s0Omniakcfm2ASiA7gnVK_5nLXoLLkA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
we are trying to move our postgres 10.5 instance to 11.2
We are trying to restore a DB in a pre-production env but we get an error
on the pg_restore command
[root(at)STAGING]# /usr/local/pgsql11.2/bin/pg_restore -v -U postgres -L
/data/cofinder_restore.lst -d cofinder -j 16
/home/ncontu/data/dbbackups/C
pg_restore: connecting to database for restore
pg_restore: processing item 3098 ENCODING ENCODING
pg_restore: processing item 3099 STDSTRINGS STDSTRINGS
pg_restore: processing item 3100 SEARCHPATH SEARCHPATH
pg_restore: processing item 3101 DATABASE cofinder
pg_restore: processing item 3 SCHEMA public
pg_restore: creating SCHEMA "public"
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;
The dump is taken with pgsql10 binaries.
Can you help on this please?
We also have another DB, but with the other one no issues doing the same
thing.
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2019-03-01 08:38:23 | Re: Pg_restore |
| Previous Message | Michael Lewis | 2019-03-01 05:22:05 | Re: Overloaded && operator from intarray module prevents index usage. |