Key 2: Trio requires md5 authentication for newly created user but itself should be run under default authentication for user running TrioExplorer (also TrioExplorer user must be added to postgresql first).
- I had hard time logging into postgresql with postgres under linux, fortunately it can be solved by sudo -u postgres psql (you can't su into postgres user account).
- The added user name should match the user running TrioExplorer, and a database with same name should be created for the user. Also for linux, plpgsql requires manual activation: createlang plpgsql template1.
- Changing default login method for postgresql is done by modifying pg_hba.conf. Change login to md5 for local all all [ident/peer/etc] line. Another line for user running TrioExplorer should be added with default login method.
没有评论:
发表评论