In a Cluster you can list all the databases and their sizes withe below script. I prefer one application db for a cluster generally. …
Read More »PostgreSQL
How To Give Permission To a User On PostgreSQL
In this article we will examine how to give permission to a user in PostgreSQL. You should click on the Postgres menu item for …
Read More »How to List PostgreSQL Users and Permission
In this article I will share a few scripts in postgres databases that I think will help you manage your users. The easiest way to …
Read More »How To Change PostgreSQL User Password
In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script. [crayon-67a745ea96c7b811497567/] …
Read More »How To Find PostgreSQL lib and bin Directories
We find the bin directory of PostgreSQL using the command below. [crayon-67a745ea96e2d279268112/] You can see this directory in the white box in the screen …
Read More »role “x” cannot be dropped because some objects depend on it
If you want to delete the PostgreSQL user, we can get the error “role x can not be dropped because some objects depend on …
Read More »FATAL: could not create semaphores: No space left on device
If you increase the value of the MAX_Connections parameter in the postgresql.conf file, you can get this error while starting the PostgreSQL service. You should …
Read More »FATAL: remaining connection slots are reserved for non-replication superuser connections
You will get this error when you reach the max connection count in PostgreSQL. You need to increase the max connection count in the …
Read More »How To Stop, Start, Restart and Reload PostgreSQL Service
You can do PostgreSQL service management in two ways. Generally, restart or reload is required when changes are made to the postgresql.conf file. You can …
Read More »How To Create Tablespace On PostgreSQL
We should need to create tablespace on postgresql sometimes. I recommend to create a new tablespace when you create a database. Do not use …
Read More »