Dan Langille wrote:
> John Drescher wrote:
>
>> On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille wrote:
>>
>>> Eduardo J. Ortega U. wrote:
>>>
Hi, all:
I am considering bacula for backing up a server whose primary role is
PostgreSQL. My question is, is bacula appropr
Eduardo J. Ortega U. wrote:
> Thanks to all for your suggestions, I'll take a look at LVM snapshots
> and PITR, which seem pretty good options.
I do not recommend snapshots. The database is not guaranteed to be in a
proper state. PITR ensure that. I am not a fan of snapshots for
database backu
John Drescher wrote:
> On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille wrote:
>> Eduardo J. Ortega U. wrote:
>>> Hi, all:
>>>
>>> I am considering bacula for backing up a server whose primary role is
>>> PostgreSQL. My question is, is bacula appropriate for taking online
>>> postgres backups (conside
Note that for LVM snapshots you need to stop PostgreSQL before
On Sat, 2009-01-03 at 14:36 -0500, Eduardo J. Ortega U. wrote:
> Thanks to all for your suggestions, I'll take a look at LVM snapshots
> and PITR, which seem pretty good options.
>
>
On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille wrote:
> Eduardo J. Ortega U. wrote:
>> Hi, all:
>>
>> I am considering bacula for backing up a server whose primary role is
>> PostgreSQL. My question is, is bacula appropriate for taking online
>> postgres backups (considering that a filesystem backup
Thanks to all for your suggestions, I'll take a look at LVM snapshots
and PITR, which seem pretty good options.
--
Eduardo J. Ortega U.
--
___
Bacula-users mailing list
Bacula
Eduardo J. Ortega U. wrote:
> Hi, all:
>
> I am considering bacula for backing up a server whose primary role is
> PostgreSQL. My question is, is bacula appropriate for taking online
> postgres backups (considering that a filesystem backup when the
> database is running is a badf solution) ?
Look
On Sat, Jan 3, 2009 at 2:15 PM, Eduardo J. Ortega U.
wrote:
>> Is it possible to dump the database using pgdump? Or would that take too
>> long?
>
> It takes a long time, and kills my disks I/O, causing database
> performance issues... are there any other choices?
>
LVM snapshot
http://tldp.org/
Hi:
> it can be as simple as backing up postgres dump files, but this may be of
> help:
I'd rather not take pg_dumps, as the DB is fairly large and the dumps
take long and kill disk I/O, hurting performance.
>
> http://wiki.bacula.org/doku.php?id=application_specific_backups:postgresql
>
>> --
> Is it possible to dump the database using pgdump? Or would that take too long?
It takes a long time, and kills my disks I/O, causing database
performance issues... are there any other choices?
>
> John
>
--
Eduardo J. Ortega U.
--
On Sat, Jan 3, 2009 at 1:56 PM, Eduardo J. Ortega U.
wrote:
> Hi, all:
>
> I am considering bacula for backing up a server whose primary role is
> PostgreSQL. My question is, is bacula appropriate for taking online
> postgres backups (considering that a filesystem backup when the
> database is run
On Sat, Jan 03, 2009 at 01:56:49PM -0500, Eduardo J. Ortega U. wrote:
> Hi, all:
>
> I am considering bacula for backing up a server whose primary role is
> PostgreSQL. My question is, is bacula appropriate for taking online
> postgres backups (considering that a filesystem backup when the
> datab
Hi, all:
I am considering bacula for backing up a server whose primary role is
PostgreSQL. My question is, is bacula appropriate for taking online
postgres backups (considering that a filesystem backup when the
database is running is a badf solution) ?
Thanks,
--
Eduardo J. Ortega U.
-
13 matches
Mail list logo
