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