Is PostgreSQL database write to cooked files?

Started by Raymond Chuiabout 25 years ago2 messagesgeneral
Jump to latest
#1Raymond Chui
raymond.chui@noaa.gov

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Raymond Chui (#1)
Re: Is PostgreSQL database write to cooked files?

Raymond Chui writes:

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)?

No.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/