Re: About pg_dump

On Thu, 28 Jun 2001, Jason Earl wrote:

>
> 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.
>

or run a shell script:

pg_dump -u -h lalahost -t lalatab laladb <<EOF
user_name_here
password_here
EOF

and chmod the script accordingly

cheers,
thalis

> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>