[EMAIL PROTECTED] writes:
> Tom Lane suggested a vacuum freeze (? or something like that) for archival
> read only data. I got the impression the template databases are freeze
> dried for freshness (good to the last bit?) That feature might help as
> well in the transition from read-write to read
I know it would be a hard approach but... perhaps ON DELETE and ON UPDATE triggers would help?
On 5/11/05, Jay A. Kreibich <[EMAIL PROTECTED]> wrote:
On Wed, May 11, 2005 at 03:51:43PM -0400, [EMAIL PROTECTED] scratched on the wall:
> I would like to clarify something.> I intend to create the datab
11, 2005 3:41 PM
> To: Goshen, Galit
> Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org;
> pgsql-admin@postgresql.org
> Subject: Re: [GENERAL] Storing database in WORM devices
>
> I think simply initialising the system causes writes in the system
> tables and the WAL...
>
> I
On Wed, May 11, 2005 at 03:51:43PM -0400, [EMAIL PROTECTED] scratched on the
wall:
> I would like to clarify something.
> I intend to create the database on a re-writable device (not WORM).
> At some point, when I no longer want to add/modify the database, I
> plan to copy it to the WORM device. T
; From: Alex Turner [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 11, 2005 3:41 PM
> To: Goshen, Galit
> Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org;
> pgsql-admin@postgresql.org
> Subject: Re: [GENERAL] Storing database in WORM devices
>
> I think simply initialisin
PM
To: Goshen, Galit
Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org;
pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Storing database in WORM devices
I think simply initialising the system causes writes in the system
tables and the WAL...
I'm sure someone more knowledgeable can chi
>
> -Original Message-
> From: Douglas McNaught [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 11, 2005 2:51 PM
> To: Goshen, Galit
> Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.org
> Subject: Re: [GENERAL] Storing database in WORM devices
>
>
> &l
in@postgresql.org
> Subject: Re: [GENERAL] Storing database in WORM devices
>
> <[EMAIL PROTECTED]> writes:
>
> > I would like to store the complete database into a WORM device (Write Once
> > Read Many). I would like to access this database directly from the W
@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Storing database in WORM devices
<[EMAIL PROTECTED]> writes:
> I would like to store the complete database into a WORM device (Write Once
> Read Many). I would like to access this database directly from the WORM
> device a
<[EMAIL PROTECTED]> writes:
> I would like to store the complete database into a WORM device (Write Once
> Read Many). I would like to access this database directly from the WORM
> device and perform read only SQL statements against this device.
>
> Does anyone have such installation, or can det
I would like to store the
complete database into a WORM device (Write Once Read Many). I would like to
access this database directly from the WORM device and perform read only SQL
statements against this device.
Does anyone have such
installation, or can determine if this is possible?
Ga
11 matches
Mail list logo