[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] doing backups
From:       brad <brad () kieser ! net>
Date:       2000-03-31 19:42:51
[Download RAW message or body]

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@pgsql.com

[prev in list] [next in list] [prev in thread] [next in thread]