From: | brad <brad(at)kieser(dot)net> |
---|---|
To: | Jeff MacDonald <jeff(at)pgsql(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: doing backups |
Date: | 2000-03-31 19:42:51 |
Message-ID: | 38E4FFBB.B1478CE3@kieser.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
NO!!!!
You don't want to give ANY account root access or root level security!
I run my backups FROM root using cron, but root can su to any account
that it likes!
I have some ksh code tucked away that will be easy to convert to bash
that will run commands as a particular user and will check their return
codes, etc.
In fact, I would be very interested in co-developing a solution provided
that it would be OpenSourced as, at the the moment, we have backup
script that do pg_dumps from the individual user accts.
Another thing to consider is backing up the directories that the
database are stored in.
For that matter, I am currently thinking a lot about fail-over between
more than one server at a database level (yes, that dreaded database
replication!!!!).
This would seem an essential next step for PostgreSQL and would
certainly throw it into a very much bigger league!
Bradley Kieser
Director
Kieser.net
Jeff MacDonald wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | brad | 2000-03-31 19:45:08 | Re: clutering/mirroring in Postgresql |
Previous Message | Ken Causey | 2000-03-31 19:39:06 | Re: [INTERFACES] Problem with Large Object Interface of pgsql_perl5 |