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_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
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
Our proxies have TOP level of anonymity + Elite quality, so you are always safe and secure with your proxies
Use your proxies as much as you want – we have no limits for data transfer and bandwidth, unlimited usage!
Superb fast proxy servers with 1,000 mb/s speed – sit back and enjoy your lightning fast private proxies!
99,9% servers uptime
Alive and working proxies all the time – we are taking care of our servers so you can use them without any problems
No usage restrictions
You have freedom to use your proxies with every software, browser or website you want without restrictions
Buy more proxies and get better price – we offer various proxy packages with great deals and discounts
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!