[postgis-users] Moving to AWS RDS PostgreSQL

[Sylvain Racine [iGreffe Géomatique]]

Did you install PostGIS and topology extensions in your new DB BEFORE
doing your command? 

CREATE EXTENSION postgis; 

CREATE EXTENSION topology; 

Run also legacy.sql in your new DB to ensure compliance with the old
PostGIS functions if you use PostGIS with an old application. The script
should be near the directory where you can find 'psql' command (ex.:
/usr/bin/psql ==> /usr/bin/share/contrib/postgis-2.0) in Ubuntu when you
install EnterpriseDB package. 

Regards 

-- 

Sylvain Racine
iGreffe Géomatique
50, St-Hubert, n° 5
Granby, Québec
J2G 5L9
Tél: 450-770-9974

Le 2013-12-10 16:27, Paul & Caroline Lewis a écrit : 

> I can connect fine using psql and a select version(); responds with 
> -------------------------------------------------------------------------------------------------------------- 
> 
>  POSTGRESQL 9.3.1 ON X86_64-UNKNOWN-LINUX-GNU, COMPILED BY GCC (GCC) 4.6.3 20120306 (RED HAT 4.6.3-2), 64-BIT
> 
> I have also created the PostGIS extension on the DB I've created in the RDS version through PGADMIN. 
> 
> Tried exporting PGPASSWORD but still no joy. Having it exported stops the password prompt and the psql connection is still fine. 
> 
> The errors.txt file is empty based on the commands line in previous mail. 
> 
> If I remove the target DB from the command line the errors.txt has a FATAL db does not exist error. 
> If I remove the target DB from postgresql through PGADMIN and run the command line, errors.txt contains the FATAL db does not exist error. 
> If I change the user the errors.txt file populates with a user error. 
> 
> So the RDS platform is getting connected to but it would seem that the pipe dies because when the PGPASSWORD is set and users are correct and DB's in place the process starts but dies immediately with no error messages. 
> 
> Will continue to search for what next. 
> 
> Thanks again, 
> 
> Paul 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users [1]

 

Links:
------
[1] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131210/2727bc53/attachment.html>