Install Postgresql and Pgpool

-

PostgreSQL packages for Debian and Ubuntu. PostgreSQL is an open-source, object-relational database system with a strong reputation for feature robustness, extensibility, and compliance with technical standards.

Currently, PostgreSQL support:

  • Debian 9 (stretch), 10 (buster), 11 (bullseye), 12 (bookworm), and unstable (sid)
  • Ubuntu 18.04 (bionic), 20.04 (focal), 21.10 (impish, amd64 only), 22.04 (jammy)
  • Architectures: amd64 (64-bit x86), i386 (32-bit x86, being phased out), arm64 (64-bit ARM), ppc64el (little-endian 64-bit POWER)
  • PostgreSQL 10, 11, 12, 13, 14, 15 devel
  • Server extensions such as Slony-I, various PL languages, and datatypes
  • Applications like omnidb, pgbouncer, and pgpool-II

Import the repository key from https://www.postgresql.org/media/keys/ACCC4CF8.asc

# https://wiki.postgresql.org/wiki/Apt
sudo apt-get install curl ca-certificates gnupg
curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg >/dev/null
Create /etc/apt/sources.list.d/pgdg.list.

The distributions are called codename-pgdg.
You may determine the codename of your distribution by running lsb_release -c.
In the example, replace buster with the actual distribution you are using File contents:

deb http://apt.postgresql.org/pub/repos/apt buster-pgdg main

For a script version of the above file creation, presuming you are using a supported release:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Finally, update the package lists, and start installing packages:

# Replace 14 with postgresql-10, 11, 12, 13, 14 to install desired
sudo apt update
sudo apt install postgresql-14 postgresql-contrib libpq-dev
# OR WITH PGPOOL
sudo apt install postgresql-14-pgpool2 postgresql-contrib libpq-dev
# To install PGPOOL2
sudo apt install pgpool2

Pgpool-II only accepts connections from the local host enbaled using port in my case 5433. If we wish to receive connenctions from other hosts, set listen_addresses to ‘*’.

vim /etc/pgpool2/pgpool.conf
# change the next lines
listen_addresses = '*'
port = 5433

DONE! ))

Comments

Post a Comment

Popular posts from this blog

Installing the Certbot Let’s Encrypt Client for NGINX on Amazon Linux 2

-
Image
Installing the Certbot Let’s Encrypt Client The certbot package is not available through the package manager by default. You will need to enable the  EPEL  repository to install Certbot. sudo yum install epel-release sudo yum install certbot-nginx Set Up NGINX certbot  can automatically configure  NGINX  for SSL/TLS. It looks for and modifies the server block in your  NGINX  configuration that contains a server_name directive with the domain name you’re requesting a certificate for. In our example, the domain is  www.mydomain.com . Assuming you’re starting with a fresh NGINX install, use a text editor to create a file in the  /etc/nginx/conf.d  directory named  domain_name.conf  (so in our example, www.mydomain.com.conf). Specify your domain name (and variants, if any) with the  server_name  directive: server { listen 80 default_server; listen [::]:80 default_server; root /var/www/html; server_name myd...
Read more

Deploy Nuxt.js app using Apache 2

-
  Deploy your dynamic Nuxt.js app Nuxt.js is an amazing server side rendering application framework for Vue.js. In this article we will see how to deploy Nuxt.js application to AWS instance in universal app mode. Where in Nuxt.js you can choose between Universal, Static Generated or Single Page application. Before we start deploying our dynamic app, if you want just to deploy a static website, you can run this command: npm run generate and it will generate the files and put them in  dist  folder which you can upload to any server you want. But this will not work for universal apps. 1. Build your app To build a ssr app you need to run the following command: npm run build The generated files will not be in the  dist  folder as for the static app, but you can find all generated files in  .nuxt  folder which will be the entry point. 2. Upload to the server There are two ways to do this upload your whole application with the source code or just upload the n...
Read more

psql: error: connection to server at "localhost" (127.0.0.1), port 5433 failed: ERROR: failed to authenticate with backend using SCRAM DETAIL: valid password not found

-
Image
ERROR psql: error: connection to server at "localhost" (127.0.0.1), port 5433 failed: ERROR: failed to authenticate with backend using SCRAM DETAIL: valid password not found Since Pgpool-II is a PostgreSQL proxy that works between clients and PostgreSQL servers, the authentication comprises two steps: Authentication between client and Pgpool-II Authentication between Pgpool-II and PostgreSQL servers Starting with Pgpool-II 4.0, Pgpool-II supports scram-sha-256 authentication. scram-sha-256 authentication method is strongly recommended because it is the most secure password-based authentication method. Solution 1 If PostgreSQL servers require  MD5  or  SCRAM  authentication for some user’s authentication but the password for that user is not present in  pool_passwd , then enabling  allow_clear_text_frontend_auth  will allow the  Pgpool-II  to use clear-text-password authentication with user to get the password in plain text form from the user ...
Read more