How can I tell that the underlying OS is Windows?

Поиск
Список
Период
Сортировка
Искать

How can I tell that the underlying OS is Windows?

От:
"Abraham, Danny" <danny_abraham@bmc.com>
Дата:

 

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/

FAQ