Bolic
Reputation: 745
Rails. stop database connection and reconnect
I try to implement a very easy backup process. Just dump the database into a file. The user gets all files displayed, choose one, and then the dump is loaded back. But loading back the dump is not possible while the rails server is running. How can I manage this? How can I stop the database connection, do my stuff and then reconnect to the database?
- I have tried with postgresql and rake commands to dump the database and recover it -> Permission denied
- I have tried with Sqlite3. Just copy the databasefile into a backup folder. But if I want to delete the current one to replace it with a new -> Permission denied
- I have tried with Sqlite3 dump. I dumped the database but again I can only load the dump back if the rails server is not running.
There are libraries out like Yamldb which works, but this library only can save one backup. I have to save more then one and give them names.
Upvotes: 0
Views: 512
Answers (1)
Related Questions
- How to auto reconnect Rails 6 PostgreSQL connection?
- Rails - Close current DB connection
- ActiveRecord: how to reconnect to PostgreSQL automatically when connection drops?
- How do you open and close a new database connection with ActiveRecord Rails 5
- Handle connection breakages in rails
- Kill postgre connection in rails console
- Cancel Rails DB connection
- Change database connection at runtime
- Properly close a SQL connection in Ruby on Rails?
- Programmatically drop all connections