Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1070

Can't make decoderbufs with PostgreSQL 10.6 on CentOS 7

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • None
    • None
    • postgres-decoderbufs
    • None
    • Hide

      Installed postgres-decoderbufs from https://github.com/debezium/postgres-decoderbufs.git

      Enable the shared plugins param in the postgresql.conf

      Upon starting postgres server, it's getting crashed and getting this LOG:

      2019-01-07 09:39:56.040 UTC [8298] LOG: worker process: logical replication launcher (PID 8309) exited with exit code 1
      2019-01-07 09:39:56.041 UTC [8304] LOG: shutting down
      2019-01-07 09:39:56.054 UTC [8298] LOG: database system is shut down

      Show
      Installed postgres-decoderbufs from https://github.com/debezium/postgres-decoderbufs.git Enable the shared plugins param in the postgresql.conf Upon starting postgres server, it's getting crashed and getting this LOG: 2019-01-07 09:39:56.040 UTC [8298] LOG: worker process: logical replication launcher (PID 8309) exited with exit code 1 2019-01-07 09:39:56.041 UTC [8304] LOG: shutting down 2019-01-07 09:39:56.054 UTC [8298] LOG: database system is shut down

    Description

      Installed https://github.com/eulerto/wal2json successfully.

      Then tried to install postgres-decoderbufs:

      Ouput:
      make: Nothing to be done for `all'.
      /usr/bin/mkdir -p '/usr/pgsql-10/lib'
      /usr/bin/mkdir -p '/usr/pgsql-10/share/extension'
      /usr/bin/install -c -m 755 decoderbufs.so '/usr/pgsql-10/lib/decoderbufs.so'
      /usr/bin/install -c -m 644 .//decoderbufs.control '/usr/pgsql-10/share/extension/'

      PFB the replication related changes from pg_hba.conf:
      local replication all peer
      host replication all 172.18.0.0/16 md5
      host replication all ::1/128 md5

      PFB the changes from the postgresql.conf:
      shared_preload_libraries = 'decoderbufs,wal2json'
      wal_level = logical
      max_wal_senders = 1
      max_replication_slots = 1
      wal_keep_segments = 0

      Upon starting postgres server getting this LOG:

      2019-01-07 09:39:56.040 UTC [8298] LOG: worker process: logical replication launcher (PID 8309) exited with exit code 1
      2019-01-07 09:39:56.041 UTC [8304] LOG: shutting down
      2019-01-07 09:39:56.054 UTC [8298] LOG: database system is shut down

      When tried to run postgres by only enabling wal2json, it was up; however, as expected, postgres-connector wasn't able to communicate wth it.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              abhinabk Abhinab K (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: