[postgis-users] Moving to AWS RDS PostgreSQL

[Paul Ramsey]

You might have to put the password into the environment to avoid the
prompt screwing up the pipe...

export PGPASSWORD=yourpassword

(Im' assuming you've already tested psql connectivity and ensured you
can in fact connect via psql)

P.

On Tue, Dec 10, 2013 at 12:05 PM, Paul & Caroline Lewis
<paulcaz80 at hotmail.com> wrote:
> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users