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

On 21-10-2013 19:17, lalbin@fhcrc.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 - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento