Re: backing up without lock ? - Mailing list pgsql-admin

From Martin Fandel
Subject Re: backing up without lock ?
Date
Msg-id 1121779422.4482.54.camel@fandelm.ecommit.de
Whole thread Raw
In response to backing up without lock ?  (FM <dist-list@LEXUM.UMontreal.CA>)
List 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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


pgsql-admin by date:

Previous
From: Chris Travers
Date:
Subject: Re: caching table/query
Next
From: Stef
Date:
Subject: Re: HELP