| From: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Is PostgreSQL database write to cooked files? |
| Date: | 2001-04-13 18:05:13 |
| Message-ID: | 3AD73FD9.F93E6645@noaa.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Since PostgreSQL database is write to an UNIX filesystem
in $PGDATA directory It not likes other database such as Sybase,
Informix write to a raw disk.
I am wonder are those files under $PGDATA/data/base/dbname/
directory cooked files?
Can I copy or ftp them to other machine running PostgreSQL without
export/import (pg_dump)?
BTW, Does PostgreSQL support mirror database?
Because I want to have two machine running PostgreSQL.
One use for operational, one use for backup (I mean mirror everything).
Thank you very much!
--
Why we want to teach our babies to talk and walk,
then later we tell them "sit down!", "be quiet!" ?
Democracy is not a better way for a solution,
it is just another way to spread the blames.
--Raymond
| Attachment | Content-Type | Size |
|---|---|---|
| raymond.chui.vcf | text/x-vcard | 414 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin S. | 2001-04-13 18:19:54 | RE: Shared memory failure? |
| Previous Message | Steve Wolfe | 2001-04-13 17:12:42 | Re: Shared memory failure? |