From: Joshua Kramer <josh@globalherald.net>
To: Shoaib Mir <shoaibmir@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Backup Strategies?
Date: Mon, 5 Feb 2007 15:18:00 -0500 (EST)
Message-ID: <Pine.LNX.4.64.0702051514520.1342@localhost.localdomain> (raw)
In-Reply-To: <bf54be870702030018s74b1e916yb0787dd8f91f940d@mail.gmail.com>
References: <Pine.LNX.4.64.0702030141110.1342@localhost.localdomain>
<bf54be870702030018s74b1e916yb0787dd8f91f940d@mail.gmail.com>
Thanks for the hint, Shoaib. My question - and I should have phrased this
more carefully - related to the security of the various backup tactics.
Is it more secure to have a "backup user" with read permissions on all
databases, or is it more secure to have a dedicated Unix backup user -
with the .pgpass file in the home directory and all. If someone can, by
way of cracking, get in to the account of the backup Unix user, then the
postgres user's database account is also surrendered. If I have a
Postgres backup user (with read only permissions on all DB's), then even
if someone got into the unix account of the backup user, all they could do
is read DB data (versus delete or write over stuff).
Essentially it's the diffrenece between being *really* secure and *really
really* secure.
On Sat, 3 Feb 2007, Shoaib Mir wrote:
> A cron job can always do the job using pg_dump/pg_dumpall, in case you need
> the incremental backup you can opt for PITR WAL based archive logs...
>
> --
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 2/3/07, Joshua Kramer <josh@globalherald.net> wrote:
>>
>>
>> Hello All,
>>
>> What strategies are people using for automated, script-based backup of
>> databases? There are a few I can think of:
>>
>> 1. Create a "db_backup" unix user and a "db_backup" pgsql user. Grant
>> READ access to all objects on all databases for the "db_backup" pgsql
>> user. Create a .pgpass file in the home directory of the "db_backup" unix
>> user. Backup as needed with a script run as the "db_backup" unix user.
>>
>> 2. Create a "db_backup" unix user and repeat above, except using the
>> "postgres" db user.
>>
>> Thanks,
>> -Josh
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: josh@globalherald.net, shoaibmir@gmail.com
Subject: Re: Backup Strategies?
In-Reply-To: <Pine.LNX.4.64.0702051514520.1342@localhost.localdomain>
References: <Pine.LNX.4.64.0702030141110.1342@localhost.localdomain> <bf54be870702030018s74b1e916yb0787dd8f91f940d@mail.gmail.com> <Pine.LNX.4.64.0702051514520.1342@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox