Re: missing public on schema public

[Bo Thorbjørn Jensen <bo@xxxxxxxxxxxx>]

I have some additional info and a fix.

 

Firstly steps to reproduce:

 

1.  create database:

CREATE DATABASE test WITH ENCODING='UTF8' OWNER=postgres CONNECTION LIMIT=-1;

-- here public has access to public

 

2. dump:

pg_dump -f testfile.dump -F c -h localhost -U postgres test

 

3. restore:

pg_restore -c -d testfile.dump -h localhost -U postgres test

-- here public no longer has access to schema public

 

It is easily fixable with:

GRANT ALL ON SCHEMA public TO public;

 

And the issue goes away.. (privilege stays after next dump/restore)

 

So. What am I missing?

Is this intentional functionality ?

 

Kind regards and again thank you for your time

 

Bo Thorbjørn Jensen