On Thu, Dec 11, 2025 at 9:39 PM Mahendra Singh Thalor <mahi6run@gmail.com> wrote:
Here, in our case, as the cluster already has a role with the current user in restore, we are reporting error "pg_restore: error: could not execute query: ERROR: role "role" already exists" and after this error, restore is exiting.
If you restore using a different role, then you will not get any error and the full cluster will be restored. I will add some handling to ignore the "CREATE ROLE current_user" command in pg_restore.
Thanks Mahendra, Could you please also add some error message for this below
pg_restore command:
postgres=# create table t(n int);
CREATE TABLE postgres=# insert into t values (1),(10),(100); INSERT 0 3
Perform pg_dump: ./pg_dump -Ft -f a.a1 postgres
Perform pg_restore: /pg_restore -Ft a.a1 -f -C -v pg_restore: creating TABLE "public.t" pg_restore: processing data for table "public.t" [edb@1a1c15437e7c bin]$ ./psql postgres psql (19devel) Type "help" for help. postgres=# \dt Did not find any tables. postgres=#
