<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<div> 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.</div><div><br></div><div>So far I've dumped the existing DB using:</div><div><br></div><div> pg_dump -Fc -b -v -f "db.backup" database -h localhost -p 5432 -U user</div><div><br></div><div>But to upgrade and dump onto the RDS instance is not clear and doesn't seem to work for me. I tried the following:</div><div><br></div><div> 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</div><div><br></div><div>All this does is ask for the DB password and once entered just returns to the terminal prompt. No error messages.</div><div><br></div><div>Can anyone advise on what I may be doing wrong.</div><div><br></div><div>Thanks</div><div><br></div><div>Paul</div><div><br></div> </div></body>
</html>