| From: | Christopher Weimann <cweimann(at)k12hq(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High Performance/High Reliability File system on SuSE64 |
| Date: | 2004-01-24 01:22:47 |
| Message-ID: | 20040124012247.GA40439@smtp.k12us.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
On 01/23/2004-10:18AM, Joshua D. Drake wrote:
>
> XFS also has the interesting ability (although I have yet to test it)
> that will allow you
> to take a snapshot of the filesystem. Thus you can have filesystem level
> backups
> of the PGDATA directory that are consistent even though the database is
> running.
You can do snapshots in FreeBSD 5.x with UFS2 as well but that (
nor XFS snapshots ) will let you backup with the database server
running. Just because you will get the file exactly as it was at
a particular instant does not mean that the postmaster did not
still have some some data that was not flushed to disk yet.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-01-24 01:26:45 | Re: High Performance/High Reliability File system on SuSE64 |
| Previous Message | Christopher Browne | 2004-01-23 23:30:38 | Re: High Performance/High Reliability File system on SuSE64 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-01-24 01:26:45 | Re: High Performance/High Reliability File system on SuSE64 |
| Previous Message | Tom Lane | 2004-01-24 01:08:10 | Re: help with dual indexing |