Re: Temporary, In-memory Postgres DB?

On 11/7/07, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)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.