IOTN :: Field Book :: PostgreSQL

ȸ¿ø°¡ÀÔ

psql HA

ÃÖ±æÈ£ [LIST]   2023-02-05 08:24:22, Á¶È¸ : 558 psql HA ±¸Ãà ##  master ------------------------------------------------ vi $PGDATA/postgresql.conf listen_addresses =  '*' vi $PGDATA/postgresql.auto.conf wal_level = hot_standby max_wal_senders = 2 # +1 grep 127 $PGDATA/pg_hba.conf host    replication     all             127.0.0.1/32            trust CREATE ROLE replication WITH REPLICATION PASSWORD 'postgrespwd' LOGIN; alter user postgres password 'postgrespwd'; ##  slave ------------------------------------------------ export PGDATA=/home/postgres/ha rm -rf /home/postgres/ha/* pg_basebackup -h localhost -D /home/postgres/ha -U replication -v -P -X stream chmod 750 $PGDATA ## standby_mode º¯°æ to $PGDATA/standby.signal touch $PGDATA/standby.signal touch $PGDATA/recovery.signal ## $PGDATA/recovery.conf ## recovery.conf Á¦°Å to recovery.signal , standby.signal ## FATAL:  using recovery command file "recovery.conf" is not supported vi $PGDATA/postgresql.auto.conf hot_standby = 'on' hot_standby_feedback = 'on' port = 5433 ## standby_mode = 'on' ## LOG:  unrecognized configuration parameter "standby_mode" primary_conninfo='host=localhost port=5432 user=replication password=postgrespwd' #promotion_trigger_file= tail -f $PGDATA/log/postgresql-Sun.log export PGDATA=/home/postgres/ha pg_ctl start psql -p 5433 ## pg_controldata master pg_controldata -D $PGDATA | grep clu Database cluster state:               in production slave pg_controldata -D /home/postgres/ha | grep clu Database cluster state:               in archive recovery ## master postgres=# select usename,client_addr,state,sync_state,reply_time from pg_stat_replication;    usename   | client_addr |   state   | sync_state |          reply_time           -------------+-------------+-----------+------------+------------------------------- replication | 127.0.0.1   | streaming | async      | 2023-02-06 09:59:00.812877+09 (1 row) ## slave postgres=# select sender_host,status,latest_end_time from pg_stat_wal_receiver; sender_host |  status   |        latest_end_time         -------------+-----------+------------------------------- localhost   | streaming | 2023-02-06 09:52:07.390205+09 216.73.216.248

LIST

CategoryAdminTroubleshoot	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Admin	write db log msg	ÃÖ±æÈ£	2025/04/07	7
Admin	CentOS 5 ¼³Ä¡ °¡´É psql 11.22 ¼³Ä¡	ÃÖ±æÈ£	2024/11/21	9
Admin	ERROR: permission denied: "RI_ConstraintTrigger_331308" is a system trigger / violates foreign key constraint	ÃÖ±æÈ£	2024/10/28	22
Admin	³¯Â¥ ¼ýÀÚ date unix epoch	ÃÖ±æÈ£	2024/09/02	11
Admin	pg_backup_start / pg_backup_stop / psql ¼¼¼Ç À¯Áö / WARNING: aborting backup due to backend exiting before pg_backup_stop was called	ÃÖ±æÈ£	2023/12/21	69
Admin	psql 10.7 oracle dblink [ oracle_fdw db link ]	ÃÖ±æÈ£	2023/07/25	75
Admin	HA º¹±¸ test	ÃÖ±æÈ£	2023/03/03	1866
Admin	log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump ¹é¾÷½Ã ¹ß»ý	ÃÖ±æÈ£	2023/03/03	50
Admin	requested timeline x is not a child of this server's history	ÃÖ±æÈ£	2023/03/02	63
Admin	recovery_target_action / archive log ¹Þ¾Æ¼­ °è¼Ó º¹±¸	ÃÖ±æÈ£	2023/02/28	66
Admin	recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();	ÃÖ±æÈ£	2023/02/27	53
Admin	memory buffer cache	ÃÖ±æÈ£	2023/02/06	47
Admin	active session, pid, lock sql , kill pid / pg_terminate_backend	ÃÖ±æÈ£	2023/02/06	121
Admin	psql HA	ÃÖ±æÈ£	2023/02/05	558
Admin	pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |	ÃÖ±æÈ£	2023/02/03	81

¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö

1 [2][3][4][5][6][7][8]

Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)