github/databasus
1
1
Fork 0
mirror of https://github.com/databasus/databasus.git synced 2026-04-06 00:32:03 +02:00
Code Issues 3 Packages Projects Releases Wiki Activity

Access problem after Postgres restore #253

New Issue
Closed
opened 2026-04-05 16:16:03 +02:00 by MrUnknownDE · 0 comments
MrUnknownDE commented 2026-04-05 16:16:03 +02:00
Owner
Copy Link

Originally created by @Rigel772 on 1/11/2026

After restoring Postgres database I am getting

2026-01-11 17:16:51.301 CET [150] ERROR:  permission denied for schema auth

2026-01-11 17:16:51.301 CET [150] STATEMENT:  LOCK TABLE auth.users, core.comments, core.doc_pages, core.doc_pages_doc_parts_link, core.doc_parts, core.docs, core.docs_doc_pages_link, core.docs_doc_parts_link, core.email_types, core.emails, core.files, core.job_tasks, core.job_templates, core.jobs, core.jobs_objects_association, core.journal_entries, core.notices, core.object_systems, core.object_types, core.objects, core.objects_object_systems_association, core.offers, core.orgs, core.orgs_admins_association, core.orgs_users_association, core.poll_options, core.poll_votes, core.polls, core.problems, core.problems_objects_association, core.proposal_user_votes, core.proposals, core.proposals_jobs_association, core.proposals_objects_association, core.user_email_preferences, core.user_profiles, core.users_emails_association, core.variants, crm.addresses, crm.contacts, crm.contrahents, crm.contrahents_addresses_association, crm.contrahents_contacts_association, crm.contrahents_objects_association, crm.contrahents_orgs_association, crm.contrahents_types_association, crm.profiles, crm.types, money.acc_groups, money.accounting_periods, money.milage_tresholds, money.org_accounts, money.org_splits, money.org_transactions, money.tpl_accounts, money.tpl_sets, money.tpl_splits, money.tpl_transactions, money.trips, public.alembic_version IN ACCESS SHARE MODE

2026-01-11 17:17:06.967 CET [152] ERROR:  permission denied for schema core

2026-01-11 17:17:06.967 CET [152] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:17:07.263 CET [153] ERROR:  permission denied for schema auth

2026-01-11 17:17:07.263 CET [153] STATEMENT:  LOCK TABLE auth.users, core.comments, core.doc_pages, core.doc_pages_doc_parts_link, core.doc_parts, core.docs, core.docs_doc_pages_link, core.docs_doc_parts_link, core.email_types, core.emails, core.files, core.job_tasks, core.job_templates, core.jobs, core.jobs_objects_association, core.journal_entries, core.notices, core.object_systems, core.object_types, core.objects, core.objects_object_systems_association, core.offers, core.orgs, core.orgs_admins_association, core.orgs_users_association, core.poll_options, core.poll_votes, core.polls, core.problems, core.problems_objects_association, core.proposal_user_votes, core.proposals, core.proposals_jobs_association, core.proposals_objects_association, core.user_email_preferences, core.user_profiles, core.users_emails_association, core.variants, crm.addresses, crm.contacts, crm.contrahents, crm.contrahents_addresses_association, crm.contrahents_contacts_association, crm.contrahents_objects_association, crm.contrahents_orgs_association, crm.contrahents_types_association, crm.profiles, crm.types, money.acc_groups, money.accounting_periods, money.milage_tresholds, money.org_accounts, money.org_splits, money.org_transactions, money.tpl_accounts, money.tpl_sets, money.tpl_splits, money.tpl_transactions, money.trips, public.alembic_version IN ACCESS SHARE MODE

2026-01-11 17:18:06.971 CET [156] ERROR:  permission denied for schema core

2026-01-11 17:18:06.971 CET [156] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:18:07.232 CET [157] ERROR:  permission denied for schema auth

