pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFW: FW:
3+ messages / 3 participants
[nested] [flat]
* FW: FW:
@ 2004-02-23 08:16 Leszek.Dukwicz@brebank.com.pl
0 siblings, 1 reply; 3+ messages in thread
From: Leszek.Dukwicz@brebank.com.pl @ 2004-02-23 08:16 UTC (permalink / raw)
To: pgsql-admin
-----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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: FW: FW:
@ 2004-02-23 18:12 Oli Sennhauser <oli.sennhauser@bluewin.ch>
parent: Leszek.Dukwicz@brebank.com.pl
0 siblings, 1 reply; 3+ messages in thread
From: Oli Sennhauser @ 2004-02-23 18:12 UTC (permalink / raw)
To: Leszek.Dukwicz@brebank.com.pl; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: FW: FW:
@ 2004-02-23 18:41 Bjoern Metzdorf <bm@turtle-entertainment.de>
parent: Oli Sennhauser <oli.sennhauser@bluewin.ch>
0 siblings, 0 replies; 3+ messages in thread
From: Bjoern Metzdorf @ 2004-02-23 18:41 UTC (permalink / raw)
To: Oli Sennhauser <oli.sennhauser@bluewin.ch>; +Cc: Leszek.Dukwicz@brebank.com.pl; pgsql-admin
> 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 &
How about
pg_dump | split -m 2000
?
Regards,
Bjoern
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-02-23 18:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-23 08:16 FW: FW: Leszek.Dukwicz@brebank.com.pl
2004-02-23 18:12 ` Re: FW: FW: Oli Sennhauser <oli.sennhauser@bluewin.ch>
2004-02-23 18:41 ` Re: FW: FW: Bjoern Metzdorf <bm@turtle-entertainment.de>
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