[pgpool-general: 3700] Importing a full dump as postgres user

José Renato Castro Milanez jrcmilanez at unifei.edu.br
Tue May 12 03:16:26 JST 2015


Hello friends, how are you?

I'm importing a full dump as postgres user. The dump contains the same user with the same password and was created with the pg_dumpall -c option.
While importing, I got a crash with the output below. My question is: is it crash because it´s trying to drop the postgres role?

Thanks!

May 11 14:45:55 tarso pgpool[1759]: [260-1] 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
May 11 14:45:55 tarso pgpool[1759]: [261-1] 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
May 11 14:45:55 tarso pgpool: 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
May 11 14:45:55 tarso pgpool: 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
May 11 14:45:57 tarso pgpool[1759]: [262-1] 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
May 11 14:45:57 tarso pgpool: 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
May 11 14:45:57 tarso pgpool[1759]: [263-1] 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
May 11 14:45:57 tarso pgpool: 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
May 11 14:47:56 tarso kernel: pgpool[1751]: segfault at 61da ip 0000000000469d99 sp 00007fff20755e90 error 4 in pgpool[400000+134000]
May 11 14:47:56 tarso abrt-hook-ccpp: Saved core dump of pid 1751 (/usr/pgpool-9.3/bin/pgpool) to /var/tmp/abrt/ccpp-2015-05-11-14:47:56-1751 (144973824 bytes)
May 11 14:47:56 tarso pgpool[1186]: [329-1] 2015-05-11 14:47:56: pid 1186: WARNING:  child process with pid: 1751 was terminated by segmentation fault
May 11 14:47:56 tarso pgpool[1186]: [330-1] 2015-05-11 14:47:56: pid 1186: LOG:  fork a new child process with pid: 1884
May 11 14:47:56 tarso pgpool: 2015-05-11 14:47:56: pid 1186: WARNING:  child process with pid: 1751 was terminated by segmentation fault
May 11 14:47:56 tarso pgpool: 2015-05-11 14:47:56: pid 1186: LOG:  fork a new child process with pid: 1884


=============================================================
M.Sc. José Renato Castro Milanez
Analista de Tecnologia da Informação/TI Analist
Diretoria de Suporte a Informática/Computer Support Direction
Universidade Federal de Itajubá/Federal University of Itajubá
Itajubá - Minas Gerais - Brasil
Telefone/Phone (55) (35) 3629-1643
E-mail jrcmilanez at unifei.edu.br - Skype jrcmilanez
=============================================================




More information about the pgpool-general mailing list