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 |
16 | v16.0_r1.2 |
connect source with replication failed: pq: no pg_hba.conf entry for replication connection from host "xx.xx.xxx.xx", user "xxx", it indicates that the configuration of the pg_hba.conf file on the source instance does not meet the migration requirements. To resolve this, add the configuration host replication all 0.0.0.0/0 md5 to the pg_hba.conf file on the source instance, and then either restart the instance or execute select pg_reload_conf(); to reload the configuration.Parameter Name | Default Migration Handling | Validation Action |
data_checksums | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
enable_partitionwise_aggregate | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
enable_partitionwise_join | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
lc_ctype | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
max_locks_per_transaction | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
max_prepared_transactions | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
random_page_cost | Use the source instance parameter value. | No alert when parameter values are inconsistent. |
max_connections | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_wal_senders | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_worker_processes | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
array_nulls | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
authentication_timeout | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_analyze_scale_factor | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_analyze_threshold | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_freeze_max_age | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_multixact_freeze_max_age | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_naptime | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_vacuum_cost_delay | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_vacuum_cost_limit | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_vacuum_insert_scale_factor | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_vacuum_insert_threshold | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_vacuum_scale_factor | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
autovacuum_vacuum_threshold | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
bytea_output | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
check_function_bodies | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
constraint_exclusion | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
cursor_tuple_fraction | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
DateStyle | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
deadlock_timeout | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
default_statistics_target | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
default_transaction_isolation | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
exit_on_error | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
extra_float_digits | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
from_collapse_limit | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo_effort | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo_generations | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo_pool_size | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo_seed | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo_selection_bias | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
geqo_threshold | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
idle_in_transaction_session_timeout | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
idle_session_timeout | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
IntervalStyle | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
jit | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
jit_above_cost | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
jit_inline_above_cost | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
jit_optimize_above_cost | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
join_collapse_limit | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
lc_monetary | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
lc_numeric | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
lc_time | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
local_preload_libraries | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
log_filename | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_logical_replication_workers | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_parallel_workers | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_replication_slots | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_standby_archive_delay | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
max_standby_streaming_delay | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
recursive_worktable_factor | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
search_path | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
statement_timeout | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
stats_fetch_consistency | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
TimeZone | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_cost_delay | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_cost_limit | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_cost_page_dirty | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_cost_page_hit | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_cost_page_miss | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_freeze_min_age | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_freeze_table_age | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_multixact_freeze_min_age | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
vacuum_multixact_freeze_table_age | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
wal_level | Use the target instance parameter value. | Alert the user to modify when parameter values are inconsistent. If not modified, adopt the default migration handling method. |
Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários