치매 걸리기 전에 기록하자

2020년 12월 11일 금요일

We would like to inform you that physical replication is not possible between the EPAS 9.6.6.11 and 10.15.24.

However, logical replication like xDB is possible between the EPAS 9.6.6.11 and 10.15.24.

From v10 onwards we have logical replication in the database itself that means if you want to replica between v10 and v11 then logical replication is possible without using the tool but between v9.6 to v10 only logical replica using tools is possible.

Please refer to the below documents for more information about directions for implementing a replication system using xDB Replication Server.

https://www.enterprisedb.com/edb-docs/d/edb-postgres-replication-server/user-guides/user-guide/6.2/toc.html

https://www.enterprisedb.com/edb-docs/static/docs/eprs/6.2/EDB_Postgres_Replication_Server_Users_Guide_v6.2.pdf

2020.11.03 에 Red Hat Enterprise Linux 8.3 (RHEL 8.3) 릴리즈 되었다.

8.1 이후 거의 6개월만에 업그레이드 되었다.

뭔가 업그레이드가 되었다고 하니, 일단 다운로드 해야겠다.

https://developers.redhat.com/products/rhel/download
이곳에서 iso 를 다운로드 받을 수 있다.

https://access.redhat.com/downloads/content/479/ver=/rhel---8/8.3/x86_64/product-software
혹은 여기에서 다운로드 받을 수 있다.

해당 주소로 이동하면, 다운로드 할 수 있는 링크가 나온다.

Version	Release Date	Description	Download
8.3.0	2020-11-03	DVD iso	x86_64 (9 GB)
		Boot iso	x86_64 (682 MB)
		DVD iso	aarch64 (7 GB)
		Boot iso	aarch64 (607 MB)

이렇게 친절하게 표도 퍼왔다.

출처
https://www.redhat.com

https://korearank1.tistory.com/43

https://www.postgresdba.com/bbs/board.php?bo_table=B22&wr_id=14

http://confluence.score/pages/viewpage.action?pageId=62984313

https://www.postgresql.org/docs/current/monitoring-stats.html

https://blog.gaerae.com/2015/09/postgresql-pg-stat-activity.html

https://www.datadoghq.com/blog/collect-postgresql-data-with-datadog/

https://www.postgresql.org/docs/current/view-pg-locks.html

https://github.com/parkbyunggyu/pbg_report/blob/master/README_KOR.txt

https://americanopeople.tistory.com/293

google : postgresql row exclusive lock

https://ktdsoss.tistory.com/257

https://www.postgresql.org/about/newsarchive/

https://www.postgresql.org/docs/10/release.html

작성중

https://ktdsoss.tistory.com/251?category=544419

작성중

https://www.enterprisedb.com/postgres-tutorials/why-i-picked-postgres-over-oracle-part-i

https://www.enterprisedb.com/postgres-tutorials/why-i-picked-postgres-over-oracle-part-ii

https://www.enterprisedb.com/postgres-tutorials/why-i-picked-postgres-over-oracle-part-iii

https://www.enterprisedb.com/blog/comparing-oracle-edb-postgres

https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative