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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
