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


[EMAIL PROTECTED] wrote:


-----Original Message-----
*From:* Dukwicz, Leszek, (BRE/DIN)
*Sent:* Monday, February 23, 2004 8:26 AM
*To:* '[EMAIL PROTECTED]'
*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 [EMAIL PROTECTED]
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to