On 04/26/2018 07:52 AM, Thomas Poty wrote:
Hi,
About the minor version, we will plan the upgrade soon .
So how did you revoke the privileges for PUBLIC in the above? [db source]
=> After creation of the database, I executed:
revoke all on schema public from public;
Hmm:
https://git.post
Hi,
About the minor version, we will plan the upgrade soon .
So how did you revoke the privileges for PUBLIC in the above? [db source]
=> After creation of the database, I executed:
revoke all on schema public from public;
Thanks for the 'no-op' .
Thomas
2018-04-26 16:28 GMT+02:00 Adrian
On 04/26/2018 12:03 AM, Thomas Poty wrote:
Hi,
Comments in line below.
*About version :*
This is the same on both server
_ + source server :_
[[local]] thomasproot@serverconfig=# select version();
┌
I have run this command (same of previous one without -d and with -f
argument :
/bin/pg_restore --username=backup --host=VM38 --port=5432 --no-password
--disable-triggers --verbose --clean --create --if-exists -f
/tmp/thomasp.log /mnt/backupPostgreSQL/serverco
nfig_prod/backup_in_progress/serverc
Hi,
*About version :*
This is the same on both server
* + source server :*
[[local]] thomasproot@serverconfig=# select version();
┌──┐
│
version
On 04/25/2018 11:07 AM, Thomas Poty wrote:
Hello,
Here is the context :
Postgres version?
I have a db db1 with a schéma public on cluster C1.
This schéma doesn't have any privileges on public role.
I have a dump of this db.
What was the dump command?
On an other cluster C2, the template
Hello,
Here is the context :
I have a db db1 with a schéma public on cluster C1.
This schéma doesn't have any privileges on public role.
I have a dump of this db.
On an other cluster C2, the template1 doesn't contain schema public.
I have restored db1 on cluster C2 and i saw public role had the p
