Re: Backing up postgresql databases - Mailing list pgsql-admin

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: Backing up postgresql databases
Date
Msg-id slrn9bcbb1.27o.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to Backing up postgresql databases  ("Peter Schuller" <peter.schuller@infidyne.com>)
List pgsql-admin
Peter Schuller <peter.schuller@infidyne.com> wrote:
>Contrary to Grant, I can't use a trust policy, even on the local machine.
>As a result, I need to use password authentication. However, pg_dumpall
>seems to generally screw up.

>Is there something obvious I'm doing wrong?

No. pg_dumpall wasn't written with password authentication in mind. You can
find a patched pg_dumpall that supports password authentication at
    http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=87035&repeatmerged=yes

HTH,
Ray
--
Do Microsoft's TCO calculations include TC of downtime?

pgsql-admin by date:

Previous
From: Robert Hentosh
Date:
Subject: Re: Postgres/Postmaster logging and log rotation
Next
From: joydip@cal2.vsnl.net.in
Date:
Subject: Re: Re: cannot create new user in postgres