2026-01-11 17:18:07.232 CET [157] STATEMENT:  LOCK TABLE auth.users, core.comments, core.doc_pages, core.doc_pages_doc_parts_link, core.doc_parts, core.docs, core.docs_doc_pages_link, core.docs_doc_parts_link, core.email_types, core.emails, core.files, core.job_tasks, core.job_templates, core.jobs, core.jobs_objects_association, core.journal_entries, core.notices, core.object_systems, core.object_types, core.objects, core.objects_object_systems_association, core.offers, core.orgs, core.orgs_admins_association, core.orgs_users_association, core.poll_options, core.poll_votes, core.polls, core.problems, core.problems_objects_association, core.proposal_user_votes, core.proposals, core.proposals_jobs_association, core.proposals_objects_association, core.user_email_preferences, core.user_profiles, core.users_emails_association, core.variants, crm.addresses, crm.contacts, crm.contrahents, crm.contrahents_addresses_association, crm.contrahents_contacts_association, crm.contrahents_objects_association, crm.contrahents_orgs_association, crm.contrahents_types_association, crm.profiles, crm.types, money.acc_groups, money.accounting_periods, money.milage_tresholds, money.org_accounts, money.org_splits, money.org_transactions, money.tpl_accounts, money.tpl_sets, money.tpl_splits, money.tpl_transactions, money.trips, public.alembic_version IN ACCESS SHARE MODE

2026-01-11 17:19:06.976 CET [160] ERROR:  permission denied for schema core

2026-01-11 17:19:06.976 CET [160] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:20:06.971 CET [163] ERROR:  permission denied for schema core

2026-01-11 17:20:06.971 CET [163] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:21:06.968 CET [166] ERROR:  permission denied for schema core

2026-01-11 17:21:06.968 CET [166] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:22:06.969 CET [169] ERROR:  permission denied for schema core

2026-01-11 17:22:06.969 CET [169] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:23:06.973 CET [172] ERROR:  permission denied for schema core

2026-01-11 17:23:06.973 CET [172] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:24:06.964 CET [175] ERROR:  permission denied for schema core

2026-01-11 17:24:06.964 CET [175] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:25:06.970 CET [178] ERROR:  permission denied for schema core

2026-01-11 17:25:06.970 CET [178] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:26:06.967 CET [181] ERROR:  permission denied for schema core

2026-01-11 17:26:06.967 CET [181] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')

			

2026-01-11 17:27:06.966 CET [184] ERROR:  permission denied for schema core

2026-01-11 17:27:06.966 CET [184] STATEMENT:  

				SELECT COUNT(*)

				FROM pg_catalog.pg_tables t

				WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema')

				AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT')
