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: | Raw Message | Whole Thread | 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? |