Re: [alchemy-cms Group] I can't restore my database

[Robin Böning]

It sounds you need to grant your database user the correct permissions. Did you set up the database and the user on your own (and if you did, how did you do?), or did your provider?

Cheers

robin

On 20.03.2015, at 08:33, hopewise <as3...@gmail.com> wrote:

that proof that my user is able to create tables, however when I tried to import the dump file into the database, i got this error:

ActiveRecord::StatementInvalid (PG::InsufficientPrivilege: ERROR: permission denied for relation alchemy_sites
: SELECT "alchemy_sites".* FROM "alchemy_sites" WHERE "alchemy_sites"."host" = 'xx.xx.xxx.xxx' ORDER BY "alchemy_sites"."id" ASC LIMIT 1):
activerecord (4.1.6) lib/active_record/connection_adapters/postgresql_adapter.rb:822:in `async_exec'

[Samir Sabri]

Please see the attached screenshot, although I set user name to postgresin database.yml, when I try:

$ RAILS_ENV=production bin/rake alchemy:install:migrations 

nothing happens, and no logs printed indicating new migrations.. how to investigate this?

Samir

--
You received this message because you are subscribed to a topic in the Google Groups "Alchemy CMS" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/alchemy-cms/yc4p9t9sQY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to alchemy-cms...@googlegroups.com.
To post to this group, send email to alche...@googlegroups.com.
Visit this group at http://groups.google.com/group/alchemy-cms.
To view this discussion on the web visit https://groups.google.com/d/msgid/alchemy-cms/534EC8A0-8D9C-4E0B-AFF4-7397DDE7B461%40magiclabs.de.
For more options, visit https://groups.google.com/d/optout.

[Thomas von Deyen]

This seems to be a problem on our host.

Did you asked your provider about this?