Re: copy database by copying datafiles ?

From: Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: copy database by copying datafiles ?
Date: 2007-12-24 22:15:57
Message-ID: 1198534557.58046.7.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Clearpathnet(dot)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, you can always use tar to spit the file up to make the transition a bit more manageable.
>
> Regards,
> Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2007-12-25 00:28:15 Re: Postgres from PHP in Leopard
Previous Message Richard Broersma Jr 2007-12-24 22:07:53 Re: copy database by copying datafiles ?