On 11/7/07, Gauthier, Dave <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
