Skip site navigation (1) Skip section navigation (2)

BUG #7741: Two bugs when backing up databases with default privilegesdefined on public schema

From: me(at)nathanalden(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7741: Two bugs when backing up databases with default privilegesdefined on public schema
Date: 2012-12-08 02:02:52
Message-ID: E1Th9ki-0007ii-J2@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7741
Logged by:          Nathan Alden, Sr.
Email address:      me(at)nathanalden(dot)com
PostgreSQL version: 9.2.2
Operating system:   Windows 7 x64
Description:        

- Create new group role called my_group with default settings
- Create a new database called test_database with default settings
- Run the following SQL:

alter default privileges in schema public grant all on tables to my_group;
alter default privileges in schema public grant all on functions to
my_group;
alter default privileges in schema public grant all on sequences to
my_group;
alter default privileges in schema public grant all on types to my_group;

- Using pgAdmin III, backup the test_database database using the plain
format and note the error. Here's the log:

C:/Program Files/PostgreSQL/9.2/bin\pg_dump.exe --host localhost --port 5432
--username "postgres" --no-password  --format plain --verbose --file
"D:\Databases\PostgreSQL Backups\test_database.backup" "test_database"
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading extensions
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: finding extension members
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving database definition
pg_dump: unknown object type (84) in default privileges

Process returned exit code 1.

- Again in pgAdmin III, right-click the public schema and choose Properties
- Navigate to the Default Privileges tab and note how no default privileges
show up, even though they are present



Responses

pgsql-bugs by date

Next:From: meDate: 2012-12-08 02:29:30
Subject: BUG #7742: Bug when backing up databases with default privilegesdefined on public schema
Previous:From: Rogelio MonterDate: 2012-12-08 01:45:14
Subject: Migrate Posgresql 8.0.0 beta 5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group