Re: schemas and backups

On Tue, Dec 03, 2002 at 09:54:20PM -0800, Jeff Davis wrote:

> Is there an easy way in 7.3 for a user to back up all of the structure and
> data in his/her schema?

Not now.

> Also, I've always been a little confused about pg_dump: how are you supposed
> to supply passwords to it in a non-interactive way (such as through a weekly
> backup script)?

You can use the ~/.pgpass file, described in
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/libpq-files.html
or the PGPASSWORD environment variable.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como llamas, ¡Prueba una hija de Caladan! (Gurney Halleck)