Introduction to Replication in PostgreSQL Introduction to Replication:- Replication refers to the process of copying modifications in data from the Primary database to the Standby database. Both these databases are usually located on different physical servers and help in distributing various types of database queries. Replication is implemented in PostgreSQL using a master-slave […]
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 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 […]
Recent Comments