Re: Multiple databases one directory

Noah,

> Would there be an advantage to putting each of the two databases into a
> separate directory and starting two instances of postgres?  Is it
> better to just lump everything together.

You can use the WITH LOCATION option in CREATE DATABASE to put the two
databases into seperate directories *without* running two instances of
postgres.

For that matter, the databases each have their own directories, by OID number.

Of course, this only helps you if the seperate directories are on seperate
disks/arrays/channels.  If everying is on the same disk or array, don't
bother.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco