Skip to content

Different pg_dumpall version #10

@noizo

Description

@noizo

pglogical suppose to handle different pg versions.

I have instances with source 9.5.6 and destination with 9.6.2.

When i'm trying pgrepup check
I'm receiving

Pgrepup 0.3.7
Global checkings...
 >  Folder /tmp exists and is writable ...........................................OK
Checking Source...
 >  Connection PostgreSQL connection to 10.240.0.37:5432 with user postgres ......OK
 >  pglogical installation .......................................................OK
 >  Needed wal_level setting .....................................................OK
 >  Needed max_worker_processes setting ..........................................OK
 >  Needed max_replication_slots setting .........................................OK
 >  Needed max_wal_senders setting ...............................................OK
 >  pg_hba.conf settings .........................................................OK
 >  Local pg_dumpall version .....................................................KO
    Hint: Upgrade local PostgreSQL client utils to version 9.6.2
 >  Source cluster tables without primary keys
 >      template1 ................................................................OK
 >      postgres
 >          public.scraped_results ...............................................OK
 >          public.base_data .....................................................OK
 >          public.scraped_results_archive .......................................OK
 >          public.data_changes ..................................................OK
 >          public.alembic_version ...............................................OK
 >      nicknames
 >          public.nicknames .....................................................OK
 >          public.alembic_version ...............................................OK
 >      scorrero
 >          public.score_old .....................................................OK
 >          public.score .........................................................OK
 >          public.alembic_version ...............................................OK
 >      scraping
 >          public.scraped_results ...............................................OK
 >          public.scraped_results_archive .......................................OK
 >          public.alembic_version ...............................................OK
 >      estimato
 >          public.estimates .....................................................OK
 >          public.alembic_version ...............................................OK
 >      prospectre
 >          public.alembic_version ...............................................OK
 >          public.celery_taskmeta ...............................................OK
 >          public.scored_target_prospects .......................................OK
 >          public.organization_target_status ....................................OK
 >          public.celery_tasksetmeta ............................................OK
 >      test
 >          public.data_changes ..................................................OK
 >          public.base_data .....................................................OK
 >      email-finder
 >          public.model_sync_status .............................................OK
 >          public.alembic_version ...............................................OK
 >          public.fixed_email_patterns ..........................................OK
 >          public.email2 ........................................................OK
 >          public.metrics_email2 ................................................OK
 >          public.analytics_email2 ..............................................OK
 >          public.catch_all_domains .............................................OK
 >          public.event_log .....................................................OK
Checking Destination...
 >  Connection PostgreSQL connection to 10.240.0.54:5432 with user postgres ......OK
 >  pglogical installation .......................................................OK
 >  Needed wal_level setting .....................................................OK
 >  Needed max_worker_processes setting ..........................................OK
 >  Needed max_replication_slots setting .........................................OK
 >  Needed max_wal_senders setting ...............................................OK
 >  pg_hba.conf settings .........................................................OK
 >  Local pg_dumpall version .....................................................KO
    Hint: Upgrade local PostgreSQL client utils to version 9.6.2

Would You be so kind and take a look at that?

Maybe it is similar to #7

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions