![]() ![]() ![]() We have taken a backup of logical backup using pg_dump or pg_dumpall command and physical backup using a pg_basebackup or from third-party tools like pgBackRest etc.PostgreSQL backup mainly divided into two types.The backup policy will be defined as per Full, Incremental and differential basis. ![]() To avoid data loss, we need to take backup as per backup policy.If we have a backup of data, and suddenly our database will crash, there will be chances of data loss.As per PostgreSQL administration, we need to take a backup of the database as per policy to avoid any loss of data.In PostgreSQL, Postgres is a superuser this user has all privileges to access the database.Superuser privileges are not given to any other users. As per standard guidelines, it is mandatory to give appropriate privileges to every user.If we give inappropriate privileges to the user, then it will happen that data will be misused.Roles and user management are very important in PostgreSQL to provide appropriate access to each and every user.If we do not administer our database, then it will access from the unauthenticated user.The main need for PostgreSQL administration is to authenticate the database from unauthorized access.The role does not have default login privileges, whereas the user has default login privileges to the database. In PostgreSQL, roles and users play essential functions.Hadoop, Data Science, Statistics & others
0 Comments
Leave a Reply. |