Databases
Because of the variety of methods used for connecting and authenticating with databases, please contact Xylok support at support@xylok.io for help with your specific database.
- psql installed and in the PATH
- Access from the machine running the script to the server
When a script with a Postgres benchmark is used, there will be a prompt at the beginning for the database host name, user, and password. If any of these aren’t needed (i.e., there’s no password), simply press enter when prompted.
After entering the information, the information won’t actually be tried until the script reaches the data collection for the database and, in an effort to not break other data, there won’t be a warning if collection is failing during execution. We recommend opening the .xylok results file the first time you try this process and search for “PostgreSQL” or “Column privileges” to check if you correctly received table results back or not. (You can of course also examine the results in Xylok itself.)