What about creating NOW empty schemas 'till 2038?
Your application will move automatically on the new empty schema on the new
year without any changes to the db structure.
On 4/26/07, Owen Hartnett <[EMAIL PROTECTED]> wrote:
At 9:23 AM +0100 4/26/07, Richard Huxton wrote:
>Jonathan Vanasco wrot
On Apr 25, 2007, at 2:05 PM, Richard Huxton wrote:
Owen Hartnett wrote:
I want to "freeze" a snapshot of the database every year (think of
end of year tax records). However, I want this frozen version
(and all the previous frozen versions) available to the database
user as read-only. My
At 9:23 AM +0100 4/26/07, Richard Huxton wrote:
Jonathan Vanasco wrote:
On Apr 25, 2007, at 2:05 PM, Richard Huxton wrote:
Owen Hartnett wrote:
I want to "freeze" a snapshot of the database every year (think
of end of year tax records). However, I want this frozen version
(and all the prev
Jonathan Vanasco wrote:
On Apr 25, 2007, at 2:05 PM, Richard Huxton wrote:
Owen Hartnett wrote:
I want to "freeze" a snapshot of the database every year (think of
end of year tax records). However, I want this frozen version (and
all the previous frozen versions) available to the database u
Owen Hartnett wrote:
>
> Hi:
>
> I'm a new user of Postgresql (8.2.3), and I'm very happy with both the
> performance and operation of the system. My compliments to you the many
> authors who keep this database running and useful.
>
> My question is:
>
> I want to "freeze" a snapshot of the da
On Wed, 2007-04-25 at 12:47 -0400, Owen Hartnett wrote:
> I want to "freeze" a snapshot of the database every year (think of
> end of year tax records). However, I want this frozen version (and
> all the previous frozen versions) available to the database user as
> read-only.
First, I'd renam
Owen Hartnett wrote:
I want to "freeze" a snapshot of the database every year (think of end
of year tax records). However, I want this frozen version (and all the
previous frozen versions) available to the database user as read-only.
My thinking is to copy the entire public schema (which is w
