Something can't find the actually directory where your database itself is (the directory that has the pg_hba.conf file and so on).
How you set a ENV var depends on the type of shell you are using. In a cshell for instance: #!/usr/bin/csh # setenv PGDATA /data/postgres/mydb <...> In a kshell: #!/bin/bash export PGDATA=/data/pgsql/bronze <...> The error message is a bit confusing because the only programs I can find with -D being a directory are the pg_ctl process (which starts and stops the database engine and hopefully is not relevant here), postmaster and postgres (a stand alone backend that hopefully is not involved here either). I suspect that the psql process is invoking the postmaster which is then confused by not knowing where to look for the root of the data directories. Greg W. -----Original Message----- From: [EMAIL PROTECTED] on behalf of chris brisendine Sent: Sun 6/1/2008 4:11 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cron / shp2psql 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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
