Thread: Batch Files

Batch Files

From
Date:
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
 
 
 could you plz suggest what the possible cause is ??
Thanks & regards,
 
vinod
 

 
Thanks & regards,
 
vinod
 

 

 

Attachment

Re: Batch Files

From
"Jim C. Nasby"
Date:
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

Re: Batch Files

From
Jeff Frost
Date:
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