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
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 |