cabecada

contains unexpected zero page at block 35651600
adjust=# select pg_relation_filepath('indexname');
               pg_relation_filepath               
--------------------------------------------------
 pg_tblspc/5392705/PG_12_201909212/114783/5412650

ls -lrt pg_tblspc/5392705/PG_12_201909212/114783/5412650\.* | wc -l
473
there are 473 chunks of 1GB files for the index.
to calculate blocks we first see how many blocks are there in each chunk i.e

cabecada

primary : 192.168.64.11
replica : 192.168.64.12

cat /etc/haproxy/haproxy.cfg
global
    maxconn 100
    stats socket ipv4@127.0.0.1:9999 level admin
    stats socket /var/run/haproxy.sock mode 666 level admin
    stats timeout 2m
    external-check

cabecada

postgres@demo:~/temp$ psql -p 5432 -h 127.0.0.1 -d postgres -U postgres -c 'select pg_is_in_recovery();'
 pg_is_in_recovery 
-------------------
 f
(1 row)

postgres@demo:~/temp$ psql -p 5433 -h 127.0.0.1 -d postgres -U postgres -c 'select pg_is_in_recovery();'
 pg_is_in_recovery 
-------------------
 t

cabecada

root@demo:~# cat /opt/pgsqlchk1
#!/usr/bin/bash

export PGPASSWORD="1234"


VALUE=`timeout 5 /usr/bin/psql -t -d postgres -h 127.0.0.1 -U postgres -p 5432 -c 'select not pg_is_in_recovery()' 2>/dev/null`
rc=$?

if [ $rc -eq 0 ]

cabecada

root@demo:~# cat /etc/haproxy/haproxy.cfg 
global
    maxconn 100

defaults
    log global
    mode tcp
    retries 2
    timeout client 30m
    timeout connect 4s

cabecada

cybertec-postgresql.com/en/pgbouncer-authentication-made-easy/

apt-get install postgresql pgbouncer

sudo su - postgres

psql << EOF
CREATE ROLE pgbouncer LOGIN;
-- set a password for the user
\password pgbouncer

cabecada

# reference https://www.cybertec-postgresql.com/en/cancel-hanging-postgresql-query/

postgres@db1:~$ pg_config --libdir
/opt/postgresql/postgresql-14.3/lib
postgres@db1:~$ cat loop.c
#include "postgres.h"
#include "fmgr.h"
 
#include <unistd.h>
 

cabecada

    1  apt-get install libpython3-dev
    2  apt-get install libtcl-dev
    3  apt-get install gdb
    4  apt-get install linux-tools-common 
    9  apt-get install libipc-run-perl libipc-run3-perl
    3  wget https://ftp.postgresql.org/pub/source/v14.3/postgresql-14.3.tar.bz2
    4  sudo apt-get install gcc
    5  apt-get install gcc libreadline-dev zlib1g-dev
    6  perl -v
   10  groupadd -g 54321 dba

cabecada

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

cabecada

root@ubuntu-linux-20-04-desktop:~# cat /etc/haproxy/haproxy.cfg 
#---------------------------------------------------------------------
# Global settings
#---------------------------------------------------------------------
global
    description PostgreSQL Database HAProxy Stats page
    log 127.0.0.1 local0 info
    chroot      /var/lib/haproxy
    pidfile     /var/run/haproxy.pid
    maxconn     3000