pg_dump - txt sql vs binary

From: "Ciprian Hodorogea" <ciprian(dot)hodorogea(at)bitsp(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump - txt sql vs binary
Date: 2006-01-22 20:41:27
Message-ID: 20060122204132.9567D14DB13@mail07.powweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-01-22 23:51:20 Re: pg_dump - txt sql vs binary
Previous Message Tom Lane 2006-01-22 00:50:42 Re: What happens to transactions durring a pg_dump?