Thread: Postgres vs. SQL Server on Reddit

> The poster tries to make a case for Postgres in a sea of SQL-Server
> admins.

The last time I checked, SQL Server didn't even run on actually
*operating* systems with the ability to perform I/O, with a decent
filesystem, with a user-rights concept and with process management.

Sincerely,

Wolfgang

On 03/13/2013 09:34 PM, Joshua Kramer wrote:
> I was browsing Reddit tonight and came across this.
>
> http://www.reddit.com/r/SQLServer/comments/1a87sp/your_boss_asks_you_to_justify_using_sql_server/
>
> The poster tries to make a case for Postgres in a sea of SQL-Server admins.

I think this is a good thread for us to pay attention to. It provides
insight into the minds of SQL-Server folks. I also think it shows why we
have more luck converting Oracle folk than SQL-Server folk (namely the
Windows->Unix thing).

What I do think is important to recognize here is that we don't have
tools like Microsoft has tools. There is of course an argument that we
don't need them but I can say it would be nice to manage 100 postgresql
machines, 20 which are in HAC clusters, from a single dashboard.

I don't know of any tool that can do that efficiently.

Joshua D. Drake

Joshua D. Drake, 14.03.2013 15:52:
> What I do think is important to recognize here is that we don't have
> tools like Microsoft has tools. There is of course an argument that
> we don't need them but I can say it would be nice to manage 100
> postgresql machines, 20 which are in HAC clusters, from a single
> dashboard.
>
> I don't know of any tool that can do that efficiently.

I thought that EnterpriseDB's "Postgres Enterprise Manager" targets that part?

Thomas

On 03/14/2013 08:19 AM, Thomas Kellerer wrote:
>
> Joshua D. Drake, 14.03.2013 15:52:
>> What I do think is important to recognize here is that we don't have
>> tools like Microsoft has tools. There is of course an argument that
>> we don't need them but I can say it would be nice to manage 100
>> postgresql machines, 20 which are in HAC clusters, from a single
>> dashboard.
>>
>> I don't know of any tool that can do that efficiently.
>
> I thought that EnterpriseDB's "Postgres Enterprise Manager" targets that
> part?

No idea if it does. I was speaking from a PostgreSQL/Postgres
perspective not from a EnterpriseDB perspective.

JD




--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579

> No idea if it does. I was speaking from a PostgreSQL/Postgres
> perspective not from a EnterpriseDB perspective.

PEM works with vanilla Postgres.  I don't know if it's as good as the MS
Enterprise manager is now (I suspect not), but it's better than the SQL
Ent. Mgr. from 2003, the last time I used it.

However, the "tools gap" between us and MS is certainly real.
Management tools are becoming less relevant as people move stuff to
cloud hosting, which usually comes with its own tools.  postgres.her
oku.com, for example, makes all of those widgets and tree views etc.
unnecessary, as most of that stuff is taken care of for you.  Same on
Microsoft's on Azure.

I personally lust after MS's analytics tools though.  Some of the
OSS/3rd-party stuff may be more powerful, but MS' kicks Pentaho's butt
at making it possible to do complex analytics without writing code.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com