Their are two types of vacuum in PostgreSQL – ordinary vacuum and vacuum full. In PostgreSQL dead tuple is created…
pg_tablespace_location(oid) function is used to check the path of PostgreSQL tablespace location on disk. Tablespace in postgres is the physical…
To overcome tablespace full issue, you need to add datafile to the tablespace in Oracle otherwise you may face“ORA-01658: unable…
Test Failed: IO Error: The network Adapter could not establish the connection is very generic error which you will get…
You might have faced this error while creating or deleting staza in pgBackrest. I got this error while creating stanza…
bash-4.2$ pg_restore -U appmdm-Ft -d test < test.tarpg_restore: error: corrupt tar header found in PGDMP (expected 0, computed 18703) file…
To create a role in postgres you must have createrole permission otherwise you will get error permission denied to create role while creating role in PostgreSQL
When an instance is started, Oracle Database allocates a memory area called the system global area (SGA) and starts one or more background processes.
It is easy to modify AWS RDS instance class using AWS console but in this post we will discuss about…
You cannot use the “alter system kill session” command to terminate blocking sessions in RDS Oracle instead of that you…