Major Version | Kernel Version |
10 | v10.17_r1.5 |
11 | v11.12_r1.5 |
12 | v12.7_r1.5 |
13 | v13.3_r1.4 |
14 | v14.2_r1.11 |
15 | v15.1_r1.4 |
connect source with replication failed: pq: no pg_hba.conf entry for replication connection from host "xx.xx.xxx.xx", user "xxx"
occurs, the configuration of the pg_hba.conf file of the source instance does not meet migration requirements. You can add host replication all 0.0.0.0/0 md5
to the pg_hba.conf file of the source instance, and then restart the instance or execute select pg_reload_conf();
to reload the configuration.Parameter Name | Default Handling for Migration | Verification Action |
data_checksums | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
enable_partitionwise_aggregate | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
enable_partitionwise_join | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
lc_ctype | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
max_locks_per_transaction | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
max_prepared_transactions | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
random_page_cost | Use the parameter value of the source instance. | There is no alert when the parameter values are different. |
max_connections | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_wal_senders | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_worker_processes | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
array_nulls | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
authentication_timeout | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_analyze_scale_factor | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_analyze_threshold | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_freeze_max_age | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_multixact_freeze_max_age | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_naptime | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_vacuum_cost_delay | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_vacuum_cost_limit | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_vacuum_insert_scale_factor | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_vacuum_insert_threshold | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_vacuum_scale_factor | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
autovacuum_vacuum_threshold | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
bytea_output | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
check_function_bodies | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
constraint_exclusion | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
cursor_tuple_fraction | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
DateStyle | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
deadlock_timeout | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
default_statistics_target | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
default_transaction_isolation | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
exit_on_error | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
extra_float_digits | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
from_collapse_limit | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo_effort | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo_generations | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo_pool_size | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo_seed | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo_selection_bias | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
geqo_threshold | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
idle_in_transaction_session_timeout | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
idle_session_timeout | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
IntervalStyle | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
jit | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
jit_above_cost | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
jit_inline_above_cost | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
jit_optimize_above_cost | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
join_collapse_limit | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
lc_monetary | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
lc_numeric | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
lc_time | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
local_preload_libraries | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
log_filename | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_logical_replication_workers | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_parallel_workers | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_replication_slots | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_standby_archive_delay | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
max_standby_streaming_delay | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
recursive_worktable_factor | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
search_path | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
statement_timeout | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
stats_fetch_consistency | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
TimeZone | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_cost_delay | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_cost_limit | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_cost_page_dirty | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_cost_page_hit | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_cost_page_miss | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_freeze_min_age | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_freeze_table_age | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_multixact_freeze_min_age | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
vacuum_multixact_freeze_table_age | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
wal_level | Use the parameter value of the target instance. | There is an alert for the user to modify the parameter when parameter values are different. If the parameter is not modified, the default handling method for the migration will be adopted. |
Was this page helpful?