pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedbacking 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