Re:

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Matias Monteverde <matias(at)ssi(dot)cl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re:
Date: 2003-02-06 14:38:24
Message-ID: 1044542304.22884.118.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2003-02-05 at 15:04, Matias Monteverde wrote:
> Dear list:
>
> I need to move all databases from one fiscal server to other,
> but, the
> main problem I have is: I can't dump databases, for internal problems
> from hdd. My question is, so, how can rescue all databases in 'cp
> command' way in posgresql version 7.0 ?
>
>
> Needing to know:
>
> I copy /usr/local/pgsql/data/base.
>
> Any help will be great.
>

If your not upgrading versions, I feel this should work. If you are
upgrading version, I'm less optimistic but wouldn't rule it out untill
it was tried. In either case, make sure to shutdown your database first;
copied files on a live database are almost sure to have issues.

Robert Treat

In response to

  • at 2003-02-05 20:04:51 from Matias Monteverde

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-02-06 14:58:41 Re: Update cascade on stmt, not on table definition
Previous Message Tom Lane 2003-02-06 14:33:08 Re: Using advance update