postgresql: how to reset forgotten postgres password
Everything flows and changes, and sometimes is forgotten over time. …
postgresql: how to reset forgotten postgres password Read More »
postgresql
postgresql: Could not open file “pg_clog/0000”: No such file or directory
I am getting the error like following while accessing a …
postgresql: Could not open file “pg_clog/0000”: No such file or directory Read More »
postresql: move data directory to another location
Databases grow over time, sometimes outgrowing the space on their …
postresql: move data directory to another location Read More »
how to upgrade postgresql 11 to 12 using pg_upgradecluster
We assume that we have version PostgreSQL v 11 server …
how to upgrade postgresql 11 to 12 using pg_upgradecluster Read More »
how to install PostgreSQL 12 on Ubuntu / Debian 10,11
Step 1: Update system It is recommended to update your …
how to install PostgreSQL 12 on Ubuntu / Debian 10,11 Read More »
High reliability PostgreSQL cluster based on Patroni, Haproxy, Keepalived
Recently I faced a task: to configure the most reliable …
High reliability PostgreSQL cluster based on Patroni, Haproxy, Keepalived Read More »
How to change Porstgresql default password
Switch to user root Login to psql using the postgres …
How to create Dblink between Oracle & PostgreSQL
One of our databases was migrated from Oracle to Postgresql, …
How to create Dblink between Oracle & PostgreSQL Read More »
how to restore postgreSQL database with template using pg_dump
Import a PostgreSQL database dump There are two ways to …
how to restore postgreSQL database with template using pg_dump Read More »