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_password>
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
Akash Mohan 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-user mailing list galaxy-user@bx.psu.edu http://mail.bx.psu.edu/cgi-bin/mailman/listinfo/galaxy-user