Thread: backing up without lock ?

backing up without lock ?

From
FM
Date:
Hello,
Is it possible to backup postgresql databases  without locking tables.

Thanks

Re: backing up without lock ?

From
Scott Marlowe
Date:
On Mon, 2005-07-18 at 12:25, FM wrote:
> Hello,
> Is it possible to backup postgresql databases  without locking tables.

Yes and no.

No, it's actually possible to backup postgresql without a lock.

However, it's an access shared lock, so it's not a blocking lock.

Also, the backup is coherent for a whole database at the point in time
the backup was initiated.

http://www.postgresql.org/docs/8.0/static/app-pgdump.html

Re: backing up without lock ?

From
Scott Marlowe
Date:
On Mon, 2005-07-18 at 12:51, Scott Marlowe wrote:
> On Mon, 2005-07-18 at 12:25, FM wrote:
> > Hello,
> > Is it possible to backup postgresql databases  without locking tables.
>
> Yes and no.
>
> No, it's actually possible to backup postgresql without a lock.

That should be NOT POSSIBLE (with pg_dump)...

sigh, I need an editor.


Re: backing up without lock ?

From
"Martin Fandel"
Date:
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


Re: backing up without lock ?

From
Dawid Kuroczko
Date:
On 7/18/05, FM <dist-list@lexum.umontreal.ca> wrote:
> Hello,
> Is it possible to backup postgresql databases  without locking tables.

You mean, like:

http://www.postgresql.org/docs/current/static/backup-online.html

Or do you need a "dump" of database (then use pg_dumpall).

   Regards,
       Dawid

Re: backing up without lock ?

From
"Martin Fandel"
Date:
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