Re: patterns for database administration

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: hixson(at)poindextrose(dot)org (Matthew Hixson)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: patterns for database administration
Date: 2004-03-23 18:53:21
Message-ID: 200403231853.i2NIrMvU017870@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Has anyone ever heard of using a separate administration database
> which is used to modify business data, and then periodically that data
> would be pushed out to the other database running the customer web
> application? Does this idea make any sense at all?

This sounds like a task for separate schemas rather than for two
separate databases. The advantage of the former is that you can
move data between the two in SQL fairly easily, moving data between
two independent databases is (currently) more challenging.
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-03-23 19:04:15 Re: linked list rewrite
Previous Message Chris Boget 2004-03-23 18:35:38 Re: patterns for database administration