[postgis-users] Problem in using Postgis 2.0.0b3 with raster

[Mathieu Basille]

Well, I didn't check for most recent versions of PostGIS, but, as far as I 
can remember, I had to do it for postgis-2.0.0SVN-rev6066-20101013...

You can still use the absolute path as well, I just find it more convenient 
to symlink these commands so that they work exactly as other shell commands.

Mathieu.


Le 09/03/2012 10:39, Pierre Racine a écrit :
> Is this something you have to do to make shp2pgsql as well or it is only necessary for raster2pgsql?
>
> Pierre
>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>> bounces at postgis.refractions.net] On Behalf Of Mathieu Basille
>> Sent: Friday, March 09, 2012 8:49 AM
>> To: postgis-users at postgis.refractions.net
>> Subject: Re: [postgis-users] Problem in using Postgis 2.0.0b3 with raster
>>
>> Here is a possibility (which is what I do):
>>
>> 1) for the sake of convenience, create symlinks in /usr/local/bin/ as a root:
>>
>> # ln -s /usr/lib/postgresql/8.4/bin/shp2pgsql /usr/local/bin/shp2pgsql # ln -s
>> /usr/lib/postgresql/8.4/bin/raster2pgsql /usr/local/bin/raster2pgsql # ln -s
>> /usr/lib/postgresql/8.4/bin/pgsql2shp /usr/local/bin/pgsql2shp
>>
>> It will allow you to call the 3 commands from any folder.
>>
>> 2) Create a new data base user, as postgres root:
>>
>> # su postgres
>> # psql -d template1 -c "ALTER USER dbuser WITH PASSWORD 'dbpwd'"
>>
>> 3) If you want to be able to use the db without the need to type passwords (very
>> handy to script things), you can create a file .pgpass in your home, with just this
>> line:
>>
>> localhost:5432:*:dbuser:dbpwd
>>
>> And then give it the minimum permissions:
>>
>> chmod 600 .pgpass
>>
>> 4) Now test the connection, from any user:
>>
>> psql -h localhost -d yourdb -U dbuser -c 'SELECT current_date;'
>>
>> This should work! If you don't want to use step 3 (no password), just add a -W in
>> the command, if I'm not mistaken.
>>
>> Hope this helps,
>> Mathieu.
>>
>>
>> Le 09/03/2012 08:34, aperi2007 a écrit :
>>>   >Yes, raster2pgsql is in this folder. So i go through the terminal to
>>>> this folder and run something like that: raster2pgsql -s 4236 -I -C
>>> -M>*.tif -F -t 100x100 public.test>  out.sql>   >Before that, i go
>>> to the pgAdminIII, connect to the localhost and>create a new database
>>> "testing" with template "template_postgis".
>>>   >
>>>   >
>>>   >How do i declare in the command line that the database that i want
>>> to>load the image is the new one i just created?
>>>   >
>>>   >What i get running the command below is: "out.sql: Permission denied".
>>>   >
>>>   >What is wrong with this process or what i forget to do?
>>>
>>> I will have the same trouble.
>>> After same tests I found that the creation and load of postgis rasters
>>> work only with the "postgres" account.
>>>
>>> Otherwise it return me the same your "permission denied".
>>>
>>> Andrea.
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>> --
>>
>> ~$ whoami
>> Mathieu Basille, Post-Doc
>>
>> ~$ locate
>> Laboratoire d'Écologie Comportementale et de Conservation de la Faune
>> + Centre d'Étude de la Forêt
>> Département de Biologie
>> Université Laval, Québec
>>
>> ~$ info
>> http://ase-research.org/basille
>>
>> ~$ fortune
>> ``If you can't win by reason, go for volume.''
>> Calvin, by Bill Watterson.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

~$ whoami
Mathieu Basille, Post-Doc

~$ locate
Laboratoire d'Écologie Comportementale et de Conservation de la Faune
+ Centre d'Étude de la Forêt
Département de Biologie
Université Laval, Québec

~$ info
http://ase-research.org/basille

~$ fortune
``If you can't win by reason, go for volume.''
Calvin, by Bill Watterson.