Question: Using Postgresql Instead Of Sqlite
0
gravatar for Akash Mohan
8.6 years ago by
Akash Mohan20
Akash Mohan20 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.1k views
ADD COMMENTlink modified 8.6 years ago by Greg Von Kuster840 • written 8.6 years ago by Akash Mohan20
0
gravatar for Greg Von Kuster
8.6 years ago by
Greg Von Kuster840 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 COMMENTlink written 8.6 years ago by Greg Von Kuster840
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 107 users visited in the last hour