Re: pg_dump and pg_dumpall in real life - Mailing list pgsql-hackers

On Mon, Nov 11, 2013 at 8:20 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
>
> [...]
>
> Well, then we just need pg_restore to handle the "role already exists"
> error message gracefully.  That's all.  Or a "CREATE ROLE IF NOT EXISTS"
> statement, and use that for roles.
>

I'm working in a patch to add IF NOT EXISTS for all CREATE statements,
including of course the CREATE ROLE statement.
 

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello