Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_dump - txt sql vs binary
Date
Msg-id 22930.1137973880@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump - txt sql vs binary  ("Ciprian Hodorogea" <ciprian.hodorogea@bitsp.com>)
Responses Re: pg_dump - txt sql vs binary  (Ciprian Hodorogea <ciprian.hodorogea@bitsp.com>)
List pgsql-admin
Tree view 
"Ciprian Hodorogea" <ciprian.hodorogea@bitsp.com> writes:
>   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.

If you mean a filesystem dump, no.

>   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?

Details please?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Ciprian Hodorogea"
Date:
Subject: pg_dump - txt sql vs binary
Next
From: Dan Bikle
Date:
Subject: [pgsql-admin] Simple question about security in 8.1.1