Hello team,

We have a postgres11.2 on docker and we are migrating a kb_rep database from 
postgres 9.6 to postgres 11.2 via pg_dump/pg_restore
We have created a kb_rep schema in postgres 11.2 also but during pg_restore 
there is an error "pg_restore: [archiver (db)] connection to database "kb_rep" 
failed: FATAL:  database "kb_rep" does not exist"

See below:

psql (11.2 (Ubuntu 11.2-1.pgdg18.04+1))
Type "help" for help.

postgres=# \l
                              List of databases
   Name    |  Owner   | Encoding | Collate |  Ctype  |   Access privileges
-----------+----------+----------+---------+---------+-----------------------
kb_rep    | postgres | UTF8     | C.UTF-8 | C.UTF-8 |
kbdb      | postgres | UTF8     | C.UTF-8 | C.UTF-8 |
postgres  | postgres | UTF8     | C.UTF-8 | C.UTF-8 |
template0 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | =c/postgres          +
           |          |          |         |         | postgres=CTc/postgres
template1 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | =c/postgres          +
           |          |          |         |         | postgres=CTc/postgres
(5 rows)

postgres=#


postgres@b06a42b503e9:/$ pg_restore -h 10.29.50.21 -p 5432 -d kb_rep -v 
/var/lib/kb_rep_backup16
pg_restore: connecting to database for restore
Password:
pg_restore: [archiver (db)] connection to database "kb_rep" failed: FATAL:  
database "kb_rep" does not exist
postgres@b06a42b503e9:/$

Please help on this issue.

Regards,
Daulat



Reply via email to