Re: pg_dump question - Mailing list pgsql-admin

From Bhuvan A
Subject Re: pg_dump question
Date
Msg-id Pine.LNX.4.44.0210291003310.1252-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to pg_dump question  ("Tom Haddon" <tom@haddons.net>)
List pgsql-admin
> I need to set up a daily cron job that performs a pg_dump on a remote
> database. I can't figure out how to pass a password to it. How do I do
> this. Everything I've tried still comes up with asking me for a password
> when I test it.
>

$ export PGPASSWORD=user_pass
$ echo -e "Would do the trick. Yes, it will not ask for the password
again";

regards,
bhuvaneswaran



pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: views across databases
Next
From: Nick Sayer
Date:
Subject: pg_upgrade problems