Gitlab backup: Postgres syntax error

Created by: garnieretienne

Hi, I get an error when trying to backup my data:

gitlab@master:~/gitlab$ bundle exec rake gitlab:backup:create RAILS_ENV=production
Dumping database tables:
- Dumping table events... rake aborted!
PG::Error: ERROR:  syntax error at or near "`"
LINE 1: SELECT * FROM `events`
                      ^
: SELECT * FROM `events`
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1153:in `async_exec'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1153:in `exec_no_cache'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:662:in `block in exec_query'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.9/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:661:in `exec_query'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1248:in `select'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:164:in `block (6 levels) in <top (required)>'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:163:in `open'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:163:in `block (5 levels) in <top (required)>'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:160:in `each'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:160:in `block (4 levels) in <top (required)>'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:8:in `block (3 levels) in <top (required)>'
Tasks: TOP => gitlab:backup:db:create
(See full trace by running task with --trace)

Some informations about my config:

gitlab@master:~/gitlab$ bundle exec rake gitlab:env:info RAILS_ENV=production

System information
System:     Debian 6.0.6
Current User:   gitlab
Using RVM:  no
Ruby Version:   1.9.3p327
Gem Version:    1.8.23
Bundler Version:1.2.3
Rake Version:   10.0.1

GitLab information
Version:    4.0.0
Revision:   19cb29e
Directory:  /srv/www/gitlab/gitlab
DB Adapter: postgresql
URL:        http://git.master.dev
HTTP Clone URL: http://git.master.dev/some-project.git
SSH Clone URL:  git@master.dev:some-project.git
Using LDAP: no
Using Omniauth: no

Gitolite information
Version:    v3.04-42-g2d29cf7
Admin URI:  git@localhost:gitolite-admin
Admin Key:  gitlab
Repositories:   /srv/git/repositories/
Hooks:      /srv/git/.gitolite/hooks/
Git:        /usr/bin/git

Created by: kyledrake

I'm getting the same issue.

By Administrator on 2012-12-29T22:30:19 (imported from GitLab)

Created by: kyledrake

I have a pending fix: #2437

By Administrator on 2012-12-29T23:02:19 (imported from GitLab)

Created by: jalada

By Administrator on 2013-02-28T15:23:31 (imported from GitLab)

Created by: Razer6

Whole Backup/restore refactored so this is outdated. @randx Please close

By Administrator on 2013-04-06T18:42:33 (imported from GitLab)

Created by: dzaporozhets

@razer6 thank you

By Administrator on 2013-04-09T12:07:01 (imported from GitLab)