Re: PostgreSQL capabilities - Mailing list pgsql-general

From Ed Loehr
Subject Re: PostgreSQL capabilities
Date
Msg-id 3935212B.954F0DFB@austin.rr.com
Whole thread Raw
In response to Re: PostgreSQL capabilities  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: PostgreSQL capabilities  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: PostgreSQL capabilities  (Dustin Sallings <dustin@spy.net>)
Re: PostgreSQL capabilities  (Michael Meskes <meskes@postgresql.org>)
List pgsql-general
Alex Pilosov wrote:
>
> > http://networkdna.com/database/index.html mentions that PostgreSQL is
> > capable of "Online backup". What does that exactly mean?
>
> It means Postgres can do a reliable backup (a consistent snapshot) of a
> database without shutting down the database.

Hmmm.  My backup procedure, based on earlier discussions in this group,
involves blocking all write-access during a pg_dump.  That is effectively
shutting down the database from my perspective.  Is there a quicker way
to take a consistent snapshot while still allowing writes?

Regards,
Ed Loehr

pgsql-general by date:

Previous
From: Mihai Gheorghiu
Date:
Subject: Re: PostgreSQL capabilities
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL capabilities