Re: pg_wrapper error

On Fri, Oct 26, 2012 at 9:37 AM, Kevin Grittner <kgrittn(at)mail(dot)com> wrote:
> José Pedro Santos wrote:
>
>> When I try to use the command line tool shp2pgsql in the shell I
>> have this error:
>>
>> Error: pg_wrapper: invalid command name
>>
>> I already read some information in the Debian lists but I don't
>> understand the problem/relation with PostgreSQL.
>
> shp2pgsql converts ESRI Shape files into SQL suitable for insertion
> into a PostGIS/PostgreSQL database. You are not using PostgreSQL
> until you take the resulting file and run it against the database
> using some client application, like psql. pg_wrapper is an Ubuntu
> "helper" program that runs a PostgreSQL client program like psql
> after looking up which version to use for the requested database
> cluster.
>
> http://manpages.ubuntu.com/manpages/lucid/man1/shp2pgsql.1.html
>
> http://manpages.ubuntu.com/manpages/lucid/man1/pg_wrapper.1.html
>
> It appears that you don't have pg_wrapper installed, but are trying
> to use it (either directly or by running something which tries to use
> it).
>
> -Kevin

No, pg_wrapper is installed. If it weren't, you would get

pg_wrapper: command not found

The issue is that it seems raster2pgsql and shp2pgsql are not
installed. You cannnot "enable" them by making them each a link to
pg_wrapper.

You might want to bring this back to the PostGIS list, because I think
this is a problem of an incorrect PostGIS installation.

--Lee

--
Lee Hachadoorian
Asst Professor of Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu/