Postgres Pro
Downloads
Home   >   mailing lists

pg_dump - txt sql vs binary - Mailing list pgsql-admin

From Ciprian Hodorogea
Subject pg_dump - txt sql vs binary
Date
Msg-id 20060122204132.9567D14DB13@mail07.powweb.com
Whole thread Raw
Responses Re: pg_dump - txt sql vs binary  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

Hi All,

 

  1. I noticed that binary dumps created with Postgres 8.0.3 can not be imported with Postgres 8.1.x, so this is not a good backup idea.

 

  2. All dumps generated with pg_dump seem to contain internal functions also, which then raise problems when trying to import. Can these be somehow excluded from the generated SQL backup?

 

  All I want is to obtain a valid SQL file that I can then import within any upcoming version of Postgres.  Does anyone have any suggestion please?

 

Best regards,

 

Ciprian Hodorogea

IntelliSoft SRL

http://www.bitsp.com/

 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: What happens to transactions durring a pg_dump?
Next
From: Tom Lane
Date:
Subject: Re: pg_dump - txt sql vs binary