[postgis-users] Moving to AWS RDS PostgreSQL

[Paul & Caroline Lewis]

Hi,   I'm running a postgres 9.1/postgis 1.5 platform on an AWS EC2 machine. I want to move to the new AWS RDS postgresql set-up so I need a couple of steps cleared up on transferring as it involves upgrading to postgis 2 at the same time.
So far I've dumped the existing DB using:
 pg_dump -Fc -b -v -f "db.backup" database -h localhost -p 5432 -U user
But to upgrade and dump onto the RDS instance is not clear and doesn't seem to work for me. I tried the following:
 perl utils/postgis_restore.pl /some_location/db.backup | psql -h aws-auth-stuff.aws-region.rds.amazonaws.com -p 5432 -U user database 2> errors.txt
All this does is ask for the DB password and once entered just returns to the terminal prompt. No error messages.
Can anyone advise on what I may be doing wrong.
Thanks
Paul
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131210/0827b86f/attachment.html>