pg_dumpall doesn't handle all it should - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject pg_dumpall doesn't handle all it should
Date
Msg-id 200012191927.eBJJRvc79566@hub.org
Whole thread Raw
List pgsql-bugs
Tomasz Krysinski (tomcio@gic.gov.pl) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pg_dumpall doesn't handle all it should

Long Description
1. it doesn't handle alternate data dirs (just skips the WITH LOCATION statement in CREATE DATABASE). I know it's not
theonly thing required to recreate such database (a directory must be created and initlocation-ed), but silently
skippingthe problem doesn't seem to be a good idea. 
2. nor does it handle different names for a C shared lib function and an SQL function (skips the C function name in
CREATEFUNCTION) which results in failure to recreate when the names differ indeed. 

(I suppose pg_dump does the same)

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Bug report
Next
From: "Robert B. Easter"
Date:
Subject: Re: Backend dies when overloading + operator for bool