Re: backup: pg_dumpall and full backups in general

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dado Feigenblatt <dado(at)wildbrain(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: backup: pg_dumpall and full backups in general
Date: 2001-11-22 02:08:16
Message-ID: 27561.1006394896@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dado Feigenblatt <dado(at)wildbrain(dot)com> writes:
> [ problems with pg_dumpall and password protection ]

Password protection just doesn't play very nicely with dump scripts.
Especially not scripts you'd like to invoke from cron jobs.
I'd strongly recommend setting up a different authorization method.

One way that's reasonably secure is to run an ident server (non-broken
one of course) and enable ident authorization over local loopback only.
Then a simple "export PGHOST=127.0.0.1" frees you from entering any
more passwords.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-22 02:21:01 Re: Determining which index to create
Previous Message Hiroshi Inoue 2001-11-22 02:00:09 Re: Determining which index to create