In this article, we will see How to find the error log location in PostgreSQL on Windows or Linux environments.
We can get the error log location by running the command log_directory command in psql shell. Continue reading How to find the error log location in PostgreSQL on Windows or Linux environments
In this article, we will see the solution for AWS RDS PostgreSQL connectivity from pgadmin.
Error saving properties Unable to connect to server: timeout expired
In this article, we will the solution for PostgreSQL Error: database is being accessed by other users
Detail: There are 2 other sessions using the database
Continue reading PostgreSQL Error: database is being accessed by other users
In this article, we find the solution for the “PostgreSQL Error must be member of role”.
This error occurred when using CREATE DATABASE in Amazon RDS. When using Amazon RDS, the user issuing the CREATE DATABASE must be a member of the role that will be the owner of the database.
Continue reading PostgreSQL Error must be member of role
In this article, we will see the solution for ERROR: syntax error at or near “VARCHAR”.
Reolution: Continue reading PostgreSQL ERROR: syntax error at or near “VARCHAR”
In this article, we will see the cause and solution for “PostgreSQL ERROR: could not open extension control file”.
Continue reading PostgreSQL ERROR: could not open extension control file
In this article, we will see solution for “ERROR: permission denied for table ‘table_name’ in PostgreSQL”
Reason: User doent have permissions to access that particular table or relation or view.
Continue reading ERROR: permission denied for table ‘table_name’ in PostgreSQL
In this article, we will see the solution for error like PostgreSQL Error: cannot execute in a read-only transaction.
ERROR: cannot execute CREATE DATABASE in a read-only transaction Error: cannot execute DROP DATABASE in a read-only transaction ERROR: cannot execute CREATE TABLE in a read-only transaction Error: cannot execute DROP TABLE in a read-only transaction cannot execute INSERT in a read-only transaction
Reason: Continue reading PostgreSQL Error: cannot execute in a read-only transaction
I have received following error when trying to connect to PostgreSQL server.
psql: error: FATAL: role is not permitted to log in
Continue reading psql: error: FATAL: role is not permitted to log in
We are going to see the solution for “PostgreSQL ERROR: role cannot be dropped because some objects depend on it”
ERROR: role "james" cannot be dropped because some objects depend on it DETAIL: owner of database emp 6 objects in database r2schools 1 object in database postgres 3 objects in database newdb 3 objects in database emp
Solution:
Continue reading PostgreSQL ERROR: role cannot be dropped because some objects depend on it
