this is the message from the RDS logs when i set it to debug5: 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: StartTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: bind <unnamed> to <unnamed> 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: CommitTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: parse <unnamed>: SELECT * FROM bucardo.bucardo_delta_check($1,$2) 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: StartTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: bind <unnamed> to <unnamed> 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: GOT <NULL> and public.actions 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:ERROR: query string argument of EXECUTE is null 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:CONTEXT: PL/pgSQL function bucardo.bucardo_delta_check(text,text) line 24 at EXECUTE statement 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:STATEMENT: SELECT * FROM bucardo.bucardo_delta_check($1,$2) 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: StartTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: CommitTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: StartTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: ProcessUtility 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: CommitTransactionCommand 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: shmem_exit(0): 7 callbacks to make 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: proc_exit(0): 3 callbacks to make 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: SSL: write alert (0x0100) 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: exit(0) 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: shmem_exit(-1): 0 callbacks to make 2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net (48786):ticadmin@auth:[1228]:DEBUG: proc_exit(-1): 0 callbacks to make 2018-01-17 16:24:32 UTC::@:[3233]:DEBUG: reaping dead processes 2018-01-17 16:24:32 UTC::@:[3233]:DEBUG: server process (PID 1228) exited with exit code 0 2018-01-17 16:24:32 UTC::@:[3233]:DEBUG: forked new backend, pid=1229 socket=10
On Wed, Jan 17, 2018 at 11:23 AM, caleb ayodele <[email protected]> wrote: > i set it to debug5 > > On Wed, Jan 17, 2018 at 11:20 AM, caleb ayodele <[email protected]> wrote: > >> I'm going to try setting it in the parameter group. >> >> which debug level should i set it to? debug1, debug2, debug3, debug4, >> debug5 ? >> >> On Wed, Jan 17, 2018 at 11:14 AM, caleb ayodele <[email protected]> wrote: >> >>> Ok, i was able to run query on the bucardo schema. I coundn't see it >>> because i forgot to set the search_path, but here it is. >>> >>> auth=> alter function bucardo.bucardo_delta_check ( text, text) SET >>> log_min_messages = DEBUG; >>> ERROR: permission denied to set parameter "log_min_messages" >>> >>> On Wed, Jan 17, 2018 at 11:03 AM, David Christensen <[email protected]> >>> wrote: >>> >>>> What contents are showing up in the `bucardo` schema on the source? >>>> >>>> On Jan 17, 2018, at 9:32 AM, caleb ayodele <[email protected]> wrote: >>>> >>>> [cayodele@ip-1xx-x-x-xx bucardo-master]$ bucardo validate sync >>>> auth_sync >>>> Validating sync auth_sync ... OK >>>> >>>> >>>> >>>> -- >>>> David Christensen >>>> End Point Corporation >>>> [email protected] >>>> 785-727-1171 <(785)%20727-1171> >>>> >>>> >>>> >>>> >>> >> >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
