I am migrating from a manually managed database on Postgres 9.4.10 and PostGIS 2.1 to an RDS instance on Postgres 9.4.9 and PostGIS 2.1.
The restore seems successful, but the output gave me 27 ignored errors. Here is the output: http://developers.mapseed.org/posts/restore-output.txt
Should I be concerned? All of my unit tests are passing, but this is a production database, so I want to be sure. They seem to be errors related to permissions, but both my pg_dump
and pg_restore
commands were run with the postgres
user. Although perhaps I’m missing something.
step by step of the dump/restore:
My database is named shareabouts_v2
, so on my RDS instance, I ran a create database shareabouts_v2
and create extension postgis
.
Then I created a dump file from my current database with the following command: pg_dump -f shareabouts_v2.boundless-backup -Fc -p 5432 -U postgres -h localhost shareabouts_v2
and I restored that dump file into my RDS instance with the following command:
pg_restore -v -U postgres -h <my-RDS-host> -p 5432 -d shareabouts_v2 shareabouts_v2.boundless-backup
I have followed numerous posts and best practices around dumping and restoring PostGIS data