Re: [HACKERS] Error during restore - dump taken with pg_dumpall -c option

2016-05-24 Thread Stephen Frost
Rushabh, * Rushabh Lathia (rushabh.lat...@gmail.com) wrote: > On Fri, May 13, 2016 at 7:27 PM, Stephen Frost wrote: > > > * Rushabh Lathia (rushabh.lat...@gmail.com) wrote: > > > On master branch when we do pg_dumpall with -c option, I can see that > > > it also dumping the "DROP ROLE pg_signal_

Re: [HACKERS] Error during restore - dump taken with pg_dumpall -c option

2016-05-21 Thread Rushabh Lathia
On Fri, May 13, 2016 at 7:27 PM, Stephen Frost wrote: > * Rushabh Lathia (rushabh.lat...@gmail.com) wrote: > > On master branch when we do pg_dumpall with -c option, I can see that > > it also dumping the "DROP ROLE pg_signal_backend", which seems wrong. > > Because when you restore the dump, its

Re: [HACKERS] Error during restore - dump taken with pg_dumpall -c option

2016-05-13 Thread Stephen Frost
* Rushabh Lathia (rushabh.lat...@gmail.com) wrote: > On master branch when we do pg_dumpall with -c option, I can see that > it also dumping the "DROP ROLE pg_signal_backend", which seems wrong. > Because when you restore the dump, its throwing an error > "ERROR: cannot drop role pg_signal_backend

Re: [HACKERS] Error during restore - dump taken with pg_dumpall -c option

2016-05-13 Thread Michael Paquier
On Thu, May 12, 2016 at 9:48 PM, Fabrízio de Royes Mello wrote: > > > Em quinta-feira, 12 de maio de 2016, Rushabh Lathia > escreveu: >> >> >> On master branch when we do pg_dumpall with -c option, I can see that >> it also dumping the "DROP ROLE pg_signal_backend", which seems wrong. >> Because

Re: [HACKERS] Error during restore - dump taken with pg_dumpall -c option

2016-05-12 Thread Fabrízio de Royes Mello
Em quinta-feira, 12 de maio de 2016, Rushabh Lathia < rushabh.lat...@gmail.com> escreveu: > > On master branch when we do pg_dumpall with -c option, I can see that > it also dumping the "DROP ROLE pg_signal_backend", which seems wrong. > Because when you restore the dump, its throwing an error > "

[HACKERS] Error during restore - dump taken with pg_dumpall -c option

2016-05-12 Thread Rushabh Lathia
On master branch when we do pg_dumpall with -c option, I can see that it also dumping the "DROP ROLE pg_signal_backend", which seems wrong. Because when you restore the dump, its throwing an error "ERROR: cannot drop role pg_signal_backend because it is required by the database system". dumpRole