Thread: PostgreSQL 7.4 and Microsoft's SMS

PostgreSQL 7.4 and Microsoft's SMS

From
Justin Clift
Date:
Hi guys,

Just received a query through the Advocacy site's request form...

Does anyone know if PostgreSQL 7.4's native windows version will/would 
be compatible with Microsoft's SMS (System Management Server)?

Looks like some places will be considering it for Enterprise Deployment 
if it is.

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi



Re: PostgreSQL 7.4 and Microsoft's SMS

From
"Magnus Hagander"
Date:
If you're talking about running as a backend for SMS you can be almost
certain it will not work. That one today works only with MS SQL (not
Oracle, DB2 or anybody else that already have native Win32 versions),
and probably uses a *lot* of the non standard features in it. IIRC the
beta of the new version of SMS coming out soon won't even work with
older versions of MSSQL - only SQL Server 2000 is supported.


If you mean that you can install it using the SMS Software Distribution
feature, that should be possible. Almost any app can be distributed with
that, assuming you repackage the setup. Almost all setup programs that
supports fully-noninteractive install will work without repackaging.

The *current* psql client will already install using SMS. Don't know
about the ODBC driver, but it should probably be possible with that one
too.


//Magnus


> -----Original Message-----
> From: Justin Clift [mailto:justin@postgresql.org]
> Sent: Friday, January 17, 2003 4:40 AM
> To: PostgreSQL Hackers Mailing List
> Subject: [HACKERS] PostgreSQL 7.4 and Microsoft's SMS
>
>
> Hi guys,
>
> Just received a query through the Advocacy site's request form...
>
> Does anyone know if PostgreSQL 7.4's native windows version
> will/would
> be compatible with Microsoft's SMS (System Management Server)?
>
> Looks like some places will be considering it for Enterprise
> Deployment
> if it is.
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
> --
> "My grandfather once told me that there are two kinds of
> people: those who work and those who take the credit. He told
> me to try to be in the first group; there was less competition there."
> - Indira Gandhi
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>


Re: PostgreSQL 7.4 and Microsoft's SMS

From
"Dave Page"
Date:

> -----Original Message-----
> From: Magnus Hagander [mailto:mha@sollentuna.net]
> Sent: 17 January 2003 11:30
> To: Justin Clift; PostgreSQL Hackers Mailing List
> Subject: Re: [HACKERS] PostgreSQL 7.4 and Microsoft's SMS
>
> The *current* psql client will already install using SMS.
> Don't know about the ODBC driver, but it should probably be
> possible with that one too.
>

It certainly should do - that's one of the reasons it's in a Microsoft
Installer database.

Regards, Dave.