Обсуждение: pg_dump on 7.4

Hi,

We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade. Through
anunusual combination of constraints (spanning over schemas) the dump cannot be imported without errors anymore.  

Are there any statically compiled 8.x binaries (with which it works) available which I could use to backup the
database?

Thanks
Jürgen

--
SAG Energieversorgungslösungen GmbH
Center für GeoInformationsTechnologie
CeGIT

Westfalendamm 100
44141 Dortmund

E mailto:Juergen.Rose@sag.de
I http://www.cegit.com
  http://www.sag-el.com

T +49-231-725488-44 (Büro CeGIT)
T +49-231-913003-20 (Büro WGI)
F +49-231-725488-13
M +49-173-2745926

"Rose, Juergen" <Juergen.Rose@sag.de> writes:
> We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade.
Throughan unusual combination of constraints (spanning over schemas) the dump cannot be imported without errors
anymore. 

Try using an 8.0 or 8.1 pg_dump with the 7.4 server.  7.4's pg_dump is
not very bright about dumping things in the right order.  If it still
doesn't work with a modern pg_dump, please show details.

            regards, tom lane

>
>> We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade.
Throughan unusual combination of constraints (spanning over schemas) the dump cannot be imported without errors
anymore. 
>>
>
> Try using an 8.0 or 8.1 pg_dump with the 7.4 server.  7.4's pg_dump is
> not very bright about dumping things in the right order.  If it still
> doesn't work with a modern pg_dump, please show details.
>
>             regards, tom lane
>

Right, this is the exact problem, it works with pg_dump of postgresql 8.
But I need the pg_dump on the server itself, Therefore I need a
statically compiled version (because I can't upgrade to the whole
postgresql 8)

Does anyone know where to find statically compiled binaries?


regards,
Jürgen