I'm trying to import a mapinfo file into my db and I got these 2 errors
- Permission denied for relation geometry_columns
- ERROR 1: PostgreSQL driver doesn't currently support database creation.
Please create database with the `createdb' command.
PostgreSQL driver failed to create PG:host=ogldev user=dba dbname=geo password=\!DBA\!
It is a linux server so i got to escape the special character '!' in the password. I suspect that is the problem since I successfully imported that mapinfo table in the same database but with another user with a simpler password. I'm not creating a database and the on used, geo, already exists.
Here is the command.
ogr2ogr --config PGCLIENTENCODING LATIN1 -f "PostgreSQL" PG:"host=ogldev user=dba dbname=geo password=\!DBA\!" -s_srs "EPSG:4269" -t_srs "EPSG:4326" -nln installations -lco GEOMETRY_NAME=geom4326_p /srv/data/Installations.TAB
What can cause these errors?
thanks
steve
What can cause these errors?
thanks
steve
Si vous n'êtes pas le destinataire de ce message, veuillez le détruire près avoir informé l'expéditeur de son erreur. Par ailleurs, il est interdit de copier ou de modifier ce courriel sans l'autorisation de l'auteur.
L'Institut national de santé publique du Québec n'assume aucune responsabilité à l'égard du contenu des messages personnels envoyés par ses employés.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
