I am following this tutorial,

but i am not able to get the right username and password to import data. How do I know what the username password is? By default I see tomcat6 as database and username and no password in the textbox. As i am following the tutorial I changed it to username: postgis and password: postgres.

How do I know what my username and password is?


Import the data in PostGIS, which requires PostGIS connection.


Ok so i got the user and passwd but when I am trying to add the shapefile using the Shape File to PostGIS Importer Plugin and having made connection successfully, I am getting this error when I am adding the shapefile.

Connecting: host=localhost port=5432 user=admin dbname=shpRepo password='**********' 
Connection succeeded.
Connection: host=localhost port=5432 user=admin dbname=shpRepo password='**********' 
Destination: public.AllQuebecSpecies
Source File: /home/smaranh/development/Biodiversity/biodiversity/shapefile/AllQuebecSpecies
Shapefile type: Point
Postgis type: POINT[2]
CREATE TABLE "public"."AllQuebecSpecies" (gid serial PRIMARY KEY,
"family" varchar(50),
"species" varchar(50));
SELECT AddGeometryColumn('public','AllQuebecSpecies','the_geom','-1"
Failed in pgui_exec(): ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 7: SELECT AddGeometryColumn('public','AllQuebecSpecies','the_ge...
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Shapefile import failed.

Can somebody tell me where am I going wrong?

  • 1
    do you have pgadmin III pgadmin.org/visualtour14.php ? you can check your postgres/postgis connections with that.
    – Mapperz
    May 14, 2012 at 20:10
  • Yes I have but as I said I do not know the username and password for it
    – Sam007
    May 14, 2012 at 22:14
  • * ---------- ---------- Heading ======= ----------------------------------------------------------------------- * Connecting: host=localhost port=5432 user=postgres password='********' dbname=postgres Connection succeeded. Connecting: host=localhost port=5432 user=postgres password='********' dbname=postgres ============================== Importing with configuration: thsl, public, geog, C:\Users\Madhav\Desktop\thsl\thsl, mode=c, dump=1, simple=1, geography=1, index=1, shape=1, srid=0 Shapefile type: Polygon PostGIS type: POLYGON[2] Failed SQL begins: "SET CLIENT_ENCODING TO UTF8; SET STANDARD
    – user16826
    Apr 4, 2013 at 10:57
  • Confirm that you actually have PostGIS installed in your target database. Run "Select postgis_full_version()" Apr 4, 2013 at 17:27
  • how can i check that postgis is installed or not
    – user28536
    Feb 3, 2016 at 17:54

3 Answers 3


Have you tried the username and password they show in the image when reading the documentation? (admin/geoserver)

When you first start the dashboard, it provides a reminder about the default password for accessing GeoServer [....] {followed by the image}

Otherwise, just above step 1 it says:


The PostGIS database has been installed with unrestricted access for local users (users connecting from the same machine as the database is running). That means that it will accept any password you provide. If you need to connect from a remote computer, the password for the postgres user has been set to postgres.

  • Actually i am working on Ubuntu and u need to create the user and assign password from the terminal and then start working on the PostGIS which does not open as shown in your instructions (which is only for Windows), we need to run pgadmin3 which open the PostGIS and then by entering the newly configured user and password can we create the database. Appreciate your help.
    – Sam007
    May 17, 2012 at 23:30

Maybe you created a database without PostGIS extension. You should choose the PostGIS template on the 'Definition' tag when creating a new database.


Here is one way to import data in postGIS from shapefile.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.