Discussion:
(too old to reply)
L***@brebank.com.pl
2004-02-23 08:16:47 UTC
Permalink
-----Original Message-----
From: Dukwicz, Leszek, (BRE/DIN)
Sent: Monday, February 23, 2004 8:26 AM
To: 'pgsql-***@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
Oli Sennhauser
2004-02-23 18:12:01 UTC
Permalink
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
Post by L***@brebank.com.pl
-----Original Message-----
*From:* Dukwicz, Leszek, (BRE/DIN)
*Sent:* Monday, February 23, 2004 8:26 AM
*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 ***@bluewin.ch
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
Bjoern Metzdorf
2004-02-23 18:41:45 UTC
Permalink
Post by Oli Sennhauser
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 &
How about

pg_dump | split -m 2000

?

Regards,
Bjoern

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

scott.marlowe
2004-02-23 18:31:33 UTC
Permalink
Post by L***@brebank.com.pl
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...
Hi, what OS and such are you running on? I've had no problems on RH7.2
doing this. And I just use a default ./configure source file made pgsql
7.2.x




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Loading...