doing backups

From: Jeff MacDonald <jeff(at)pgsql(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: doing backups
Date: 2000-03-31 04:44:45
Message-ID: Pine.BSF.4.10.10003310033230.13120-100000@rage.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pgsql(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-03-31 05:15:06 PostgreSQL book completed though chapter 10
Previous Message "Sean Carmody" 2000-03-30 23:00:50 approve Mtzvb7 subscribe general