PG error whem importing extracts

[Alex Cruz-3]

For some reason, I am receiving the following error when trying to import my
states OSM data:

$ ./osm2pgsql -m -d gis wisconsin.osm.bz2
osm2pgsql SVN version 0.69-18504

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point" does not exist, skipping
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
 failed: ERROR:  AddGeometryColumns() - invalid SRID
CONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 ,
$5 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement

Error occurred, cleaning up


Any idea what could be causing this? BTW, this is a clean install.

Thanks.

-alex
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

[Ross Scanlon]

Incorrect permissions in the database for you as user.  It's not creating the databases before trying to add the osm data.

Check here:

http://sourceforge.net/apps/mediawiki/gpsdrive/index.php?title=8.04_manual

Under the section on setting up postgreSQL and postGIS


Cheers
Ross


On Sun, 8 Nov 2009 16:41:41 -0600
Alex Cruz <elmonogrande@...> wrote:

> For some reason, I am receiving the following error when trying to import my
> states OSM data:
>
> $ ./osm2pgsql -m -d gis wisconsin.osm.bz2
> osm2pgsql SVN version 0.69-18504
>
> Using projection SRS 900913 (Spherical Mercator)
> Setting up table: planet_osm_point
> NOTICE:  table "planet_osm_point" does not exist, skipping
> NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
> SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
>  failed: ERROR:  AddGeometryColumns() - invalid SRID
> CONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 ,
> $5 )"
> PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
>
> Error occurred, cleaning up
>
>
> Any idea what could be causing this? BTW, this is a clean install.
>
> Thanks.
>
> -alex
> _______________________________________________
> GPSdrive mailing list
> GPSdrive@...
> http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive
>

_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

[Bruce Johnson-5]

Alex Cruz wrote:

> For some reason, I am receiving the following error when trying to import my
> states OSM data:
>
> $ ./osm2pgsql -m -d gis wisconsin.osm.bz2
> osm2pgsql SVN version 0.69-18504
>
> Using projection SRS 900913 (Spherical Mercator)
> Setting up table: planet_osm_point
> NOTICE:  table "planet_osm_point" does not exist, skipping
> NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
> SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
>  failed: ERROR:  AddGeometryColumns() - invalid SRID
> CONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 ,
> $5 )"
> PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
>
> Error occurred, cleaning up
>
>
> Any idea what could be causing this? BTW, this is a clean install.
>
> Thanks.
>
> -alex
> _______________________________________________
> GPSdrive mailing list
> GPSdrive@...
> http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive
>  

I found the -m option a poor choice in pre7.  I know the documentation
changes but I recall both "don't use -m" and "use -m" while battling
mapnik.  In my case, -m ate all my system disk so it was easy to choose.

Bruce Johnson

_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

[Alex Cruz-3]

Ross,
Those are the instructions that I followed to get to this point. So, any idea
how to correct the permissions if that's what it truly is?

-alex

On Sunday 08 November 2009, Ross Scanlon wrote:

> Incorrect permissions in the database for you as user.  It's not creating
>  the databases before trying to add the osm data.
>
> Check here:
>
> http://sourceforge.net/apps/mediawiki/gpsdrive/index.php?title=8.04_manual
>
> Under the section on setting up postgreSQL and postGIS
>
>
> Cheers
> Ross
>
>
> On Sun, 8 Nov 2009 16:41:41 -0600
>
> Alex Cruz <elmonogrande@...> wrote:
> > For some reason, I am receiving the following error when trying to import
> > my states OSM data:
> >
> > $ ./osm2pgsql -m -d gis wisconsin.osm.bz2
> > osm2pgsql SVN version 0.69-18504
> >
> > Using projection SRS 900913 (Spherical Mercator)
> > Setting up table: planet_osm_point
> > NOTICE:  table "planet_osm_point" does not exist, skipping
> > NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
> > SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
> >  failed: ERROR:  AddGeometryColumns() - invalid SRID
> > CONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 ,
> > $4 , $5 )"
> > PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
> >
> > Error occurred, cleaning up
> >
> >
> > Any idea what could be causing this? BTW, this is a clean install.
> >
> > Thanks.
> >
> > -alex
> > _______________________________________________
> > GPSdrive mailing list
> > GPSdrive@...
> > http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive
>
> _______________________________________________
> GPSdrive mailing list
> GPSdrive@...
> http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive
>

_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive