postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
postgresql [2024/06/30 17:53] – [Interesting sites] adminpostgresql [2024/08/04 02:07] (current) – [Postgresql] admin
Line 1: Line 1:
 ====== Postgresql ====== ====== Postgresql ======
 <code PYTHON>  <code PYTHON> 
 +
 +psql -h 192.168.1.100 -p 5432 -U u1 mydatabase
 +
 +
 import psycopg2 import psycopg2
 conn = psycopg2.connect("host='10.59.1.50' dbname='DB' user='perm' password='perm'") conn = psycopg2.connect("host='10.59.1.50' dbname='DB' user='perm' password='perm'")
Line 751: Line 755:
  
   *  shared memory no space left https://medium.com/@tough_jonquil_dog_815/postgresql-no-space-left-on-device-a9c5c3b41cff   *  shared memory no space left https://medium.com/@tough_jonquil_dog_815/postgresql-no-space-left-on-device-a9c5c3b41cff
 +  * docker shared memory https://www.instaclustr.com/blog/postgresql-docker-and-shared-memory/
  
 ==== Postgres.DBA locale collation LC_COLLATE setlocale==== ==== Postgres.DBA locale collation LC_COLLATE setlocale====
Line 1222: Line 1227:
   * Wal-g - https://habr.com/ru/post/506610/ - пример   * Wal-g - https://habr.com/ru/post/506610/ - пример
   * пример ручного dump c WAL https://pgdash.io/blog/postgres-incremental-backup-recovery.html   * пример ручного dump c WAL https://pgdash.io/blog/postgres-incremental-backup-recovery.html
 +  * пример pg_backup <https://stormatics.tech/blogs/postgresql-physical-backups-using-pg_basebackup-a-comprehensive-guide>
  
 === Wal-g.Backup статьи === === Wal-g.Backup статьи ===
  • postgresql.1719770029.txt.gz
  • Last modified: 2024/06/30 17:53
  • by admin