| From: | "Travis Hoyt" <thoyt(at)npc(dot)net> |
|---|---|
| To: | "Josh Berkus" <josh(at)agliodbs(dot)com>, "Pam Wampler" <Pam_Wampler(at)taylorwhite(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: "Hot Backups" |
| Date: | 2002-02-11 20:10:35 |
| Message-ID: | DBEMKMGOMJAGKAKEPPEGCEFNCPAA.thoyt@npc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Josh Berkus
Sent: Monday, February 11, 2002 2:38 PM
To: Pam Wampler; pgsql-novice(at)postgresql(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-02-11 20:19:53 | Re: "Hot Backups" |
| Previous Message | Pam Wampler | 2002-02-11 19:51:21 | Re: "Hot Backups" |