For security reasons, we do not recommend making the database port accessible over a public IP address. As a result, you will only be able to connect to your database nodes from machines that are running in the same network. IMPORTANT: By default, the database port for the nodes in this solution cannot be accessed over a public IP address. Open port 5432 in the server firewall ( instructions). Make sure that you have your cloud server’s IP address and application credentials ( instructions). PostgreSQL client authentication configuration file: /opt/bitnami/postgresql/conf/pg_hba.conf.PostgreSQL configuration settings file: /opt/bitnami/postgresql/conf/nf.NOTE: In the steps below, you will be modifying a couple of PostgreSQL configuration files: To connect to your remote PostgreSQL database server using pgAdmin 4, follow these steps: Check the pgAdmin official page for more information. PgAdmin is the most popular and feature-rich platform for administration and development of PostgreSQL databases. Contribute to Expaso/hassos-addons development by creating an account on GitHub.NOTE: This section assumes that you have downloaded and installed pgAdmin 4. If you have suggestions or encounter any problems, please create an Issue on the respective Github pages:Īdd the following repository-url to obtain these add-on’s: GitHub Expaso/hassos-addons With these add-ons, I hope to fill-in a little gap in the more-then-complete Home Assistant ecosystem, and give people a choice about what tool they want to use for a specific purpose. You don’t need to expose any portnumbers from the TimescaleDb add-on, if your intent is to use it solely for your home-assistant installation. You can connect to your TimescaleDb instance by using it’s internal mDNS name: 77b2833f-timescaledb port 5432 I chose to pack it separately from the TimescaleDb add-on, so you can choose this, or your own tooling, without forcing the extra overhead upon your installation when not needed. You can manage your TimescaleDb instance with it. PgAdmin is a web-based database management tool for PostgreSql. Therefore, I packaged pgAdmin as an add-on, ready for you to install. No database server is complete without a powerful management front-end. With this extension you finally can query alerts when the smartphone of your kid is detected more then 5 blocks away. Postgis can be used to query geospacial data. Oh, and before I forget: This addon also packs the Postgis extension. ![]() ![]() Of course Grafana has first-class support for TimescaleDb and PostgreSQL, so this makes a great combination for dashboarding, alerting and statistical analysis, based on your sensor data. ![]() To bring your precious sensor-statistics into TimescaleDB, you can use the Long Time State Storage Component. Learning new query languages like InfluxQL or Flux simply isn’t needed for querying time-series data. TLDR If you already know SQL, you’re gold. Why should you want to do that? Well, read this excellent blog-post from TimescaleDb itself, and judge yourself. These extensions open-up the possibility of using this database-sever as a timeseries database, and thus can replace InfluxDb in some occasions. The addon also has TimescaleDb extensions installed. The recorder-component can be configured to use PostgreSql instead of it’s default SQLLite connection by using the following database-url: postgresql://user: /homeassistantįor more information on configuring the recorder-component, please read the Docs TimescaleDb Extension You can use this database-server to replace the default HomeAssistant SQLLite database (the one that is used by the recorder-component and stores all entity-states). This add-on runs a PostgreSql database server on your HomeAssistant installation.
0 Comments
Leave a Reply. |