Re: "Hot Backups" - Mailing list pgsql-novice

From Travis Hoyt
Subject Re: "Hot Backups"
Date
Msg-id DBEMKMGOMJAGKAKEPPEGCEFNCPAA.thoyt@npc.net
Whole thread Raw
In response to Re: "Hot Backups"  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
I think the question is will the data dumped be reliable.  Are there
sufficient database locking mechanisms that will prevent tables that are
being dumped from changing during the dump itself.

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Josh Berkus
Sent: Monday, February 11, 2002 2:38 PM
To: Pam Wampler; pgsql-novice@postgresql.org
Subject: Re: [NOVICE] "Hot Backups"


Pam,

> I am new to postgresql -- coming from Oracle --
> Is there an equivalent "Hot" Backup in postgresql --
> or is the only backup utility available  pg_dump & pg_dumpall.
> thanks

pg_dump and pg_dumpall may be run while the database is in use without
 difficulty.  Is this what you mean by "hot" backup?

-Josh

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Attachment

pgsql-novice by date:

Previous
From: Pam Wampler
Date:
Subject: Re: "Hot Backups"
Next
From: "Josh Berkus"
Date:
Subject: Re: "Hot Backups"