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@xxxxxxxxxxxx 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 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 > > > could you plz suggest what the possible cause is ?? > Thanks & regards, > > vinod > > > > Thanks & regards, > > vinod > > > > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
