Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
PostgreSQL Dump
Saravanan Krishnan
3/17/2009 11:34:00 AM
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
--
Posted via
http://www.ruby-...
.
1 Answer
Saravanan Krishnan
3/17/2009 12:25:00 PM
0
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-p...
Thanks
--
Posted via
http://www.ruby-...
.
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
PostgreSQL Dump
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password