postgresqlpgadminpgadmin-4
Unable to connect to postgresql with pgAdmin4: readonly attribute error
I have a local postgresql 10 server (tested the same on 9.6, don't think it's related to the DB at all, only to pgAdmin4, as pgAdmin3 works just fine)
As in the screenshot, I am trying to connect to the localhost db with user postgres on a fresh installation, but I keep receiving this message:
readonly attribute
I searched everywhere for this error, but couldn't find any useful solutions or workarounds
Solution
pg4Admin 4 now is working for me. I got an update of python-psycopg2 to 2.7.4-1.pgdg16.04+1 amd64 version on my KDE Neon, that solved, to me, the readonly attribute problem.
- Rails 4 scope NOTNULL refactor
- Select on self-referencing table where all chains meet a condition
- In a join, fields with null values are not getting shown but in normal query they are
- Install pgAgent on AWS RDS for Postgres
- Spring JBDC bad SQL grammar on PostgreSQL
- Using IF in function for different queries as a result
- Variables in looping condition in a postgreSQL while loop
- SQL query for returning rows with only certain values in list but not others?
- How to insert data into a code-first database with a SQL script?
- How do I insert a record into a Postgres DB based off the MAX of one column?
- Pyspark JDBC read with partitions
- Quarkus dev postgresql container not shutting down with quarkus
- Permission issue with PostgreSQL in docker container
- Starting application development using Docker or configuring Docker during development?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- postgresql - replace all instances of a string within text field
- migrate data from MS SQL to PostgreSQL?
- How to change the select output delimeter from '|' to ',' on Postgres through command line?
- Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
- Psycopg2: how to deal with special characters in password?
- SET CONSTRAINTS ALL DEFERRED not working as expected
- Postgres container doesn't start
- How do you find the row count for all your tables in Postgres
- Alter column ignoring dependent views
- Recursive CTE 'Query Error: relation [] does not exist', PostgreSQL v17
- How to view Oldest Query results in Azure Monitor Metrics for an Azure PostgreSQL Flex Server instance
- Insert literal '${value}' without variable substitution into PostgreSQL table from DBeaver
- How should I set my DATABASE_URL?
- How can I use composite primary keys in django?
- How to switch databases in psql?