Re: pg_dumpall --roles-only interact with other options - Mailing list pgsql-hackers

From Zsolt Parragi
Subject Re: pg_dumpall --roles-only interact with other options
Date
Msg-id CAN4CZFMbSpaEZNGCAo-ky93OQPYBvbsTS1bNdF8d91HtLKrdEQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_dumpall --roles-only interact with other options  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Hello!

> I believe "schema" generally refers to object definitions, excluding
> things like roles and tablespaces.

Please see the attached tap test case. It works with the current
master branch, and fails with the patch. Basically my expectation is
that if we use dumpall --schema-only, we should be able to restore it
without errors, except for one error for the already existing
postgres/current user which it ignores.

I also found one more issue/behavior change: --no-schema --clean now
generates DROP statements (roles, tablespaces, databases), while
previously it didn't.

Attachment

pgsql-hackers by date:

Previous
From: Bowen Shi
Date:
Subject: Re: Changing shared_buffers without restart
Next
From: Laurenz Albe
Date:
Subject: Re: client_connection_check_interval default value