Re: schemas and backups - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: schemas and backups
Date
Msg-id 20021204060037.GA20173@dcc.uchile.cl
Whole thread Raw
In response to schemas and backups  (Jeff Davis <list-pgsql-general@empires.org>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: schemas and backups
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Postgresql -- initial impressions and comments