doing backups - Mailing list pgsql-general

From Jeff MacDonald
Subject doing backups
Date
Msg-id Pine.BSF.4.10.10003310033230.13120-100000@rage.hub.org
Whole thread Raw
Responses Re: doing backups
List pgsql-general
hi folks,

I'm writing out a nightly backup script for a machine.
This machine has many databases, running on different ports.
ie: 5432,5433 etc..

These servers are ""owned"" (use term loosly) by users on the
system, and some users have choses to set passwds. which is
100% within their right.

However that makes it a pain for postgres to do pg_dumps.

Now if you make pgsql user and postgresql analgous to
root and unix, the postgres user shouldn't need a passwd.

anyone care to discuss this topic ?

Jeff MacDonald
jeff@pgsql.com


pgsql-general by date:

Previous
From: sean@categoricalsolutions.com.au ("Sean Carmody")
Date:
Subject: approve Mtzvb7 subscribe general
Next
From: Bruce Momjian
Date:
Subject: PostgreSQL book completed though chapter 10