Hi,
Recently we migrated from gitlab-ce-11.0.1 (mysql) to omnibus-gitlab-ce-11.0.1 (postgresql). The application is running fine and only the backup rake tasks sudo gitlab-rake gitlab:backup:create
fails with the error:
gitlab:backup:create is failing with pg_dump: [archiver (db)] query failed: ERROR: permission denied for schema gitlabhq_production pg_dump: [archiver (db)] query was: LOCK TABLE gitlabhq_production.abuse_reports IN ACCESS SHARE MODE [FAILED] rake aborted! Backup::Error: Backup failed
Its happening because the mysql to postgresql converter created wrong schema, which eventually created two rows instead of one row.
gitlabhq_production=# gitlabhq_production=# \dn+ List of schemas Name | Owner | Access privileges | Description ---------------------+-------------+--------------------------------+------------------------ gitlabhq_production | gitlab-psql | | public | gitlab-psql | "gitlab-psql"=UC/"gitlab-psql"+| standard public schema | | =UC/"gitlab-psql" | (2 rows)
It should like as shown below:
gitlabhq_production=# gitlabhq_production=# \dn+ List of schemas Name | Owner | Access privileges | Description --------+-------------+--------------------------------+------------------------ public | gitlab-psql | "gitlab-psql"=UC/"gitlab-psql"+| standard public schema | | =UC/"gitlab-psql" | (1 row)
My question, is it safe to remove that first row ‘gitlabhq_production | gitlab-psql | …’ ?
Thank you.