<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello, i'm new to PostGIS and OSGeo. I have a problem converting a
FileGDB to PostGIS using ogr2ogr.<br>
<br>
First some background on what i've done:<br>
<br>
Installed OpenGeo Suite Enterprise Edition 3.0 to c:\Program Files
(x86)\OpenGeo\OpenGeo Suite\<br>
<br>
Did the Introduction to PostGIS tutorial at
<a class="moz-txt-link-freetext" href="http://workshops.opengeo.org/postgis-intro/">http://workshops.opengeo.org/postgis-intro/</a><br>
<br>
Downloaded OSGeo4W from <a class="moz-txt-link-freetext" href="http://trac.osgeo.org/osgeo4w">http://trac.osgeo.org/osgeo4w</a> <br>
<br>
Installed via "Advanced install" (to also include) the "ogr2ogr"
tool to c:\OSGeo4W\<br>
<br>
Downloded test_fgdb.gdb.zip -- a test GDB file (created with ArcGIS
ver 10) by Michael Smith from
<a class="moz-txt-link-freetext" href="http://12.189.158.78:8081/downloads/test_fgdb.gdb.zip">http://12.189.158.78:8081/downloads/test_fgdb.gdb.zip</a> <br>
(<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/pipermail/gdal-dev/2011-April/028391.html">http://lists.osgeo.org/pipermail/gdal-dev/2011-April/028391.html</a>)<br>
<br>
Unpacked the GDB file to c:\Users\Martin\Documents\test.gdb\<br>
<br>
Now here's the problem:<br>
<br>
Using OSGeo4W shell command<br>
<b><tt> c:\OSGeo4W\bin\ogr2ogr -f "PostgreSQL" PG:"dbname=test
user=postgres" c:\Users\Martin\Documents\test.gdb</tt></b><br>
i got<br>
ERROR 1: PQconnectdb failed.<br>
could not connect to server: Connection refused
(0x0000274D/10061)<br>
Is the server running on host "???" and accepting<br>
TCP/IP connections on port 5432?<br>
<br>
ERROR 1: PostgreSQL driver doesn't currently support database
creation.<br>
Please create database with the `createdb' command.<br>
PostgreSQL driver failed to create PG:dbname=test user=postgres<br>
<br>
I get the same error messages whether or not i've already created a
test database via pgAdminIII.<br>
What do i need to do?<br>
<br>
I remember having to append a '1' to the port "5432" when using
pgAdminIII but know very little of hosts, servers and ports.<br>
<br>
I notice that psql.exe is in two places (and two v. different
versions):<br>
<b><tt> c:\Program Files (x86)\OpenGeo\OpenGeo Suite\</tt></b><b><tt><br>
</tt></b><b><tt> pgsql\9.1\bin\psql.exe 419,328
31/05/2012</tt></b><b><br>
</b>and<br>
<b><tt> c:\OSGeo4W\bin\psql.exe 299,008 11/03/2010</tt></b><b><br>
</b>Would that be an issue?<br>
<br>
Any help would be very much appreciated -- even if only a pointer to
a better place to ask the question.<br>
<pre class="moz-signature" cols="72">--
Martin Feuchtwanger <a class="moz-txt-link-abbreviated" href="mailto:feumar@shaw.ca">feumar@shaw.ca</a> 604-254-0361
Vancouver, BC members.shaw.ca/geomatics.developer
</pre>
</body>
</html>