[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

[caleb ayodele]

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 at auth:[1228]:DEBUG:  StartTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  bind <unnamed> to <unnamed>
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  CommitTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at 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 at auth:[1228]:DEBUG:  StartTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  bind <unnamed> to <unnamed>
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at 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 at 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 at 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 at 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 at auth:[1228]:DEBUG:  StartTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  CommitTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  StartTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  ProcessUtility
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  CommitTransactionCommand
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at 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 at 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 at auth:[1228]:DEBUG:  SSL: write alert (0x0100)
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at auth:[1228]:DEBUG:  exit(0)
2018-01-17 16:24:32 UTC:172-4-5-57.lightspeed.rcsntx.sbcglobal.net
(48786):ticadmin at 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 at 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 <ulo23k at gmail.com> wrote:

> i set it to debug5
>
> On Wed, Jan 17, 2018 at 11:20 AM, caleb ayodele <ulo23k at gmail.com> 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 <ulo23k at gmail.com> 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 <david at endpoint.com>
>>> wrote:
>>>
>>>> What contents are showing up in the `bucardo` schema on the source?
>>>>
>>>> On Jan 17, 2018, at 9:32 AM, caleb ayodele <ulo23k at gmail.com> wrote:
>>>>
>>>> [cayodele at ip-1xx-x-x-xx bucardo-master]$ bucardo validate sync
>>>> auth_sync
>>>> Validating sync auth_sync ... OK
>>>>
>>>>
>>>>
>>>> --
>>>> David Christensen
>>>> End Point Corporation
>>>> david at endpoint.com
>>>> 785-727-1171 <(785)%20727-1171>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180117/98f35a4c/attachment-0001.html>