Re: About pg_dump

It looks like setting the PGUSER and PGPASSWORD
environment variables does the trick. I don't know
where that is in the documentation (PGUSER is in the
psql man page, but I wasn't able to find PGPASSWORD).

So something like:

PGUSER='postgres'
PGPASSWORD='secret'
export PGUSER PGPASSWORD

pg_dump -h mydatahost mydatabase -t mytable

Seems work just like you would expect.

I hope this is helpful,
Jason

--- Aldo Vadillo Batista <avadillo(at)ulpgc(dot)es> wrote:
> Hi everybody,
>
>
> If you execute "pg_dump -u database", pg_dump
> permits you to specify the user who is making the
> dump. But then, pg_dump waits for you to insert the
> user name and the password.
>
> I want to make automatic scripts to create the
> copies and I have the problem of interactive I/O.
> I am using postgresql 7.1, how can I make the
> copies?
>
> Thanks in advance.
>
> Saludos,
>
> Aldo Vadillo Batista avadillo(at)ulpgc(dot)es
> Subdireccin de Comunicaciones - ULPGC
> Las Palmas de G.C. - Islas Canarias
>
>

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/