Re: Dump database more than 1 flat file

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: A(dot)Burbello <burbello3000(at)yahoo(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Dump database more than 1 flat file
Date: 2007-12-15 18:16:14
Message-ID: dcc563d10712151016s381f09e1m6637a8d4cb49f37e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Dec 15, 2007 11:42 AM, A.Burbello <burbello3000(at)yahoo(dot)com(dot)br> wrote:
> Hi people,
>
> How can I export (dump) database more than 1 file?
> I have great table and can't split.
> Like Oracle, just set the parameter filesize and the
> files name, and dump in several files.

You could pipe the output of pg_dump to split, or split it after it's
been created.

But is there a reason for doing this or is it just some practice you're into?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julio Leyva 2007-12-15 23:55:09 Re: pg_hba.conf is driving me nuts
Previous Message A.Burbello 2007-12-15 17:42:07 Dump database more than 1 flat file