Using Postgresql Instead Of Sqlite

Question: Using Postgresql Instead Of Sqlite

9.5 years ago by

Akash Mohan • 20 wrote:

Hi All In one of the pages you have mentioned that Galxy site on production server uses PostgreSql as the database. I tried searching for a guide to integrate postgresql to galaxy but could find one. Could you please provide me the steps to do so. Thanks Akash DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

galaxy • 1.5k views

ADD COMMENT • link •

modified 28 days ago by anuragsinga6256 • 0 • written 9.5 years ago by Akash Mohan • 20

9.5 years ago by

Greg Von Kuster • 840

Greg Von Kuster • 840 wrote:

Hello Akash, Connecting to a database is as simple as setting the configuration in the universe_wsgi.ini file in your Galaxy install directory - see the "# Database connection" setting in the [app:main] section of the config. If your database is installed on the same server that you have Galaxy installed, comment out the default sqlite setting, use something like this ( assuming your db is configured to require authentication ): database_connection = postgres:///<database_name>?user=<db_user_name>&password=<db_user_pass word=""> If your db is installed on a different server, use something like this: database_connection = postgres:///<database_name>?host=<host_name> See the postgreSQL documentation for help on configuring various connection URLs if neither of these are what you need. Greg Von Kuster Galaxy Development Team

ADD COMMENT • link written 9.5 years ago by Greg Von Kuster • 840

28 days ago by

anuragsinga6256 • 0

anuragsinga6256 • 0 wrote:

If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. http://printertechsupportnumbers.com/blog/fix-hp-printer-error-state-windows-10/

ADD COMMENT • link written 28 days ago by anuragsinga6256 • 0

Please log in to add an answer.

Similar posts • Search »