Re: pg_restore from split files

From: akp geek <akpgeek(at)gmail(dot)com>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore from split files
Date: 2013-04-22 19:47:06
Message-ID: CACnhOfKPO0e9YpKzv6P_rWw3mA7YvQevxyhWDQCmGP3e4cMJrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

pg_dump dbname -n schemaname -t table_name -Fc | split -b 500m -t table.dump

On Mon, Apr 22, 2013 at 3:41 PM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:

> How exactly did you create “split” dump?****
>
> ** **
>
> Igor Neyman****
>
> ** **
>
> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *akp geek
> *Sent:* Monday, April 22, 2013 3:36 PM
> *To:* pgsql-general
> *Subject:* [GENERAL] pg_restore from split files****
>
> ** **
>
> Hi All -****
>
> ** **
>
> I have created a dump of a big table into 5 split files. What is the
> procedure to restore them using pg_dump.****
>
> ** **
>
> I am getting the following error****
>
> ** **
>
> pg_restore: [custom archiver] could not read from input file: end of file*
> ***
>
> pg_restore: *** aborted because of error****
>
> ** **
>
> Appreciate your help.****
>
> ** **
>
> Regards****
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-04-22 19:56:50 Re: pg_restore from split files
Previous Message Igor Neyman 2013-04-22 19:41:28 Re: pg_restore from split files