How can I tell that the underlying OS is Windows?
Re: How can I tell that the underlying OS is Windows?
От:
Geoffrey <lists@serioustechnology.com>
Дата:
Based on how often it crashes? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Re: How can I tell that the underlying OS is Windows?
От:
Adam Witney <awitney@sgul.ac.uk>
Дата:
I assume you mean finding out the OS of the machine running PostgreSQL?? Maybe this will give a clue: db=>select version(); (I've never run it on Windows so I don't know what that produces for that OS) adam
Re: How can I tell that the underlying OS is Windows?
От:
"Benjamin Krajmalnik" <kraj@illumen.com>
Дата:
My Windows box says: "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" My BSD box says: "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" Seems to be the same
Re: How can I tell that the underlying OS is Windows?
От:
"Joshua D. Drake" <jd@commandprompt.com>
Дата:
Benjamin Krajmalnik wrote:
> My Windows box says:
> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
>
> My BSD box says:
> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
>
> Seems to be the same
Your bsd box appears to be connection to a postgresql on windows machine.
Joshua D. Drake
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Re: How can I tell that the underlying OS is Windows?
От:
"Benjamin Krajmalnik" <kraj@illumen.com>
Дата:
My mistake. I was connecting to remote machines and must have accidentally issued the version on the same box :( BSD is returning: "PostgreSQL 8.1.5 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518" > -----Original Message----- > From: Joshua D. Drake [mailto:jd@commandprompt.com] > Sent: Thursday, July 12, 2007 3:39 PM > To: Benjamin Krajmalnik > Cc: Adam Witney; pgsql-admin@postgresql.org; Abraham, Danny > Subject: Re: [ADMIN] How can I tell that the underlying OS is Windows? > > Benjamin Krajmalnik wrote: > > My Windows box says: > > "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) > > 3.4.2 (mingw-special)" > > > > My BSD box says: > > "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) > > 3.4.2 (mingw-special)" > > > > Seems to be the same > > Your bsd box appears to be connection to a postgresql on > windows machine. > > Joshua D. Drake > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 7: You can help support the PostgreSQL project by donating at > > > > http://www.postgresql.org/about/donate > > > > > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: > +1.800.492.2240 Providing the most comprehensive PostgreSQL > solutions since 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: > http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > >
Re: How can I tell that the underlying OS is Windows?
От:
"Joshua D. Drake" <jd@commandprompt.com>
Дата:
Benjamin Krajmalnik wrote:
> My mistake.
> I was connecting to remote machines and must have accidentally issued
> the version on the same box :(
How about this :)
SELECT * FROM version() WHERE version ~* 'gcc.exe' OR version ~* 'msvc';
You probably want to replace msvc with whatever that would be on MSVC.
Joshua D. Drake
>
> BSD is returning:
>
> "PostgreSQL 8.1.5 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
> 3.4.4 [FreeBSD] 20050518"
>
>
>> -----Original Message-----
>> From: Joshua D. Drake [mailto:jd@commandprompt.com]
>> Sent: Thursday, July 12, 2007 3:39 PM
>> To: Benjamin Krajmalnik
>> Cc: Adam Witney; pgsql-admin@postgresql.org; Abraham, Danny
>> Subject: Re: [ADMIN] How can I tell that the underlying OS is Windows?
>>
>> Benjamin Krajmalnik wrote:
>>> My Windows box says:
>>> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
>>> 3.4.2 (mingw-special)"
>>>
>>> My BSD box says:
>>> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
>>> 3.4.2 (mingw-special)"
>>>
>>> Seems to be the same
>> Your bsd box appears to be connection to a postgresql on
>> windows machine.
>>
>> Joshua D. Drake
>>
>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>> http://www.postgresql.org/about/donate
>>>
>>
>> --
>>
>> === The PostgreSQL Company: Command Prompt, Inc. ===
>> Sales/Support: +1.503.667.4564 || 24x7/Emergency:
>> +1.800.492.2240 Providing the most comprehensive PostgreSQL
>> solutions since 1997
>> http://www.commandprompt.com/
>>
>> Donate to the PostgreSQL Project:
>> http://www.postgresql.org/about/donate
>> PostgreSQL Replication: http://www.commandprompt.com/products/
>>
>>
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/