search for: dropdb

hey guys, I''m having a problem here, I have a pc in my house 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...

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 an...

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/. --~--~---------~--~----~------------~-------~--~...

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 It seems rake test:units is trying to create the tables

...e pre-requisite which copies the 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....

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

...ve it and make it running?? ** Invoke clone_structure_to_test (first_time) ** Invoke db_structure_dump (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"...

I''m writing some code that accesses some lagacy database on PostgreSQL. Since the old database had some really ughly and weird naming conventions (like CamelCase). To work around this I created a second schema (named rails) in the same database and gave the tables and fields some rails-friendly names. The database user that Rails uses has its search_path set to the rails schema. That way

Hi everyone. I''m having a bit of a problem with an application I''m currently developing with Rails 1.2.3 and PostgreSQL, attempting to use test-first development. Here''s the scenario: * I have the usual three databases, with migrations. Testing has been working beautifully. * I need to store geographic data, so I add PostGIS to all three databases (along with

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do