Thread: Batch Files
Hii,
This is vinod DBA in HTC GLOBAL SERVICES ..we have a small issue in running batch files to load data ..I have pasted the script which I am trying to execute it's is constantly failing with an authentication failure
psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_PARTY.dat
psql -U vinodsr vinodsr < C:\MU\BP_CHANGE_HISTORY.dat
psql -U vinodsr vinodsr < C:\MU\BP_CLASS_TYPE.dat
psql -U vinodsr vinodsr < C:\MU\BP_CLASS.dat
psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_CLASS.dat
psql -U vinodsr vinodsr < C:\MU\BP_CURRENCY.dat
psql -U vinodsr vinodsr < C:\MU\BP_DELIVERY_PRIORITY_CODE.dat
psql -U vinodsr vinodsr < C:\MU\BP_DEPENDENCY_TYPE.dat
psql -U vinodsr vinodsr < C:\MU\BP_INCOTERM_CODE.dat
psql -U vinodsr vinodsr < C:\MU\BP_PAYMENT_TERM.dat
psql -U vinodsr v
psql -U vinodsr vinodsr < C:\MU\BP_CHANGE_HISTORY.dat
psql -U vinodsr vinodsr < C:\MU\BP_CLASS_TYPE.dat
psql -U vinodsr vinodsr < C:\MU\BP_CLASS.dat
psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_CLASS.dat
psql -U vinodsr vinodsr < C:\MU\BP_CURRENCY.dat
psql -U vinodsr vinodsr < C:\MU\BP_DELIVERY_PRIORITY_CODE.dat
psql -U vinodsr vinodsr < C:\MU\BP_DEPENDENCY_TYPE.dat
psql -U vinodsr vinodsr < C:\MU\BP_INCOTERM_CODE.dat
psql -U vinodsr vinodsr < C:\MU\BP_PAYMENT_TERM.dat
psql -U vinodsr v
could you plz suggest what the possible cause is ??
Thanks & regards,
vinod
vinod
Thanks & regards,
vinod
vinod
Attachment
Well, what's psql -U vinodsr vinodsr show? You should take a look at http://www.postgresql.org/docs/8.1/interactive/client-authentication.html On Sat, Nov 19, 2005 at 04:36:04PM +0530, vinod.sadanandan@htcindia.com wrote: > BlankHii, > > This is vinod DBA in HTC GLOBAL SERVICES ..we have a small issue in running batch files to load data ..I have pasted thescript which I am trying to execute it's is constantly failing with an authentication failure > psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_PARTY.dat > psql -U vinodsr vinodsr < C:\MU\BP_CHANGE_HISTORY.dat > psql -U vinodsr vinodsr < C:\MU\BP_CLASS_TYPE.dat > psql -U vinodsr vinodsr < C:\MU\BP_CLASS.dat > psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_CLASS.dat > psql -U vinodsr vinodsr < C:\MU\BP_CURRENCY.dat > psql -U vinodsr vinodsr < C:\MU\BP_DELIVERY_PRIORITY_CODE.dat > psql -U vinodsr vinodsr < C:\MU\BP_DEPENDENCY_TYPE.dat > psql -U vinodsr vinodsr < C:\MU\BP_INCOTERM_CODE.dat > psql -U vinodsr vinodsr < C:\MU\BP_PAYMENT_TERM.dat > psql -U vinodsr v > > > could you plz suggest what the possible cause is ?? > Thanks & regards, > > vinod > > > > Thanks & regards, > > vinod > > > > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Vinod, How about a copy/paste of the exact error message? On Sat, 19 Nov 2005, vinod.sadanandan@htcindia.com wrote: > BlankHii, > > This is vinod DBA in HTC GLOBAL SERVICES ..we have a small issue in running batch files to load data ..I have pasted thescript which I am trying to execute it's is constantly failing with an authentication failure > psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_PARTY.dat -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954