*Originally created by @Rigel772 on 1/11/2026* After restoring Postgres database I am getting ``` 2026-01-11 17:16:51.301 CET [150] ERROR: permission denied for schema auth 2026-01-11 17:16:51.301 CET [150] STATEMENT: LOCK TABLE auth.users, core.comments, core.doc_pages, core.doc_pages_doc_parts_link, core.doc_parts, core.docs, core.docs_doc_pages_link, core.docs_doc_parts_link, core.email_types, core.emails, core.files, core.job_tasks, core.job_templates, core.jobs, core.jobs_objects_association, core.journal_entries, core.notices, core.object_systems, core.object_types, core.objects, core.objects_object_systems_association, core.offers, core.orgs, core.orgs_admins_association, core.orgs_users_association, core.poll_options, core.poll_votes, core.polls, core.problems, core.problems_objects_association, core.proposal_user_votes, core.proposals, core.proposals_jobs_association, core.proposals_objects_association, core.user_email_preferences, core.user_profiles, core.users_emails_association, core.variants, crm.addresses, crm.contacts, crm.contrahents, crm.contrahents_addresses_association, crm.contrahents_contacts_association, crm.contrahents_objects_association, crm.contrahents_orgs_association, crm.contrahents_types_association, crm.profiles, crm.types, money.acc_groups, money.accounting_periods, money.milage_tresholds, money.org_accounts, money.org_splits, money.org_transactions, money.tpl_accounts, money.tpl_sets, money.tpl_splits, money.tpl_transactions, money.trips, public.alembic_version IN ACCESS SHARE MODE 2026-01-11 17:17:06.967 CET [152] ERROR: permission denied for schema core 2026-01-11 17:17:06.967 CET [152] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:17:07.263 CET [153] ERROR: permission denied for schema auth 2026-01-11 17:17:07.263 CET [153] STATEMENT: LOCK TABLE auth.users, core.comments, core.doc_pages, core.doc_pages_doc_parts_link, core.doc_parts, core.docs, core.docs_doc_pages_link, core.docs_doc_parts_link, core.email_types, core.emails, core.files, core.job_tasks, core.job_templates, core.jobs, core.jobs_objects_association, core.journal_entries, core.notices, core.object_systems, core.object_types, core.objects, core.objects_object_systems_association, core.offers, core.orgs, core.orgs_admins_association, core.orgs_users_association, core.poll_options, core.poll_votes, core.polls, core.problems, core.problems_objects_association, core.proposal_user_votes, core.proposals, core.proposals_jobs_association, core.proposals_objects_association, core.user_email_preferences, core.user_profiles, core.users_emails_association, core.variants, crm.addresses, crm.contacts, crm.contrahents, crm.contrahents_addresses_association, crm.contrahents_contacts_association, crm.contrahents_objects_association, crm.contrahents_orgs_association, crm.contrahents_types_association, crm.profiles, crm.types, money.acc_groups, money.accounting_periods, money.milage_tresholds, money.org_accounts, money.org_splits, money.org_transactions, money.tpl_accounts, money.tpl_sets, money.tpl_splits, money.tpl_transactions, money.trips, public.alembic_version IN ACCESS SHARE MODE 2026-01-11 17:18:06.971 CET [156] ERROR: permission denied for schema core 2026-01-11 17:18:06.971 CET [156] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:18:07.232 CET [157] ERROR: permission denied for schema auth 2026-01-11 17:18:07.232 CET [157] STATEMENT: LOCK TABLE auth.users, core.comments, core.doc_pages, core.doc_pages_doc_parts_link, core.doc_parts, core.docs, core.docs_doc_pages_link, core.docs_doc_parts_link, core.email_types, core.emails, core.files, core.job_tasks, core.job_templates, core.jobs, core.jobs_objects_association, core.journal_entries, core.notices, core.object_systems, core.object_types, core.objects, core.objects_object_systems_association, core.offers, core.orgs, core.orgs_admins_association, core.orgs_users_association, core.poll_options, core.poll_votes, core.polls, core.problems, core.problems_objects_association, core.proposal_user_votes, core.proposals, core.proposals_jobs_association, core.proposals_objects_association, core.user_email_preferences, core.user_profiles, core.users_emails_association, core.variants, crm.addresses, crm.contacts, crm.contrahents, crm.contrahents_addresses_association, crm.contrahents_contacts_association, crm.contrahents_objects_association, crm.contrahents_orgs_association, crm.contrahents_types_association, crm.profiles, crm.types, money.acc_groups, money.accounting_periods, money.milage_tresholds, money.org_accounts, money.org_splits, money.org_transactions, money.tpl_accounts, money.tpl_sets, money.tpl_splits, money.tpl_transactions, money.trips, public.alembic_version IN ACCESS SHARE MODE 2026-01-11 17:19:06.976 CET [160] ERROR: permission denied for schema core 2026-01-11 17:19:06.976 CET [160] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:20:06.971 CET [163] ERROR: permission denied for schema core 2026-01-11 17:20:06.971 CET [163] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:21:06.968 CET [166] ERROR: permission denied for schema core 2026-01-11 17:21:06.968 CET [166] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:22:06.969 CET [169] ERROR: permission denied for schema core 2026-01-11 17:22:06.969 CET [169] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:23:06.973 CET [172] ERROR: permission denied for schema core 2026-01-11 17:23:06.973 CET [172] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:24:06.964 CET [175] ERROR: permission denied for schema core 2026-01-11 17:24:06.964 CET [175] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:25:06.970 CET [178] ERROR: permission denied for schema core 2026-01-11 17:25:06.970 CET [178] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:26:06.967 CET [181] ERROR: permission denied for schema core 2026-01-11 17:26:06.967 CET [181] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') 2026-01-11 17:27:06.966 CET [184] ERROR: permission denied for schema core 2026-01-11 17:27:06.966 CET [184] STATEMENT: SELECT COUNT(*) FROM pg_catalog.pg_tables t WHERE t.schemaname NOT IN ('pg_catalog', 'information_schema') AND has_table_privilege(current_user, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename), 'SELECT') ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
MrUnknownDE
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github/databasus#253
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?