I have been trying to import/load a shapefile into a PostGis database without any success despite many trials and searching an answer in the documentation.
I’m running Windows 64 bits Home (in japanese )
I used 2 differents methods without any results
METHOD 1 – using the shp2pgsql-gui.exe/postGis shapefile import gui
*Here are the connection details
password : i put the same password I usually input in pgadmin4
server host "localhost" then for the port "5432"
database : gis_analysis (a postgis database)
*And I get the following error message :
"unable to connect to the database – please check your connection settings"
and the log message
"Connecting: host=localhost port=5432 user=postgres password=’*********’ dbname=gis_analysis client_encoding=UTF8
*I checked TCPIP to check if the port 5432 was opened
I got 3 sessions of pgadmin4 running on remote port 5432 with a state "established" and some sent packets
METHOD 2 – using psql/the windows prompt command
I was planning to use something like this kind of syntax :
shp2pgsql -I -s SRID -W encoding shapefile_name table_name | psql -d database -U
But even when I’m running the following command in the prompt command
psql -d gis_analysis -U postgres
*I first get a enter the password : the password does not show up in the terminal but my understanding is that it’s normal.
I typed slowly the
I also copied pasted to make sure I don’t make a mistake)
*Eithe way I then get the following error message (for clarity sake, I get a japanese message but I put here the standard message in english that seems to be used)
‘psql: FATAL: password authentication failed for user "postgress"’
I can use (import, export, select, alter) a variety of database/tables in pgadmin4 without connection trouble (at worst sometimes it fails because it’s too slow but it seems unrelated to me).
I can specifically create a table within my gis_analysis postgis database. I can both import csv file into this table, I can alter/update the table, I can select data from it.
But somehow I cannot import a shapefile
Nor can I use the command prompt, either for the postgis database or any other database.
I am inclined to think it’s a username/password problem based on the fact there is no port problem and that I cannot access any kind of database with psql.
But I don’t understand why I don’t have this connection problem with pgadmin4 and yet when I run either shp2pgsql-gui or psql it doesnt work.
I am at my wit’s end.
Any insight ?