Re: pg_dump schema in pg11 without global permissions

On 7/23/19 4:17 PM, Sergey Koposov wrote:

>
> For some reason I see when I just have
> a command  like this it doesnt' have a grant connect on database
> ~/soft/pgsql_install/bin/pg_dump -U skoposov -h localhost -n xx  --no-tablespaces test1
> but when I add  '-Fc' flag to pg_dump, I can see 'grant connect' inside the output (interdispersed with binary stuff)
>
> I don't get it

As Tom explained the custom format will include a lot of information
that you can retrieve later or not. For this case:

https://www.postgresql.org/docs/11/app-pgdump.html

"-C
--create

Begin the output with a command to create the database itself and
reconnect to the created database. (With a script of this form, it
doesn't matter which database in the destination installation you
connect to before running the script.) If --clean is also specified, the
script drops and recreates the target database before reconnecting to it.

With --create, the output also includes the database's comment if
any, and any configuration variable settings that are specific to this
database, that is, any ALTER DATABASE ... SET ... and ALTER ROLE ... IN
DATABASE ... SET ... commands that mention this database. Access
privileges for the database itself are also dumped, unless --no-acl is
specified.

This option is only meaningful for the plain-text format. For the
archive formats, you can specify the option when you call pg_restore.
"

NOTE the last paragraph.

>
>        S
>
>>>
>>>
>>>
>>>         S
>>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com