For ADMINISTRATION articles under category POSTGRESQL.
PostgreSQL Architecture – Memory Components In this post we will discuss Memory Components of PostgreSQL, Memory Components in PostgreSQL can be divided mainly into two category memory region 1). Shared Memory 2). Process Memory or Backend Memory Shared Memory Shared Memory: Shared Memory refers to the memory reserved for database caching and transaction log caching.
Configure another instance of PostgreSQL and administer using systemctl In the previous post, we saw How to Install PostgreSQL 13 on Linux Using YUM Command. In this blog, we will create another PostgreSQL Server in the same machine and will register the database server in systemctl system manager for easy management. Step 1. Verify first
Schema in PostgreSQL In PostgreSQL, a schema is a namespace that contains database objects such as tables, views, indexes, data types, functions, stored procedures. A database can contain one or multiple schemas and each schema belongs to only one database. PostgreSQL automatically creates a public schema for every new database. Whatever DB objects are created
Create, Drop, Alter Roles in PostgreSQL PostgreSQL represents accounts as roles. PostgreSQL uses roles to represent user accounts. It doesn’t use the user concept like other database systems Oracle & MySql. Roles that can log in are called login roles. When roles contain other roles, they are called group roles. When you create a role,
How To Load PostgreSQL Sample Database In this tutorial, we will see How to load the PostgreSQL sample database into the PostgreSQL server. In this demonstration, we will see two methods to restore: 1). Using pg_restore command utility 2). Using pgAdmin Graphics Tool Load the sample database using psql (pg_restore) tool Step 1. Download sample
How to Install pgAdmin (Graphical Interface tool) on Windows 10 in PostgreSQL In the previous blog, we saw How to Install PostgreSQL 13 on Linux, Click here to read more. We can use a command-line utility called psql to administer PostgreSQL Server. But if you want you can install a graphical tool called pgAdmin. This
Enable Remote Connection on PostgreSQL In the previous blog, we saw How To Install PostgreSQL 13 on Linux. Click here to read more. By default, PostgreSQL installation is operating through a socket on the localhost. So remote connection will not work, To make it work we need to enable remote connection in couple of configuration
Install PostgreSQL 13 on Linux Using YUM Command In this blog, we will see How to download and install PostgreSQL 13 on Oracle Linux Server release 7.9. You can get all required commands to install PostgreSQL on Linux from PostgreSQL documentation. Click here to download/follow the steps for PostgreSQL 13 on Linux. Once click on
