Skip site navigation (1) Skip section navigation (2)

Re: Backing up postgresql databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Schuller" <peter(dot)schuller(at)infidyne(dot)com>
Cc: John W Cunningham <john(at)pickaprof(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up postgresql databases
Date: 2001-03-19 16:03:56
Message-ID: 19641.985017836@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Peter Schuller" <peter(dot)schuller(at)infidyne(dot)com> writes:
> I do have a question though. 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.

pg_dumpall is very unfriendly to password auth method :-(.  Even if it
worked better, would you really want to keep a password stored in a cron
script?

Consider using IDENT authentication on local TCP connections and having
the dumper connect to 127.0.0.1 instead of via Unix socket.  IDENT is
not real secure for remote connections but I don't see why you shouldn't
trust it for local.

Kerberos auth might be another answer, but I don't know enough about it
to comment intelligently.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Tim FrankDate: 2001-03-20 00:14:11
Subject: Re: Backing up postgresql databases
Previous:From: J.H.M. Dassen RayDate: 2001-03-19 16:03:23
Subject: Re: Backing up postgresql databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group