Skip site navigation (1) Skip section navigation (2)

Re: backing up without lock ?

From: "Martin Fandel" <martin(dot)fandel(at)alphyra-evs(dot)de>
To: FM <dist-list(at)LEXUM(dot)UMontreal(dot)CA>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: backing up without lock ?
Date: 2005-07-19 13:23:42
Message-ID: 1121779422.4482.54.camel@fandelm.ecommit.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

do you need an fs-backup or only dumps? You can Backup with Dumps and
archived WAL's by using pg_dump + pg_start/stop_backuo().

If you need a fs-backup, maybe xfs_freeze with syncing the
complete database (including WAL's) is a solution.

Best regards,

Martin


 Am Montag, den 18.07.2005, 13:25 -0400 schrieb FM:
> Hello,
> Is it possible to backup postgresql databases  without locking tables.
> 
> Thanks
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


In response to

pgsql-admin by date

Next:From: Shashi Kanth BoddulaDate: 2005-07-19 13:32:06
Subject: Mirroring problem with PostgreSQL
Previous:From: Ilja GolshteinDate: 2005-07-19 12:19:58
Subject: Re: Old question - failed to find conversion function from "unknown"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group