Re: Upgrading rant. - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Upgrading rant.
Date
Msg-id Pine.LNX.4.44.0301041202050.8249-100000@localhost.localdomain
Whole thread Raw
In response to Re: Upgrading rant.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Upgrading rant.
Re: Upgrading rant.
List pgsql-hackers
Tom Lane writes:

> This would require a nontrivial amount of work (notably, we'd have to
> be able to get pg_dump to run against a standalone backend) but I don't
> think I'd trust pg_upgrade as a production-grade tool until its
> invocation method looks like the above.

I would recommend requiring users to do the schema dump before upgrading
the binaries, so they'd do

pg_dumpall -s > schemadump
pg_ctl stop
[upgrade binaries]
pg_upgrade --option=schemadump
pg_ctl start

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: next set of SSL - ideas?
Next
From: Tom Lane
Date:
Subject: Re: Upgrading rant.