Post-9.0 Migration

@@ -427,7 +427,7 @@ To finish the installation: =20

This will create the database cluster and store all the related server f= iles -into DATA_DIR. +into PGDATA and DATA_DIR.

=20 @@ -656,6 +656,47 @@ dev-db/postgresql-docs, dev-db/postgresql-base and d= ev-db/postgresql-server. =20 +

+Post-9.0 Migration + + +

+pg_upgrade, a new utility that comes along with 9.0 and later, si= mplifies +the migration process rather drastically. +

+ +

+However, there are two caveats with using pg_upgrade. Firstly, it does n= ot +support configuration files being in a different directory than where th= e data +is stored. This can be resolved by using symbolic links. Lastly, you can= only +use it to migrate from a database from 8.3 or newer. If you have an olde= r +database you will need to follow the Pre-9.0 Migrat= ion +instructions. +

+ +

+(Stop the servers you're going to migrate from and to.)
+# /etc/init.d/postgresql-8.4 stop
+# /etc/init.d/postgresql-9.0 stop
+# ln -s /etc/postgresql-8.4/*.conf /var/lib/postgresql/8.4/data/
+# ln -s /etc/postgresql-9.0/*.conf /var/lib/postgresql/9.0/data/
+
+(Change the method of 'postgres' to trust on local connections)=

+# nano -w /etc/postgresql-8.4/pg_hba.conf
+# nano -w /etc/postgresql-9.0/pg_hba.conf
+# pg_upgrade -u postgres \
+  -d /var/lib/postgresql/8.4/data -D /var/lib/postgresql/9.0 \
+  -b /usr/lib/postgresql-8.4/bin -B /usr/lib/postgresql-9.0/bin
+(Perform the tasks pg_upgrade tells you to.)
+
+(Remove the symbolic links  we created earlier.)
+# rm /var/lib/postgresql/8.4/data/*.conf
+# rm /var/lib/postgresql/9.0/data/*.conf
+# /etc/init.d/postgresql-9.0 start
+

+ + +

Pre-9.0 Migration: With the New Ebuilds @@ -724,47 +765,6 @@ server that contains precisely the same data, bit fo= r bit, as the old server. =20

-Post-9.0 Migration - - -

-pg_upgrade, a new utility that comes along with 9.0 and later, si= mplifies -the migration process rather drastically. -

- -

-However, there are two caveats with using pg_upgrade. Firstly, it does n= ot -support configuration files being in a different directory than where th= e data -is stored. This can be resolved by using symbolic links. Lastly, you can= only -use it to migrate from a database from 8.3 or newer. If you have an olde= r -database you will need to follow the Pre-9.0 Migrat= ion -instructions. -

- -

-(Stop the servers you're going to migrate from and to.)
-# /etc/init.d/postgresql-8.4 stop
-# /etc/init.d/postgresql-9.0 stop
-# ln -s /etc/postgresql-8.4/*.conf /var/lib/postgresql/8.4/data/
-# ln -s /etc/postgresql-9.0/*.conf /var/lib/postgresql/9.0/data/
-
-(Change the method of 'postgres' to trust on local connections)=

-# nano -w /etc/postgresql-8.4/pg_hba.conf
-# nano -w /etc/postgresql-9.0/pg_hba.conf
-# pg_upgrade -u postgres \
-  -d /var/lib/postgresql/8.4/data -D /var/lib/postgresql/9.0 \
-  -b /usr/lib/postgresql-8.4/bin -B /usr/lib/postgresql-9.0/bin
-(Perform the tasks pg_upgrade tells you to.)
-
-(Remove the symbolic links  we created earlier.)
-# rm /var/lib/postgresql/8.4/data/*.conf
-# rm /var/lib/postgresql/9.0/data/*.conf
-# /etc/init.d/postgresql-9.0 start
-

- - -

Pre-9.0 Migration: From the Obsolete Ebuilds