From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
---|---|
To: | Jason Earl <jdearl(at)yahoo(dot)com> |
Cc: | Aldo Vadillo Batista <avadillo(at)ulpgc(dot)es>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: About pg_dump |
Date: | 2001-06-28 19:57:25 |
Message-ID: | Pine.LNX.4.21.0106281551490.32402-100000@aluminum.cs.pitt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2001-06-28 20:20:54 | Linux Software RAID 1 Performance (was:Re: Re: Slower on Solaris) |
Previous Message | Jason Earl | 2001-06-28 19:44:01 | Re: About pg_dump |