Re: PostgreSQL capabilities

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Alex Pilosov <alex(at)pilosoft(dot)com>
Cc: Mihai Gheorghiu <tanhq(at)bigplanet(dot)com>, pgsql-general(at)hub(dot)org
Subject: Re: PostgreSQL capabilities
Date: 2000-05-31 14:26:51
Message-ID: 3935212B.954F0DFB@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-05-31 14:36:07 Re: PostgreSQL capabilities
Previous Message Mihai Gheorghiu 2000-05-31 13:20:13 Re: PostgreSQL capabilities