Hi,
$ which gdal-config
/usr/local/bin/gdal-config
and version is:CONFIG_VERSION=“1.8.1”
is PostgreSQL included in
/usr/local/bin/ogrinfo --formats
[user@lab35 local]$ /usr/local/bin/ogrinfo --formats
Supported Formats:
→ “ESRI Shapefile” (read/write)
→ “MapInfo File” (read/write)
→ “UK .NTF” (readonly)
→ “SDTS” (readonly)
→ “TIGER” (read/write)
→ “S57” (read/write)
→ “DGN” (read/write)
→ “VRT” (readonly)
→ “REC” (readonly)
→ “Memory” (read/write)
→ “BNA” (read/write)
→ “CSV” (read/write)
→ “GML” (read/write)
→ “GPX” (read/write)
→ “KML” (read/write)
→ “GeoJSON” (read/write)
→ “GMT” (read/write)
→ “SQLite” (read/write)
→ “PostgreSQL” (read/write)
→ “PCIDSK” (read/write)
→ “XPlane” (readonly)
→ “AVCBin” (readonly)
then what to do?
“If you don’t know where you are going any road will get you there”
Regards
suprakash
From: suprakash maitra suprakashmaitra@yahoo.com
To: “grass-dev@lists.osgeo.org” grass-dev@lists.osgeo.org
Sent: Tuesday, April 9, 2013 1:32 PM
Subject: Re: Export from GRASS to Postgres
Hi
You have given some commands,on the basis of that o/p is as follows:
[user@lab35 ~]$ ogrinfo --version
GDAL 1.8.1, released 2011/07/09
[user@lab35 ~]$ gdal-config --libs
-L/usr/local/lib -lgdal
[user@lab35 ~]$
g.version -b (in GRASS 6)
./configure --with-postgres-includes=/opt/PostgreSQL/9.1/include --with-postgres-libs=/opt/PostgreSQL/9.1/lib --with-freetype-includes=/usr/include/freetype2 --with-freetype-libs=/usr/lib --with-cxx --with-python --with-fftw --with-freetype --with-gdal=/usr/local/bin/gdal-config --with-postgres
according to you there is a different GDAL library,
then how can check it or what should I do with it,to get things done.
Thanks in advance
“If you don’t know where you are going any road will get you there”
Regards
suprakash
From: suprakash maitra suprakashmaitra@yahoo.com
To: “grass-dev@lists.osgeo.org” grass-dev@lists.osgeo.org
Sent: Monday, April 8, 2013 6:21 PM
Subject: Re: Export from GRASS to Postgres
Hi,
v.in.ogr -f
ESRI Shapefile (rw): ESRI Shapefile
MapInfo File (rw): MapInfo File
UK .NTF (ro): UK .NTF
SDTS (ro): SDTS
TIGER (rw): TIGER
S57 (rw): S57
DGN (rw): DGN
VRT (ro): VRT
REC (ro): REC
Memory (rw): Memory
BNA (rw): BNA
CSV (rw): CSV
GML (rw): GML
GPX (rw): GPX
KML (rw): KML
GeoJSON (rw): GeoJSON
GMT (rw): GMT
SQLite (rw): SQLite
PCIDSK (rw): PCIDSK
XPlane (ro): XPlane
AVCBin (ro): AVCBin
AVCE00 (ro): AVCE00
DXF (rw): DXF
Geoconcept (rw): Geoconcept
GeoRSS (rw): GeoRSS
GPSTrackMaker (rw): GPSTrackMaker
VFK (ro): VFK
PGDump (rw): PGDump
GPSBabel (rw): GPSBabel
SUA (ro): SUA
OpenAir (ro): OpenAir
PDS (ro): PDS
WFS (ro): WFS
HTF (ro): HTF
AeronavFAA (ro): AeronavFAA
Available OGR Drivers:
(Mon Apr 8 18:17:56 2013) Command finished (0 sec)
[user@lab35 local]$ ogrinfo --formats
Supported Formats:
→ “ESRI Shapefile” (read/write)
→ “MapInfo File” (read/write)
→ “UK .NTF” (readonly)
→ “SDTS” (readonly)
→ “TIGER” (read/write)
→ “S57” (read/write)
→ “DGN” (read/write)
→ “VRT” (readonly)
→ “REC” (readonly)
→ “Memory” (read/write)
→ “BNA” (read/write)
→ “CSV” (read/write)
→ “GML” (read/write)
→ “GPX” (read/write)
→ “KML” (read/write)
→ “GeoJSON” (read/write)
→ “GMT” (read/write)
→ “SQLite” (read/write)
→ “PostgreSQL” (read/write)
→ “PCIDSK” (read/write)
→ “XPlane” (readonly)
→ “AVCBin” (readonly)
→ “AVCE00” (readonly)
→ “DXF” (read/write)
→ “Geoconcept” (read/write)
→ “GeoRSS” (read/write)
→ “GPSTrackMaker” (read/write)
→ “VFK” (readonly)
→ “PGDump” (read/write)
→ “GPSBabel” (read/write)
→ “SUA” (readonly)
→ “OpenAir” (readonly)
→ “PDS” (readonly)
→ “WFS” (readonly)
→ “HTF” (readonly)
→ “AeronavFAA” (readonly)
“If you don’t know where you are going any road will get you there”
Regards
Suprakash
From: suprakash maitra suprakashmaitra@yahoo.com
To: “grass-dev@lists.osgeo.org” grass-dev@lists.osgeo.org
Sent: Monday, April 8, 2013 4:00 PM
Subject: Re: Export from GRASS to Postgres
Hi
I am using Fedora15,GRASS-6.4.2,gdal-1.8.1,postgresql-9.1.I have compiled gdal with postgresql support and GRASS with gdal and postgreSQL support ,even then while exporting map/mapset to postgreSQL the format PostgreSQL is not supported.
Plz help me out.
“If you don’t know where you are going any road will get you there”
Regards
Suprakash
From: suprakash maitra suprakashmaitra@yahoo.com
To: “grass-dev@lists.osgeo.org” grass-dev@lists.osgeo.org
Sent: Wednesday, April 3, 2013 5:44 PM
Subject: Export from GRASS to Postgres
Hi All,
I am trying to export GRASS maps/mapsets to PostgreSQL.At the time of installation of GRASS ,I have configured it with Postgres.
The command used is:
v.out.ogr -c input=fields type=area ‘dsn=PG:host=localhost dbname=grass user=grassuser password=grassuser’ olayer=fields2postgis layer=1 format=PostgreSQL
The database grass is postgis enabled.
However the format “PostgreSQL” is taken as invalid format.
Without “PostgreSql” format the maps are exported to ESRI_shapefile format.
One thing more, There is no PostgreSql format type in OGR format dropdown list in case of using GUI.
Please help me out.
Thanks in advance.
“If you don’t know where you are going any road will get you there”
Regards
Suprakash