On Fri, Jul 10, 2009 at 11:17 PM, Janet Jacobsen<jsjacobsen@xxxxxxx> wrote: > Is it possible to create a database cluster on a machine that > has write access to the shared file system, shut down the > Postgres server on that machine, and then start up the > Postgres server on the machine that cannot write to the > shared file system, and thereafter, *only query* the database. Postgres isn't really designed to work this way. It expects to have write access and will occasionally still write stuff to disk even for read-only queries. It won't work even a little bit before 8.3. For 8.3 or later you could maybe make it work using vacuum freeze but there's no facility to verify that it's really frozen everything and you'll still be taken by surprise by queries which try to use temporary space for large sorts or commands which start transactions that you didn't realize were necessary. -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
