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 |
Message-ID: | 5265F05D.9000406@timbira.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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 - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
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 |