On Wed, 19 Nov 2003 11:55:46 -0600
"John Liu" <johnl@emrx.com> wrote:
> I've two questions, they may or may not be related -
> 1. I copied the entire data directory [including
> postgresql.conf, base, ...] from postgreSQL 7.3.2 (AIX4.3)
> to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem
> setup. I didn't do an dump/reload process
> since the copy process is faster.
>
> Is it OK to take this shortcut in postgreSQL? any side-effects?
>
If you did this while PG was running you have a big pile of meaningless
data. The only two ways to do this are to shut down PG and copy or use
an LVM and take a snapshot.
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/