DBA expertise: PostgreSQL, SQL Server & MySQL
PostgreSQL store data logically in tablespace and physically in datafilesPostgreSQL uses a tablespace to map a logical name to a physical location on disk tablespace allow the user to control the disk layout of PostgreSQLwhen we create table or any object it goes directory to data directly by default to avoid load on disk we…
table inheritance To convey the idea that child tables inherit all columns from the parent master table while also allowing child tables to have additional fields, with the ability to specify the “ONLY” keyword for queries on specific tables, you can rewrite the statement as follows: “We enable child tables to inherit all columns from…
postgresql.conf the file is located in data directory of the cluster default is located in /etc/postgresql/13/main/ check parameter of PostgreSQL inside pgSQL console the parameter you saw in the file can also be viewed in the psql console itselfto check and verified whether they enabled or not , and what is the parameter set for itfor…
${toc} installation directory layout PostgreSQL is typicality installed to /usr/lib/postgresql/the same directory structure is the same both on windows and Linux.,now we will discussed the content of installation bin folder here you will find all PostgreSQL utility files such as initdb a& bg_ctl data the folder is located in default cluster and might change depend on if there multilabel…
what is database cluster database cluster is collection of database managed by single instancedon’t get confused by cluster that tied up by high availability initdb initdb : is utility used to create database clusterinitdb create setup directory called (data directory ) where we store our data . initdb need to be installed , and once installed…
Downloading package In the realm of Red Hat, we employ RPMs (Red Hat Package Manager) as a fundamental tool. RPM files serve as the architects of software repositories, facilitating the seamless installation of software packages. The process unfolds as follows: Selecting the Operating System (OS) Version: This step is akin to choosing the foundation…