From: Oli Sennhauser <oli.sennhauser@bluewin.ch>
To: Leszek.Dukwicz@brebank.com.pl
Cc: pgsql-admin@postgresql.org
Subject: Re: FW: FW:
Date: Mon, 23 Feb 2004 19:12:01 +0100
Message-ID: <403A4271.8090003@bluewin.ch> (raw)
In-Reply-To: <D4D6A8A74DE9F54A8280EA3E7B5496AA025769D6@WARPOLARISE.brenet.pl>
References: <D4D6A8A74DE9F54A8280EA3E7B5496AA025769D6@WARPOLARISE.brenet.pl>
We normaly did an dump in a pipe then a compress into a second pipe and
then a split (in oracle).
But in my opinion it also should work with pg?
Roughly:
mknod my_pipe1 p
mknod my_pipe2 p
nohup compress < my_pipe1 > my_pipe2 &
nohup split -m 2000 < my_pipe1 &
nohup pg_dump > my_pipe1 &
But please try it out before doing it on a productive system!!!
Especially the restore.
Regards Oli
Leszek.Dukwicz@brebank.com.pl wrote:
> -----Original Message-----
> *From:* Dukwicz, Leszek, (BRE/DIN)
> *Sent:* Monday, February 23, 2004 8:26 AM
> *To:* 'pgsql-admin@postgresql.org'
> *Subject:*
> *Importance:* High
>
> Hi,
>
> We are running Postgresql 7.3.4. Does anyone know how to make pg_dump
> write
>
> dumps larger than 2 GB?? Compilation with D_FILE_OFFSET_BITS=64 gave
>
> no results...
>
> Sorry previous mail did not contain O/S info: it's UnixWare 7.1.1 and
> 7.1.3
>
> Thanks in advance
>
> Leszek Dukwicz
>
--
-------------------------------------------------------
Haben Sie Ihre Firma schon im FOSS-Directory (www.foss-directory.ch) eingetragen?
Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland
Phone (+41) 1 940 24 82
e-Mail oli.sennhauser@bluewin.ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: oli.sennhauser@bluewin.ch, Leszek.Dukwicz@brebank.com.pl
Subject: Re: FW: FW:
In-Reply-To: <403A4271.8090003@bluewin.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox