![]() ![]() Open the nf file located in the Postgres data directory, and change the following value: Hostssl all allĐ.0.0.0\0 md5 Reload PostgreSQL ConfigurationĪfter making these configuration changes, restart PostgreSQL to load the changes. # Enable Remote Access for TLS Users in pg_hba.conf If ONLY using TLS connections, remove any non-TLS entry made during previous steps in the pg_hba.conf file. This may vary depending on the environment. Please verify the permissions and ownership of the certificate, key, and path before proceeding. You may use the default location to store certificates or choose your own. Please prepare CA-signed certificates and keys prior to completing this configuration. Configure PostgreSQL TLS (Windows)įor detailed instructions and information about transport layer security (TLS) configuration options for PostgreSQL, please refer to the official documentation. Repeat this process for each of the four databases needed (Manager, Parameters, Sessions, and Pulse). Select New Database, enter the name of the database, and click OK. Log in to the system as "postgres" or your superuser and right click on Databases in the left navigation pane. To create databases in PGAdmin, open the application (or web interface). The databases MUST be created by the superuser that qTest will use to access PostgreSQL.ĭatabase names are configurable, but a simple naming scheme is recommended. If you are not using the "postgres" user, please ensure that you create the databases as the alternate superuser. Create qTest Databases (Windows)ĭatabases should be created prior to installing qTest. Hostssl all all md5 Reload PostgreSQL ConfigurationĪfter making these configuration changes, restart PostgreSQL to load the changes. IP addresses and ranges MUST be entered in full CIDR format (0.0.0.0/0).Ĭurrently, only md5 authentication is supported by qTest.Įdit the pg_hba.conf file with any text editor. Using this example, user authentication is still required when allowing connections from all IP ranges. You may specify a single remote connection in this file or allow connections from all IP ranges. Change the following setting and save.Ĭ:\Program Files\PostgreSQL\10\data\pg_hba.conf Remote Access Notes QTest does not support special characters in the PostgreSQL user password.Ĭ:\Program Files\PostgreSQL\10\data\nfĮdit the nf file with any text editor. In the examples, indicates a variable value that must be entered. PostgreSQL must be installed by a user with administrator permissions.Ĭomplete Windows Update prior to installing PostgreSQL.Īfter installation, there are basic configurations required for qTest applications to function. Refer to the official documentation for detailed instructions for Windows installation. Please refer to the instructions in the PostgreSQL official documentation for full details. Please note, the following installation steps are for example only using Windows Server 2016. Please note, that you must open the ports below prior to any self-assisted installation or upgrade. If you need to upgrade your Elasticsearch, please refer to Upgrade Elasticsearch for qTest OnPremise 10.1.0. ![]() ![]() This reduces the need for you to upgrade every prerequisite component each time you upgrade qTest to the most recent version. We provide a range of supported versions for the prerequisite components so that OnPremise customers can easily maintain qTest OnPremise over time. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |