Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group