Dumping PostgreSQL database gitlabhq_production

How to Use GitLab Self-managed
, ,
1

Hello,

I am using a gitlab in a self-hosted environment, an omnibus package installation Method. I can’t able to back up the database. Below is the Error Message.

[root@localhost ~]# gitlab-rake gitlab:backup:create
2019-11-19 18:32:07 +0530 -- Dumping database ...
Dumping PostgreSQL database gitlabhq_production ... pg_dump: Dumping the contents of table "user_agent_details" failed: PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
pg_dump: The command was: COPY public.user_agent_details (id, user_agent, ip_address, subject_id, subject_type, submitted, created_at, updated_at) TO stdout;
[FAILED]
rake aborted!
Backup::Error: Backup failed
/opt/gitlab/embedded/service/gitlab-rails/lib/backup/database.rb:50:in `dump'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:99:in `block (4 levels) in <top (required)>'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:10:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Tasks: TOP => gitlab:backup:db:create
(See full trace by running task with --trace)

It is Clear that something wrong with below table while it tried to make a dump, i’m struck with this Issue for a long While and unable to update gitlab Version too. any leads at this error.

pg_dump: The command was: COPY public.user_agent_details (id, user_agent, ip_address, subject_id, subject_type, submitted, created_at, updated_at) TO stdout;

I’ve tried login db console, and listed the database > table > colums

What to do Further?

Gitlab Version : 11.9.1
hosted environment : centos 7
server type: bare metal Server.