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

Re: FW: FW:

From: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
To: Leszek(dot)Dukwicz(at)brebank(dot)com(dot)pl
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: FW: FW:
Date: 2004-02-23 18:12:01
Message-ID: 403A4271.8090003@bluewin.ch (view raw or flat)
Thread:
Lists: 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(dot)Dukwicz(at)brebank(dot)com(dot)pl wrote:

> -----Original Message-----
> *From:* Dukwicz, Leszek, (BRE/DIN)
> *Sent:* Monday, February 23, 2004 8:26 AM
> *To:* 'pgsql-admin(at)postgresql(dot)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(dot)sennhauser(at)bluewin(dot)ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/


In response to

  • FW: FW: at 2004-02-23 08:16:47 from Leszek.Dukwicz

Responses

  • Re: FW: FW: at 2004-02-23 18:41:45 from Bjoern Metzdorf

pgsql-admin by date

Next:From: scott.marloweDate: 2004-02-23 18:31:33
Subject: Re:
Previous:From: Bethany A.BenzurDate: 2004-02-23 15:56:09
Subject: Re: pg_user does not exist

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