Thread: schemas and backups

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

If I just do one table it works fine, and if I want to back up the entire
database as superuser, it works great.

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)?

Thanks to the developers, I really like the new schema/privilege system. It
makes multi-user environments much easier and simpler.

Regards,
    Jeff

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)