We just did this. I did a pg_dumpall using 8.1. Then we fired up
8.2 while 8.1 was still running. Uploaded the data to 8.2. Then
shut 8.1 down. This allowed us to have the database unavailable for
a very short time.
Carol
On Sep 20, 2007, at 11:58 AM, Milen A. Radev wrote:
Josef Springer написа:
Where is the documentation of the steps dto do for updating e.g.
from 8.1 to 8.2 ?
I have never done this and could not find any docs for.
[...]
http://www.postgresql.org/docs/8.2/static/install-upgrading.html
--
Milen A. Radev
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match