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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > 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: [EMAIL PROTECTED] _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
