What is our primary use case?
We use it for processing files mostly. It integrates basically with the SQL Server. On the server-side it uses the SQL Server, then from the files that are generated from SQL Server we do have an application running using Microsoft, and we attach it to a Postgres server. We do is for the backups there from time to time.
What is most valuable?
Overall, the solution is very good.
The solution is free to use.
It is easy to use and quite stable. It's as robust as Oracle, however, SQL Server is easier to use I think.
The product is very similar to the SQL Server.
The installation is quite fast.
What needs improvement?
If you look at overall PostgreSQL, it could be easier to use.
I'm not yet able to use all of the features on the product at this time.
I'm not really able to customize it.
The integration could be easier. SQL Server has an easier integration process, for example, as a comparison.
With Postgres, you can run it in Windows Server, however, there are other things that you have to run.
The product is more for technical people. For example, SQL Server is for anybody. Even newer users can just pick it up and learn from it and mess with it and run it. You can't do that with PostgreSQL. It has more of a learning curve. YOu need more training and documentation.
For how long have I used the solution?
We've been using the solution for about five years. We've used it for a while, however, it is only on a few workstations.
What do I think about the stability of the solution?
The solution is very good and very stable. There are no bugs or glitches. it doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
There are only a couple of users at this time as we restrict it only to local implementations. Per store, we do have certain applications that use it.
How are customer service and technical support?
We haven't reached out to techncial support. As with Linux, if you want tech support then you have to pay a subscription for it. The free version is, with what we have here, working well and we haven't had problems.
I have only a couple of people helping me with regards to the tech support, internally. That's why we spend a lot of time focusing more on the SQL Server and the Microsoft products.
Which solution did I use previously and why did I switch?
We did not previously use other products.
I've also used Oracle and Microsoft SQL. This product is free and more robust than Oracle, however, Microsoft SQL might be easier to use.
How was the initial setup?
The installation is pretty quick. It's not hard to set up. I wouldn't describe it as a complex process.
We only have a couple of people on staff that can handle deployment and maintenance.
What's my experience with pricing, setup cost, and licensing?
The product is free. You don't have to pay a license fee.
What other advice do I have?
The last one that we used is version 11 or something like that. I'm not sure if that's the latest version or not.
Postgres is similar to Linux. It's designed for people who would know what they want, who would have to set up what they need, and they would use it, and they know that it's straightforward, so that other people cannot just go in and mess with it.
I'd rate the product as a nine out of ten.
I'd recommend the solution to other users.
Which deployment model are you using for this solution?