Re: missing public on schema public

From: Bo Thorbjørn Jensen <bo(at)budget123(dot)dk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: missing public on schema public
Date: 2017-11-14 11:17:29
Message-ID: AD7252BEFBCA3846A8D34ABCDA258D080120F025C6@EXMBX05.mailcloud.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jose Maria Terry Jimenez 2017-11-14 11:54:22 Re: Because PostgreSQL is compiling in old versions of OS?
Previous Message Durumdara 2017-11-14 11:09:31 Connection loosing at some places - caused by firewall