No. StackGres contains PostgreSQL, plus several other components (such as connection pooling or automatic high availability software) from the PostgreSQL ecosystem. All of them are vanilla versions, as found in their respective open source repositories, including PostgreSQL. Any application that runs against a PostgreSQL database should work as-is if you use StackGres.
StackGres source code is licensed under the OSI-approved open source license GNU Affero General Public License version 3 (AGPLv3). All the source code is available on this repository.
Yes. Contact us at StackGres at Ongres doc com if you want a trial or commercial license that does not contain the GPL clauses.
No, this won’t happen. That’s our promise. We respect others who switch to or are directly built as source-available software, but we don’t follow this approach. We love the concept of GitLab’s stewardship, and in the same spirit, we promise you that StackGres will always be open source software.
As of now, PostgreSQL major version 11 and 12. Version 13 will be added soon.
StackGres has been designed to run on any Kubernetes-certified platform. Whether that’s a Kubernetes-as-a-Service offered by a cloud provider or running on-premise, StackGres should run as-is.
High Availability and automatic failover are based on Patroni, a well-reputed and trusted software for PostgreSQL. No external DCS (Distributed Consistent Storage) is required, as it relies on K8s APIs for this (which, in turn, uses etcd internally).
Yes, we use pgbouncer. Most Postgres DBaaS solutions don’t include connection pooling as part of their managed service. Yet, in most real-life scenarios, PostgreSQL should be fronted by a connection pooler. There are many reasons for this, but the main ones are excessive memory consumption and degraded performance under too many connections — where too many can be as low as several hundreds or even a few thousand. That’s why we include it in StackGres.
All StackGres container images are built on the Red Hat Universal Base Image (UBI) version 8, which is derived from RHEL 8. Red Hat Universal Base Images (UBI) are OCI-compliant container base operating system images with complementary runtime languages and packages that are freely redistributable. UBI lets developers create the image once and deploy anywhere using enterprise-grade packages. For more information read the official UBI-FAQ. Alpine images are even smaller than UBI. However, they have significant disadvantages. They:
No. We just believe UBI are the best base images for enterprise-grade containers. This way, StackGres users can get support for the container images from the most popular Linux distribution.
Yes. Contact with us.
No. OnGres (“On Postgres”), the company behind StackGres, is a Postgres-only shop. That’s our expertise and there’s no plan to divert from this. Databases are a very complex world, and while they may “look and feel” the same from a user perspective, they are very different from an operational perspective. We have more than two decades of experience developing and running PostgreSQL databases. Plus we believe PostgreSQL is the best relational database, anyway!
If you think we should add answers to other questions, please file an issue on our repository!