From: Saravanan Krishnan <saravani20@...>
Date: 2009-03-17T21:24:32+09:00
Subject: Re: PostgreSQL Dump

Saravanan Krishnan wrote:
> Hi all,
> 
> I'm using  following command to take dump from my sql database.
> 
> pg_dump -h localhost -U postgres dbname > dump.sql
> 
> Whenever i trying to run this command in command prompt, it always
> asking password.
> 
> Here my query is,
> 
> if i write this command in a separate ruby file how can i give password
> in that command.
> 
> in my sql, we  can use
> mysqldump -h #{host} -u #{user} -p#{pwd} dbname > dump.sql
> if use like that it wont ask password anymore. but how is it possible in
> postgres.
> 
> 
> Thanks in Advance
> Saravanan K


Hi folks,,

I fixed that issue thanks
refered link 
http://www.postgresql.org/docs/8.1/static/libpq-pgpass.html

Thanks
-- 
Posted via http://www.ruby-forum.com/.