On Jun 25, 2007, at 10:44 , Nicholas Barr wrote:
Only copy the data directory if both servers are offline and not
running
and if both servers use the same version of postgres.
... and have the same architecture. As you note, copying the data
directory is *not* the recommended way to do this. Use pg_dump[all]
or something like Slony.
Michael Glaesemann
grzm seespotcode net
---------------------------(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
