[postgis-users] Cron / shp2psql

[chris brisendine]

my mail log is giving me this"
postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the
PGDATA environment variable.
how would i add the path or the variable.


On Sun, Jun 1, 2008 at 5:53 PM, Gregory Williamson
<Gregory.Williamson at digitalglobe.com> wrote:
> In the cron job you may not have the environment (in particular PATH) set;
> try adding an explicit paths to all file and executable references. ?
>
> HTH,
>
> Greg Williamson
> Senior DBA
> DigitalGlobe
>
> Confidentiality Notice: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information and must be protected in accordance with those
> provisions. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the sender
> by reply e-mail and destroy all copies of the original message.
>
> (My corporate masters made me say this.)
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net on behalf of Dan
> Blomberg
> Sent: Sun 6/1/2008 3:20 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Cron / shp2psql
>
> On this note, I thought I had fixed my problem but it doesn't work
> either.  I can even run it as a bat but I can't call the bat in visual
> basic or just run the command that is in the bat file.
>
> chris brisendine wrote:
>> I have cron running a shell script "
>> shp2pgsql -d -s 4326 /home/storm/ww/TOR.shp torpoly wxsvr>torpoly.sql
>> sleep 7
>> shp2pgsql -d -s 4326 /home/storm/ww/SVR.shp svrpoly wxsvr| psql -d  wxsvr
>> echo `date`>updated.txt
>> "
>> When i run this from the command line it works flawless but when cron
>> runs it it dosent update my nwswarnings! Any idea's?
>> I know the new warnings are being downloaded and the the script is
>> running cause it writes to the updated.txt file when it runs.
>> I have tryed it two different ways but no luck...
>>
> _______________________________________________
> 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
>
>



-- 
Thanks,
Chris Brisendine
Henry Co. EMA - Operations and Information Systems.
Home: 731.642.7103
Cell: 731.363.3430
Email: ki4gyw at gmail.com