Re: [ADMIN] Databases in memory (-->flashdrive problem)

2002-04-16 Thread Tom Lane
"Nigel J. Andrews" <[EMAIL PROTECTED]> writes: >> Sure: keep the database on a RAM-drive (this will mean an initdb and >> data load on each bootup, hope you can stand that) and use pg_dump to >> a text file on flashdrive as your backup mechanism. Use a cron task >> to run pg_dump at whatever freq

Re: [ADMIN] Databases in memory (-->flashdrive problem)

2002-04-16 Thread Nigel J. Andrews
On Mon, 15 Apr 2002, Tom Lane wrote: > "Christian Gerdes" <[EMAIL PROTECTED]> writes: > > Is there an opportunity to configure postgre to keep databases in Memory? > > I need to store a lot of data (many little entries) on IDE- flashdrive. > > But flashdrives have a little problem with write-cy

Re: [ADMIN] Databases in memory (-->flashdrive problem)

2002-04-15 Thread Tom Lane
"Christian Gerdes" <[EMAIL PROTECTED]> writes: > Is there an opportunity to configure postgre to keep databases in Memory? > I need to store a lot of data (many little entries) on IDE- flashdrive. > But flashdrives have a little problem with write-cycles. > Each flash-cell can be rewritten approx

[ADMIN] Databases in memory (-->flashdrive problem)

2002-04-15 Thread Christian Gerdes
Hi all together, i hope i'm at right list... Is there an opportunity to configure postgre to keep databases in Memory? I need to store a lot of data (many little entries) on IDE- flashdrive. But flashdrives have a little problem with write-cycles. Each flash-cell can be rewritten approxiatly 30