search for: createdb

Hi, I get errors doing this: 1) createdb myapp_test 2) rake db:test:clone_structure 3) rake test:units rake aborted! PGError: ERROR: relation "matches" already exists I''m using the :sql schema format because there are some problems with postgres and the :ruby schema format config.active_record.schema_format = :sql...

Hi, I have the following exec type: exec{"createdb": path => "/usr/bin:/usr/sbin:/bin", command => "sudo -u postgres createdb -U postgres -E UNICODE opennms", unless => "sudo -u postgres psql -l | grep opennms > /dev/null", require => Service["postgresql"],...

Folks, I don''t like that I have to grant CREATEDB rights to the test user to get testing working smoothly with Postgres. What is the philosophical reason that Rails wants to drop and recreate databases during the testing? It would seem to me that "pg_dump -c" (the "clean" dump option, similar to mysqldump''s --add-drop...

...require => [Single_exec[initialize_db],Exec[postgres_add_localhost_trust],Single_exec[postgres_add_all_trust],Exec[postgres_add_ipv6_loopback_trust]], hasstatus => true } single_exec {"create_ovirt_db": command => "/usr/bin/createdb ovirt -U postgres", - require => [Exec[postgres_add_all_trust], Service[postgresql]] + require => [Single_exec[postgres_add_all_trust], Service[postgresql]] } single_exec {"create_ovirt_development_db": command => "/usr/bin/createdb ovirt...

...se that I use as a db server (postgresql). I have the pr-postgresql gem running and it works very well But when I try to "rake spec" I get these 2 errors C:/ruby/bin/rake: No such file or directory - dropdb -U "coleira" coleira_test C:/ruby/bin/rake: No such file or directory - createdb -E unicode -U "coleira" coleira_test after doing a "rake spec --trace" I found out that this is happening at the rake db:test:purge task, so I''m gessing that it is trying to run "pgsql" from my machine. I tested migrating the database and it all went fine. I...

Hello All, If I run my unit tests individually using Ruby, they all work correctly. However, if I try to run them using "rake test_units", I get a bunch of error messages. The error messages appear to be caused by rake not loading any of the fixtures into the test database. I am using PostgreSQL on Windows. Does anyone have any suggestions? Many thanks, Bruce. -- Posted via

...fferent Rails applications but I''m running into the same trouble with each one. Lets say I create an app called Test. I type ''rails test'' and it generates the directory for me. Now I edit my database.yml file. Then I create a database with Postgresql by typing createdb test. Now I go into Postgresql by typing ''psql test''. Here are my tables: CREATE TABLE topics ( id SERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL ); CREATE TABLE blogs ( id SERIAL PRIMARY KEY, title VARCHAR(100) NOT NULL, topic_i...

http://dev.rubyonrails.com/changeset/856 looks to me like it''s not going to work, since there''s no way of specifying a password to pg_dump/dropdb/createdb. If you set PGPASSWORD in your environment it might work, but that''s not documented anywhere and isn''t done automatically in the Rakefile. See http://thread.gmane.org/gmane.comp.lang.ruby.rails/3693 for the discussion we had a couple of weeks back about this. Did anyone try...

...ec/rails projects But, it *is* working fine on my other (older) rspec/rails projects. All projects are on rspec & rails 1.0.8, Rails 1.2.3, os X ppc Here''s a fresh rspec/rails project with failing rake task $ rails test_app -d postgresql $ cd test_app/ $ jedit config/database.yml $ createdb test_app_test $ createdb test_app_development $ ./script/plugin install http://rspec.rubyforge.org/svn/tags/CURRENT/rspec_on_rails $ ./script/plugin install http://rspec.rubyforge.org/svn/tags/CURRENT/rspec $ ./script/generate rspec $ ./script/generate rspec_model Account $ jedit db/migrate/001_...

Hi I am using postgres And I have already development database..When I give rake db:test:prepare it gives sh: dropdb: command not found sh: createdb: command not found But how ever test db is created Same happens also when rake db:test:clone I would like to know why I am getting this message Thanks in advance Sijo -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message...

...e schema from dev to the test database. I would prefer to use migrations to perform the building of the test schema, and I have tried ''http://snippets.dzone.com/posts/show/2031'' to use migration building. However, this still attempts to use ''dropdb'' and ''createdb'' commands when using the rake test. I know this is some kind of setup / registration problem, but I wanted confirmation that these kind of ''tweaks'' to the rails app is the best way of implementing the migration control over the test db. What are your thoughts and apolog...

TDD, SVN and migrations seem to be a natural combination for model development: create a test, add the column with a migration, write the code, and check it all in when you''re done. The trouble is that this ends up creating one migration per field. I guess it''s not horrible in and of itself, but it does have a code smell to it. Has anyone come up with a different way of doing

Hello everyone! Pushing my new rails project I stumbled upon some weird problem. I cannot force WeBRICK to show me my MySQL records in UTF-8. All I recieve into the object (instead of russian letters) are question marks (a la ?????? style). I am running MySQL 4.1 (the one with switchable charsets) and a binary Ruby extension for it, all on OSX. To me it looks like MySQL never recieves what I

...first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_structure_dump ** Invoke purge_test_database (first_time) ** Invoke environment ** Execute purge_test_database dropdb: database removal failed: ERROR: database "darkthrone" is being accessed by other users createdb: database creation failed: ERROR: database "darkthrone" already exists ** Execute clone_structure_to_test psql:db/development_structure.sql:13: ERROR: schema "development" already exists psql:db/development_structure.sql:27: ERROR: schema "test" already exists psql:db/...

Hello, When I try to run "rake clone_structure_to_test" on my project, I get the following errors: $ rake clone_structure_to_test (in /home/www/cedscreening) psql:db/development_structure.sql:8: ERROR: permission denied to set session authorization psql:db/development_structure.sql:16: ERROR: permission denied for schema public psql:db/development_structure.sql:34: NOTICE: CREATE

...single_exec { "wait_for_postgres" : + command => "/usr/bin/ovirt-wait4service 'psql -l -U postgres' 10 2", + require => Service[postgresql] + } + single_exec {"create_ovirt_db": command => "/usr/bin/createdb ovirt -U postgres", - require => [Exec[postgres_add_all_trust], Service[postgresql]] + require => [Exec[postgres_add_all_trust], Single_exec[wait_for_postgres]] } single_exec {"create_ovirt_development_db": command => "/usr/bin/createdb o...

Hi all, I've compiled and start the modified prepaid with postgresql. I would like to ask if anyone can give me a sample account to be populate in the database. I also want to confirm if this correct. I created a database prepaid (createdb prepaid) and from the asterisk-prepaid(current modified prepaid application) database folder, I execute (psql prepaid < prepaid.sql, psql prepaid < prepaid-data-country.sql, and psql prepaid < prepaid-data-countryprefix.sql). thanks a lot. regards -- www.bembang.com

...b postgresql-dev * then i installed the asterisk 1.6 version with the odbc modules as in the selected list. * then i created the database as asterisk and the user also with the same name. The password is "secret". root at astserver: ~# su postgres $ createuser -s -D -R -l -P -e asterisk $ createdb -O asterisk -e asterisk * then i did the configuration as follows, /etc/odbc.ini [banking] Description = ODBC Testing Driver = PostgreSQL Trace = No Database = asterisk Servername = 127.0.0.1 Username = asterisk Password = secret Port = 5432 /etc/odbcinst.ini [PostgreS...

Hi guys, Pls I need good and working instructions on how to install phpmyadmin on centos 6.3 ? I would appreciate your kind and timely response on this. regards kunle

...l-7.4.16-1.RHEL4.1 postgresql-7.4.16-1.RHEL4.1 postgresql-python-7.4.16-1.RHEL4.1 postgresql-server-7.4.16-1.RHEL4.1 Then, I did below commands to create a user and a database. [root at box root]# su postgres bash-3.1$ createuser -adEP test Enter password for new role: Enter it again: bash-3.1$ createdb -O test testdb CREATE DATABASE bash-3.1$ exit exit Then, I installed phpPgAdmin rpm. [root at LinuxBox etc]# rpm -qa |grep phpPgAdmin phpPgAdmin-4.0.1-1 Then, After I logined to phpPgAdmin via web browser as below http://ipaddress/phpPgAdmin/ Then, I got below erros. *SQL error:* ERROR:...