pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
backing up without lock ?
5+ messages / 4 participants
[nested] [flat]

* backing up without lock ?
@ 2005-07-18 17:25 FM <dist-list@LEXUM.UMontreal.CA>
  2005-07-18 17:51 ` Re: backing up without lock ? Scott Marlowe <smarlowe@g2switchworks.com>
  2005-07-19 13:23 ` Re: backing up without lock ? Martin Fandel <martin.fandel@alphyra-evs.de>
  2005-07-20 09:24 ` Re: backing up without lock ? Dawid Kuroczko <qnex42@gmail.com>
  0 siblings, 3 replies; 5+ messages in thread

From: FM @ 2005-07-18 17:25 UTC (permalink / raw)
  To: pgsql-admin

Hello,
Is it possible to backup postgresql databases  without locking tables.

Thanks



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: backing up without lock ?
  2005-07-18 17:25 backing up without lock ? FM <dist-list@LEXUM.UMontreal.CA>
@ 2005-07-18 17:51 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2005-07-18 17:58   ` Re: backing up without lock ? Scott Marlowe <smarlowe@g2switchworks.com>
  2 siblings, 1 reply; 5+ messages in thread

From: Scott Marlowe @ 2005-07-18 17:51 UTC (permalink / raw)
  To: FM <dist-list@lexum.umontreal.ca>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: backing up without lock ?
  2005-07-18 17:25 backing up without lock ? FM <dist-list@LEXUM.UMontreal.CA>
  2005-07-18 17:51 ` Re: backing up without lock ? Scott Marlowe <smarlowe@g2switchworks.com>
@ 2005-07-18 17:58   ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Scott Marlowe @ 2005-07-18 17:58 UTC (permalink / raw)
  To: FM <dist-list@lexum.umontreal.ca>; +Cc: pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: backing up without lock ?
  2005-07-18 17:25 backing up without lock ? FM <dist-list@LEXUM.UMontreal.CA>
@ 2005-07-19 13:23 ` Martin Fandel <martin.fandel@alphyra-evs.de>
  2 siblings, 0 replies; 5+ messages in thread

From: Martin Fandel @ 2005-07-19 13:23 UTC (permalink / raw)
  To: FM <dist-list@LEXUM.UMontreal.CA>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: backing up without lock ?
  2005-07-18 17:25 backing up without lock ? FM <dist-list@LEXUM.UMontreal.CA>
@ 2005-07-20 09:24 ` Dawid Kuroczko <qnex42@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Dawid Kuroczko @ 2005-07-20 09:24 UTC (permalink / raw)
  To: FM <dist-list@lexum.umontreal.ca>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2005-07-20 09:24 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-18 17:25 backing up without lock ? FM <dist-list@LEXUM.UMontreal.CA>
2005-07-18 17:51 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-07-18 17:58   ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-07-19 13:23 ` Martin Fandel <martin.fandel@alphyra-evs.de>
2005-07-20 09:24 ` Dawid Kuroczko <qnex42@gmail.com>

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