GitLab

Created by: DaiYamatta

I wanto to use PostgreSQL .. try setup but error.

Gemfile add gem "pg"

maybe st_commits and st_diffs limits do not use postgres and init db redefine text update is trobule:

bundle exec rake db:setup RAILS_ENV=production --trace /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/bundler-1.1.4/lib/bundler/runtime.rb:211: warning: Insecure world writable dir /usr/local/rbenv/versions/1.9.3-p194/bin in PATH, mode 040777 /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/bundler-1.1.4/lib/bundler.rb:255: warning: Insecure world writable dir /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/bin in PATH, mode 040777 ** Invoke db:setup (first_time) ** Invoke db:schema:load_if_ruby (first_time) ** Invoke db:create (first_time) ** Invoke db:load_config (first_time) ** Invoke rails_env (first_time) ** Execute rails_env ** Execute db:load_config ** Execute db:create gitlabhq_production already exists ** Execute db:schema:load_if_ruby ** Invoke db:schema:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:schema:load -- create_table("events", {:force=>true}) NOTICE: CREATE TABLE will create implicit sequence "events_id_seq" for serial column "events.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "events_pkey" for table "events" -> 0.1494s -- create_table("issues", {:force=>true}) NOTICE: CREATE TABLE will create implicit sequence "issues_id_seq" for serial column "issues.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "issues_pkey" for table "issues" -> 0.1222s -- add_index("issues", ["project_id"], {:name=>"index_issues_on_project_id"}) -> 0.0812s -- create_table("keys", {:force=>true}) NOTICE: CREATE TABLE will create implicit sequence "keys_id_seq" for serial column "keys.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "keys_pkey" for table "keys" -> 0.1324s -- create_table("merge_requests", {:force=>true}) NOTICE: CREATE TABLE will create implicit sequence "merge_requests_id_seq" for serial column "merge_requests.id" rake aborted! PG::Error: ERROR: type modifier is not allowed for type "text" LINE 1: ...LL, "updated_at" timestamp NOT NULL, "st_commits" text(42949... ^ : CREATE TABLE "merge_requests" ("id" serial primary key, "target_branch" character varying(255) NOT NULL, "source_branch" character varying(255) NOT NULL, "project_id" integer NOT NULL, "author_id" integer, "assignee_id" integer, "title" character varying(255), "closed" boolean DEFAULT 'f' NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "st_commits" text(4294967295), "st_diffs" text(4294967295), "merged" boolean DEFAULT 'f' NOT NULL, "state" integer DEFAULT 1 NOT NULL) /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in async_exec' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:653:inblock in execute' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:280:in block in log' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activesupport-3.2.3/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:275:in log' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:652:inexecute' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:170:in create_table' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/migration.rb:466:inblock in method_missing' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/migration.rb:438:in block in say_with_time' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/benchmark.rb:280:inmeasure' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/migration.rb:438:in say_with_time' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/migration.rb:458:inmethod_missing' /home/gitlabhq/gitlabhq/db/schema.rb:55:in block in <top (required)>' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/schema.rb:50:ininstance_eval' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/schema.rb:50:in define' /home/gitlabhq/gitlabhq/db/schema.rb:14:in<top (required)>' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:245:in load' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:245:inblock in load' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:236:in load_dependency' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:245:inload' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/railties/databases.rake:366:in block (3 levels) in <top (required)>' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:205:incall' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:205:in block in execute' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:200:ineach' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:200:in execute' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:158:inblock in invoke_with_call_chain' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/monitor.rb:211:in mon_synchronize' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:151:ininvoke_with_call_chain' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:144:in invoke' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/railties/databases.rake:373:inblock (3 levels) in <top (required)>' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:205:in call' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:205:inblock in execute' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:200:in each' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:200:inexecute' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:158:in block in invoke_with_call_chain' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/monitor.rb:211:inmon_synchronize' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:151:in invoke_with_call_chain' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:176:inblock in invoke_prerequisites' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:174:in each' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:174:ininvoke_prerequisites' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:157:in block in invoke_with_call_chain' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/monitor.rb:211:inmon_synchronize' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:151:in invoke_with_call_chain' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/task.rb:144:ininvoke' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:116:in invoke_task' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:94:inblock (2 levels) in top_level' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:94:in each' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:94:inblock in top_level' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:133:in standard_exception_handling' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:88:intop_level' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:66:in block in run' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:133:instandard_exception_handling' /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/1.9.1/rake/application.rb:63:in run' /usr/local/rbenv/versions/1.9.3-p194/bin/rake:32:in' Tasks: TOP => db:schema:load