How to unlock tables in Postgres?

Question

PostgreSQL

Using a dump, I transferred the Postgre database from one computer to another. After deploying the database on another PC, it turned out that Postgre does not allow editing data in the table, and all fields are marked with a "lock" sign. Tell me what did you do wrong?

Answer 1

Presumably, the PostgreSQL user you are logging into the DBMS on the new machine has not been assigned rights to tables or fields.
Access rights in PostgreSQL is a system table separate from your database, and, of course, it was not included in the dump. You need to consider dumping permissions separately.
You can use the tips at https://dba.stackexchange.com/questions/4286/list-... to determine if your user really doesn't have permissions to the tables. If it's only a matter of rights to fields, I can't tell you from memory, you need to read the PostgreSQL documentation on issuing rights to data fields.
I am not a DBMS specialist, maybe someone will tell you more detailed information later.
UPD: it was not the permissions that were dumped, but the roles/users - see melkij's answer.