-
- Lurker
- Posts: 2
- Liked: 1 time
- Joined: Apr 08, 2020 4:38 pm
- Full Name: Michael Rodriguez
- Contact:
Postgres vs SQL
Can anyone tell me if future versions (hopefully the next one), will be using Postgres instead of SQL, like the VBR's are switching to?
-
- Product Manager
- Posts: 8678
- Liked: 2276 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Postgres vs SQL
Hi Michael
Welcome to the forum.
Veeam One V12 will continue to use MSSQL as the database. There are dependencies on MSSQL components which cannot be simply replaced by Postgres.
Thanks
Fabian
Welcome to the forum.
Veeam One V12 will continue to use MSSQL as the database. There are dependencies on MSSQL components which cannot be simply replaced by Postgres.
Thanks
Fabian
Product Management Analyst @ Veeam Software
-
- Veeam Software
- Posts: 639
- Liked: 167 times
- Joined: Nov 01, 2016 11:26 am
- Contact:
Re: Postgres vs SQL
Hello Michael,
Recently when I discussed this question with devs they told, me that in theory, it should not be hard just to switch the database for the UI data. But currently, Veeam ONE is using SSRS for the reports and that is the сase. They would need to rewrite and test each and every report as well as a few other things related to reporting services. It's a big task.
As Fabian mentioned, v12 would use MSSQL and we cannot comment anything about the future as things are subject to change.
Was it just a question of curiosity or do you have issues with MSSQL and Veeam ONE?
Thanks.
Recently when I discussed this question with devs they told, me that in theory, it should not be hard just to switch the database for the UI data. But currently, Veeam ONE is using SSRS for the reports and that is the сase. They would need to rewrite and test each and every report as well as a few other things related to reporting services. It's a big task.
As Fabian mentioned, v12 would use MSSQL and we cannot comment anything about the future as things are subject to change.
Was it just a question of curiosity or do you have issues with MSSQL and Veeam ONE?
Thanks.
-
- Lurker
- Posts: 2
- Liked: 1 time
- Joined: Apr 08, 2020 4:38 pm
- Full Name: Michael Rodriguez
- Contact:
Re: Postgres vs SQL
Its not really an issue, but clients that have large infrastructures and do not want to pay for an SQL license, they will not have reporting enabled for the Virtual Infrastructure tab.
Thank you for your responses.
Thank you for your responses.
-
- Service Provider
- Posts: 56
- Liked: 2 times
- Joined: Dec 10, 2021 6:35 pm
- Full Name: Koushik Polsana
- Contact:
Re: Postgres vs SQL
Hello,
Sorry for this is being out of scope in this thread but I'm looking to add PostgreSQL to Power BI desktop, when adding the connection I was getting error saying "we encountered an error while trying to connect. Details: "PostgreSQL: SSPI aurgebtucation but integrated security not enabled " I really appreciate if you can help fix this issue. Thanks
Sorry for this is being out of scope in this thread but I'm looking to add PostgreSQL to Power BI desktop, when adding the connection I was getting error saying "we encountered an error while trying to connect. Details: "PostgreSQL: SSPI aurgebtucation but integrated security not enabled " I really appreciate if you can help fix this issue. Thanks
-
- Product Manager
- Posts: 8678
- Liked: 2276 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Postgres vs SQL
Hi Koushik
That question seems out of Veeam's scope.
From reading the error message, you have to enable additional security mechanism inside the PostgreSQL database.
Have you tried to find an answer in PostgreSQL support forums? I found some blogs and guides with Google.
As an example this wiki link: https://wiki.postgresql.org/wiki/Config ... on_Windows
Thanks
Fabian
That question seems out of Veeam's scope.
From reading the error message, you have to enable additional security mechanism inside the PostgreSQL database.
Have you tried to find an answer in PostgreSQL support forums? I found some blogs and guides with Google.
As an example this wiki link: https://wiki.postgresql.org/wiki/Config ... on_Windows
Thanks
Fabian
Product Management Analyst @ Veeam Software
-
- Service Provider
- Posts: 181
- Liked: 30 times
- Joined: Oct 28, 2010 10:55 pm
- Full Name: Ashley Watson
- Contact:
Re: Postgres vs SQL
Hi,
I just wonder now that V12 has been released to service providers what the roadmap look like for VeeamOne to switch to PosgreSQL?
We upgraded out development infrastructure a few days ago, and all is well, but we'd really like to see PostgreSQL as a deployment/migration option for VeeamOne.
I fully understand the SSRS dependencies but I think it would be to everyone's benefits if these could be worked through and replaced with cross platform equivalents.
On some of our own development projects we are starting to use Birt etc where applicable.
The SQL Express instance size issue is the main issue specifically with VeeamOne, and this requires regular intervention to keep it within size limits.
Eventually we'd love to see all the Veeam products including the main Backup and replication product available to run on PostgreSQL and deployable on Linux platforms to avoid unnecessary Microsoft licensing and to be able to scale to our requirements.
thanks again.
Ashley
I just wonder now that V12 has been released to service providers what the roadmap look like for VeeamOne to switch to PosgreSQL?
We upgraded out development infrastructure a few days ago, and all is well, but we'd really like to see PostgreSQL as a deployment/migration option for VeeamOne.
I fully understand the SSRS dependencies but I think it would be to everyone's benefits if these could be worked through and replaced with cross platform equivalents.
On some of our own development projects we are starting to use Birt etc where applicable.
The SQL Express instance size issue is the main issue specifically with VeeamOne, and this requires regular intervention to keep it within size limits.
Eventually we'd love to see all the Veeam products including the main Backup and replication product available to run on PostgreSQL and deployable on Linux platforms to avoid unnecessary Microsoft licensing and to be able to scale to our requirements.
thanks again.
Ashley
-
- Veeam Software
- Posts: 639
- Liked: 167 times
- Joined: Nov 01, 2016 11:26 am
- Contact:
Re: Postgres vs SQL
Hello Ashley,
You are right, benefits are seen and the SQL Express limitations are annoying.
On the other side, nothing has changed since my last post in this thread. Each and every report must be rewritten then tested then, probably, rewritten again and probably optimized to the new database. There are also other complicated things and not only reporting would be affected.
I can't add anything to the above at least now.
Thank you for the feedback and stay tuned
You are right, benefits are seen and the SQL Express limitations are annoying.
On the other side, nothing has changed since my last post in this thread. Each and every report must be rewritten then tested then, probably, rewritten again and probably optimized to the new database. There are also other complicated things and not only reporting would be affected.
I can't add anything to the above at least now.
Thank you for the feedback and stay tuned
-
- Veteran
- Posts: 879
- Liked: 46 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: Postgres vs SQL
Yes, I agree with @Mildur,mrodriguezCC wrote: ↑Aug 29, 2022 6:28 pm Can anyone tell me if future versions (hopefully the next one), will be using Postgres instead of SQL, like the VBR's are switching to?
The Custom Reporting service is utilizing the Microsoft SQL Server features.
--
/* Veeam software enthusiast user & supporter ! */
/* Veeam software enthusiast user & supporter ! */
Who is online
Users browsing this forum: No registered users and 11 guests