PG was shutdown on both AIXs,
otherwise it may not be able
to start up after the copy.
thanks.
johnl
> -----Original Message-----
> From: Jeff [mailto:threshar@torgo.978.org]
> Sent: Wednesday, November 19, 2003 12:03 PM
> To: John Liu
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] core dump
>
>
> 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/
>
