sm-grimoire AT lists.ibiblio.org
Subject: Discussion of Spells and Grimoire items
List archive
- From: Pierre Abbat <phma AT webjockey.net>
- To: Source Mage - Grimoire <sm-grimoire AT lists.ibiblio.org>
- Subject: Re: [SM-Grimoire] postgresql startup
- Date: Fri, 3 Jan 2003 12:16:55 -0500
On Friday 03 January 2003 11:56, Julian v. Bock wrote:
> Hi
>
> >>>>> "SW" == Seth Woolley <seth AT tautology.org> writes:
>
> SW> change -D to wherever you put your data, etc.
>
> We should not impose where to put the data. DBAs tend to not like
> that ;)
>
> SW> There's other stuff that needs to happen, too. like database
> SW> creation if it doesn't already exist
>
> Create what database? What encoding? Who is the superuser? Who
> owns the database? [10 other questions]
> With what modifications to the postgresql.conf? [another 30 questions]
That's what we have CONFIGURE scripts in the spells for. The databases that
have to be created are template0 and template1.
> SW> needs a way to upgrade seamlessly (as possible) on updates.
>
> You want the spell to try to automatically update between releases
> like 7.2.3 and 7.3?????
>
> I hope you don't meet the dba at night who had to recover all the
> critical data after things went wrong. There are likely to be
> incompatibilities between major releases (as there are between 7.2.3
> and 7.3) and pg_dump does not always print the schema in correct order
> BTW so you might need to fix the dump manually...
AFAIK, there is no way to put pgsql into a mode where the only operations
allowed are backing up and restoring databases. It is therefore possible that
a database is backed up in preparation for an upgrade, then someone makes a
change to it, and the change is lost.
phma
-
[SM-Grimoire] postgresql startup,
Pierre Abbat, 01/03/2003
-
Re: [SM-Grimoire] postgresql startup,
Seth Woolley, 01/03/2003
- Re: [SM-Grimoire] postgresql startup, Pierre Abbat, 01/03/2003
-
Re: [SM-Grimoire] postgresql startup,
Julian v. Bock, 01/03/2003
- Re: [SM-Grimoire] postgresql startup, Pierre Abbat, 01/03/2003
-
Re: [SM-Grimoire] postgresql startup,
Seth Woolley, 01/03/2003
Archive powered by MHonArc 2.6.24.