![]() ![]() If you set PostgreSQL to LATIN-9, then PostgreSQL will perform some incorrect conversions, and may even give an error. The InterMine system stores all text in the database in UTF-8 format. You should also add a line to the pg_hba.conf file to allow logging in via password: Note that most of the changes above require starting postgres.ĭepending on your system configuration (production or development), the type of sources used in the build (files or databases) and the load on your web application, you may need to increase the max_connections parameter (for example to 250). Read Tuning your PostgreSQL Server for more information. Sudo sysctl -p /etc/sysctl.d/nf Copy PostgreSQL parameters #įor better performance. Procedures to change character encoding to SQL_ASCII in PostgreSQL 9.x: If performance is an issue, the use of SQL_ASCII is strongly recommended. You should only use either SQL_ASCII or UTF-8. For better performance, we recommend to make the changes below. The system works reasonably well with the default configuration. Required Configurations # Allow remote connections # listen_addresses Most of the configurations below are made by updating the file nf, usually located in /etc/postgres/version-nr/main. ![]() Some of the recommended settings below may not apply to older versions of PostgreSQL. We have had good experiences with Postgres.app and Macports. Postgres.app - Very easy for a development machine, requires zero configuration.The PostgreSQL downloads page has packages (for most systems) that set up everything for you. We currently run our continuous integration tests on PostgreSQL 9.2. We recommend you install PostgreSQL 9.2 and above. Customising the default queries in your io-docs application.Frictionless Specifications for InterMine.How to set up your InterMine webapp to use https.How to set up your InterMine environment on the Amazon Cloud. ![]() Tutorial - Configure your InterMine webapp!. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |