In this new article about PostgreSQL database, we will upgrade our PostgreSQL. I am using a CentOS Linux 9, aarch64 architecture. My environment is single database and server. I am not using clusters environments or features as well. I am using PostgreSQL, version 13. Let’s check it. Connected on Linux with postgres user, execute psql … Mais Upgrading PostgreSQL on CentOS Linux 9

On this second article regarding PostgreSQL Database, I will show which files should be edited to enable remote connection with PostgreSQL. First file to be edit is postgresql.conf, commonly found under data directory: Open the file and edit listen_addresses parameter. Uncomment line parameter and change value for asterisk ‘*’ to be possible connect for anywhere. … Mais How To Configure Remote Connection With PostgreSQL

On this my first article talking about PostgreSQL Database, I will describe how to install a PostgreSQL on CentOS Linux 9. I am using a CentOS aarch64 processor version, installed on VMWare Fusion. We will create a disk to store data and others files for PostgreSQL, to isolate database files of operational systems files. Below, … Mais How To Install PostgreSQL on CentOS Linux 9