Hey <!here>! :wave: Quick reminder - Day 3 (Wednes...
# general
a
Hey <!here>! 👋 Quick reminder - Day 3 (Wednesday, Sept 10) of Launch Week 5 is all about our OSS community! You asked for production-ready database options beyond SQLite - PostgreSQL support is now live! But that's just the start. We've rebuilt our entire SQL layer to be database-agnostic, so MySQL/MariaDB are coming next based on your feedback. What else we're covering? • Live demo of the new PostgreSQL setup • Railway one-click deployment (yes, actually one click!) • How we redesigned our schema for scale • What's next for making data ingestion easier This entire day exists because of your feedback. Come tell us what you want to see next! Register if you haven't already: https://lu.ma/ockltj0t
❤️ 3
🙌 6
r
When Enabling postgres on an existing instance How would the migration look like from existing sqliteDB to postgres instance Would this be supported by some job in helm charts ?
v
@Nagesh Bansal
r
??
n
Hey @Raghav Awasthi, we’ll keep you updated. For now, we're supporting new installations, and we’re still evaluating the migration process for existing ones.
r
For new installations as well I don't see the docker compose file shown on the demo on the main branch that contains necessary configuration flags for postgres mode Would you be able to push it so we can use the feature effectively and modify the helm charts on our setup
n
Please check the blog: https://signoz.io/blog/oss-improvements/. You need to add the PostgreSQL service and set the required environment variables in the Signoz Service, as shown in the blog
r
Thanks @Nagesh Bansal probably in our case I would be going with helm charts route would modify the official signoz helm charts to deploy the postgres cluster and configure the variables. I will try to include a mini migration as a part of init container to import data will try to shoot a PR on signoz helm chart
We can incremently build upon it if we can add this import in the existing schema migrator itself to check local sqliteDB and import to pg if import flag is set to true in the helm chart.
What do you think ?