치매 걸리기 전에 기록하자: postgresql

레이블이 postgresql인 게시물을 표시합니다. 모든 게시물 표시

2020년 12월 11일 금요일

Can we make a replica between the EPAS 9.6.6.11 and 10.15.24?

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년 9월 14일 월요일

PostgreSQL table size, tablespace size, index size

https://korearank1.tistory.com/43

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

2020년 9월 11일 금요일

PostgreSQL Monitoring(모니터링)

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

PostgreSQL release(릴리즈), news(소식)

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

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

PostgreSQL pg_dump

작성중

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

2020년 9월 9일 수요일

Why I picked Postgres over Oracle

작성중

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

PostgreSQL Partitioning

작성중

https://vimeo.com/400214981

https://www.slideshare.net/EnterpriseDB/the-truth-about-partitioning?ref=

https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/database-compatibility-for-oracle-developers-guide/9.5/Database_Compatibility_for_Oracle_Developers_Guide.1.341.html

2020년 9월 7일 월요일

PostgreSQL Tuple, 성능, vacuum (1)

작성중

postgresql cache hit rate

https://ianstream.github.io/2017-11-01-Postgres-성능-이해하기

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

https://dba.stackexchange.com/questions/103421/the-cache-hit-rate-using-pg-statio-user-tables/103442

https://gist.github.com/mmattozzi/5417191

https://dbguide.tistory.com/entry/튜플Tuple-과-백쿰VACUUM

https://linux.systemv.pe.kr/튜플tuple-과-백쿰vacuum

http://boring-text.blogspot.com/2019/05/postgresql-dead-tuple.html

https://postgresql.kr/blog/postgresql_table_bloating.html

https://blog.naver.com/PostView.nhn?blogId=anytimedebug&logNo=221323992204

PostgreSQL user, role, grant

작성중

postgres add user to group

postgresql grant table

https://www.postgresql.org/docs/11/sql-altergroup.html

https://www.postgresql.org/docs/11/role-membership.html

https://www.postgresql.org/docs/11/sql-grant.html

2020년 9월 4일 금요일

PostgreSQL TOAST(The Oversized-Attribute Storage Technique)

작성중

https://data-rider.blogspot.com/2015/07/postgresql-toast.html

https://www.postgresql.org/message-id/fa0a390a-ffbd-8da9-373a-1b981063ca4d%40commandprompt.com

https://stackoverrun.com/ko/q/11562969

https://dba.stackexchange.com/questions/264691/understanding-where-pg-toast-is-coming-from

https://www.it-swarm.dev/ko/postgresql/pgtoast-%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84-%EC%B6%95%EC%86%8C%ED%95%98%EB%8A%94-%EB%B0%A9%EB%B2%95/1051689818/

http://postgresdesk.blogspot.com/p/an-example-of-getting-pgtoast.html

https://www.postgresql.org/docs/11/storage-toast.html

PostgreSQL idle_in_transaction_session_timeout

작성중

https://www.postgresql.org/docs/9.6/runtime-config-client.html

https://postgresqlco.nf/en/doc/param/idle_in_transaction_session_timeout/

PostgreSQL temp_tablespaces

작성중

http://blog.naver.com/geartec82/221739989660

https://postgresql.kr/docs/9.6/manage-ag-tablespaces.html

https://www.enterprisedb.com/edb-docs/d/postgresql/reference/manual/11.0/runtime-config-client.html#GUC-TEMP-TABLESPACES

https://blog.dbi-services.com/about-temp_tablespaces-in-postgresql/

https://www.postgresql.org/docs/11/manage-ag-tablespaces.html

https://stackoverflow.com/questions/16713229/postgresql-doesnt-use-temp-tablespace

https://postgresqlco.nf/en/doc/param/temp_tablespaces/

2020년 7월 17일 금요일

PostgreSQL 모니터링

https://www.opsdash.com/blog/postgresql-backup-restore.html

https://pgdash.io/

https://grafana.com/grafana/plugins/postgres

https://grafana.com/docs/grafana/latest/features/datasources/postgres/

https://grafana.com/grafana/dashboards/9628

https://grafana.com/grafana/dashboards/455

https://miiingo.tistory.com/93

https://semode.tistory.com/6
https://www.solarwinds.com/ko/database-performance-monitor/integrations/postgres-monitoring
https://blog.gaerae.com/2015/09/postgresql-pg-stat-activity.html
https://www.postgresql.org/docs/11/monitoring-stats.html
https://ktdsoss.tistory.com/257
https://americanopeople.tistory.com/293
https://www.postgresql.org/docs/9.3/view-pg-locks.html
http://confluence.score/pages/viewpage.action?pageId=108452045
https://www.datadoghq.com/blog/postgresql-vacuum-monitoring

PostgreSQL HA 구성

https://browndwarf.tistory.com/4

https://aws.amazon.com/ko/blogs/korea/failover-with-amazon-aurora-postgresql

https://docs.aws.amazon.com/ko_kr/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html

https://cloud.hosting.kr/techblog_180717_failover-postgresql

https://postgresql.kr/blog/postgresql_incident_response.html

https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql

https://www.percona.com/blog/2019/10/11/how-to-set-up-streaming-replication-in-postgresql-12

https://www.scalingpostgres.com/tutorials/postgresql-streaming-replication

https://www.citusdata.com/blog/2019/05/30/introducing-pg-auto-failover

https://www.postgresql.org/docs/current/warm-standby.html

https://www.2ndquadrant.com/en/blog/evolution-fault-tolerance-postgresql-synchronous-commit

PostgreSQL pg_basebackup 사용 방법

(작성 중)

https://blog.sleeplessbeastie.eu/2016/02/15/how-to-perform-base-postgresql-backup-using-pg_basebackup-utility/

https://www.percona.com/blog/2018/12/21/backup-restore-postgresql-cluster-multiple-tablespaces-using-pg_basebackup/

https://www.highgo.ca/2020/04/30/how-to-backup-multiple-tablespaces-with-pg_basebackup/

https://m.blog.naver.com/PostView.nhn?blogId=iyagi15&logNo=10144404469

https://www.postgresdba.com/bbs/board.php?bo_table=P01&wr_id=406

https://github.com/zalando/patroni/issues/671

https://www.cybertec-postgresql.com/en/pg_basebackup-creating-self-sufficient-backups/

https://stackoverrun.com/ko/q/10974904

2020년 7월 13일 월요일

PostgreSQL source code 문서 (by Doxygen)

Doxygen은 source code를 문서화 하는 도구이다.

Doxygen은 source code를 기반으로 문서를 생성하기 때문에, 문서를 최신 상태로 유지할 수 있다.

그리고 문서와 source code를 서로 연결되어 있어서, 실제 source code를 쉽게 참조할 수 있다.

https://doxygen.postgresql.org/index.html
이곳에 가면 source code를 살펴볼 수 있다.

계층적인 구조로 되어 있으므로, 한단계씩 내려가면서 살펴보면 된다.

샘플을 하나 찍어 본다면.....
PostgreSQL은 Post Master 에서부터 시작되므로.....
https://doxygen.postgresql.org/postmaster_8c.html

각 함수들의 호출 관계도 그림으로 나타내주고,
source code 내용들이 보인다.