On 11/7/07, Gauthier, Dave <dave.gauthier@intel.com> wrote:
>
> This is a real longshot, but here goes...
>
> Is there such a thing as a temporary, probably in-memory, version of a
> Postgres DB? Sort of like SQLite, only with the features/function of PG? A
> DB like this would exist inside of, and for the duration of, a
> script/program that created it, then vanish when the script/program ends.
Mount a ramdisk, initdb there, run db from there.
Conversely, create the db normally, mount a ram disk, create a
tablespace there, create a db and it's tables there.
The second method might not be optimal because if you don't cleanly
remove the db / tablespace postgresql might have some issues starting
up after a reboot.