| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | "John Liu" <johnl(at)emrx(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: core dump |
| Date: | 2003-11-19 18:03:05 |
| Message-ID: | 20031119130305.107e7f9f.threshar@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 19 Nov 2003 11:55:46 -0600
"John Liu" <johnl(at)emrx(dot)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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2003-11-19 18:05:26 | Re: SuSE RPMs available for PostgreSQL 7.4 |
| Previous Message | Jan Wieck | 2003-11-19 18:00:08 | Re: 7.4 broke psql |