Re: BUG #8545: pg_dump fails to backup database level grants

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: lalbin(at)fhcrc(dot)org
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8545: pg_dump fails to backup database level grants
Date: 2013-10-22 03:26:21
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On 21-10-2013 19:17, lalbin(at)fhcrc(dot)org wrote:
> Most people I know, including myself, use pg_dumpall -g to dump out the
> globals such as user accounts and then use pg_dump -Fc or -Fd to dump out
> their databases in the compressed formats. When doing this method the
> database level grants have been missed, although if people used the
> pg_dumpall to dump the entire server they will be dumped, but not in a
> compressed format that they can use with pg_restores multi-job.
Lloyd, this is not a bug. pg_dump doesn't dump global objects such as
databases, roles and tablespaces. Hence grants are not presented in your
dump. If you want global objects use pg_dumpall.

Euler Taveira Timbira -
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Honza Horak 2013-10-22 11:55:43 Re: random() generates collisions too early
Previous Message Michael Paquier 2013-10-22 00:42:48 Re: BUG #8543: Standby recovery use incorrect timeline to determine WAL length