Re: copy database by copying datafiles ? - Mailing list pgsql-general

From Alex Vinogradovs
Subject Re: copy database by copying datafiles ?
Date
Msg-id 1198534557.58046.7.camel@localhost
Whole thread Raw
In response to Re: copy database by copying datafiles ?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Sorry guys, was my mistake... I found one file missing in global
tablespace. Copying it there fixed the problem.

Thanks everyone!



On Mon, 2007-12-24 at 14:07 -0800, Richard Broersma Jr wrote:
> --- On Mon, 12/24/07, Alex Vinogradovs <AVinogradovs@Clearpathnet.com> wrote:
>
> > P.S. datafiles are 85GB in size, I couldn't really dump
> > and restore...
>
> Don't for get the steps of compressing and uncompressing between dump and restore.;)  If the file is still too big,
youcan always use tar to spit the file up to make the transition a bit more manageable. 
>
> Regards,
> Richard Broersma Jr.

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: copy database by copying datafiles ?
Next
From: Shane Ambler
Date:
Subject: Re: Postgres from PHP in Leopard