pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow can I tell that the underlying OS is Windows?
7+ messages / 5 participants
[nested] [flat]
* How can I tell that the underlying OS is Windows?
@ 2007-07-12 15:13 Abraham, Danny <danny_abraham@bmc.com>
2007-07-12 15:27 ` Re: How can I tell that the underlying OS is Windows? Geoffrey <lists@serioustechnology.com>
2007-07-12 15:34 ` Re: How can I tell that the underlying OS is Windows? Adam Witney <awitney@sgul.ac.uk>
0 siblings, 2 replies; 7+ messages in thread
From: Abraham, Danny @ 2007-07-12 15:13 UTC (permalink / raw)
To: pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: How can I tell that the underlying OS is Windows?
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
@ 2007-07-12 15:27 ` Geoffrey <lists@serioustechnology.com>
1 sibling, 0 replies; 7+ messages in thread
From: Geoffrey @ 2007-07-12 15:27 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: How can I tell that the underlying OS is Windows?
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
@ 2007-07-12 15:34 ` Adam Witney <awitney@sgul.ac.uk>
2007-07-12 21:02 ` Re: How can I tell that the underlying OS is Windows? Benjamin Krajmalnik <kraj@illumen.com>
1 sibling, 1 reply; 7+ messages in thread
From: Adam Witney @ 2007-07-12 15:34 UTC (permalink / raw)
To: pgsql-admin; +Cc: Abraham, Danny <danny_abraham@bmc.com>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: How can I tell that the underlying OS is Windows?
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
2007-07-12 15:34 ` Re: How can I tell that the underlying OS is Windows? Adam Witney <awitney@sgul.ac.uk>
@ 2007-07-12 21:02 ` Benjamin Krajmalnik <kraj@illumen.com>
2007-07-12 21:38 ` Re: How can I tell that the underlying OS is Windows? Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 7+ messages in thread
From: Benjamin Krajmalnik @ 2007-07-12 21:02 UTC (permalink / raw)
To: Adam Witney <awitney@sgul.ac.uk>; pgsql-admin; +Cc: Abraham, Danny <danny_abraham@bmc.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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: How can I tell that the underlying OS is Windows?
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
2007-07-12 15:34 ` Re: How can I tell that the underlying OS is Windows? Adam Witney <awitney@sgul.ac.uk>
2007-07-12 21:02 ` Re: How can I tell that the underlying OS is Windows? Benjamin Krajmalnik <kraj@illumen.com>
@ 2007-07-12 21:38 ` Joshua D. Drake <jd@commandprompt.com>
2007-07-12 21:44 ` Re: How can I tell that the underlying OS is Windows? Benjamin Krajmalnik <kraj@illumen.com>
0 siblings, 1 reply; 7+ messages in thread
From: Joshua D. Drake @ 2007-07-12 21:38 UTC (permalink / raw)
To: Benjamin Krajmalnik <kraj@illumen.com>; +Cc: Adam Witney <awitney@sgul.ac.uk>; pgsql-admin@postgresql.org, "Abraham, Danny" <danny_abraham@bmc.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/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: How can I tell that the underlying OS is Windows?
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
2007-07-12 15:34 ` Re: How can I tell that the underlying OS is Windows? Adam Witney <awitney@sgul.ac.uk>
2007-07-12 21:02 ` Re: How can I tell that the underlying OS is Windows? Benjamin Krajmalnik <kraj@illumen.com>
2007-07-12 21:38 ` Re: How can I tell that the underlying OS is Windows? Joshua D. Drake <jd@commandprompt.com>
@ 2007-07-12 21:44 ` Benjamin Krajmalnik <kraj@illumen.com>
2007-07-12 21:52 ` Re: How can I tell that the underlying OS is Windows? Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 7+ messages in thread
From: Benjamin Krajmalnik @ 2007-07-12 21:44 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Adam Witney <awitney@sgul.ac.uk>; pgsql-admin; Abraham, Danny <danny_abraham@bmc.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/
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: How can I tell that the underlying OS is Windows?
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
2007-07-12 15:34 ` Re: How can I tell that the underlying OS is Windows? Adam Witney <awitney@sgul.ac.uk>
2007-07-12 21:02 ` Re: How can I tell that the underlying OS is Windows? Benjamin Krajmalnik <kraj@illumen.com>
2007-07-12 21:38 ` Re: How can I tell that the underlying OS is Windows? Joshua D. Drake <jd@commandprompt.com>
2007-07-12 21:44 ` Re: How can I tell that the underlying OS is Windows? Benjamin Krajmalnik <kraj@illumen.com>
@ 2007-07-12 21:52 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 7+ messages in thread
From: Joshua D. Drake @ 2007-07-12 21:52 UTC (permalink / raw)
To: Benjamin Krajmalnik <kraj@illumen.com>; +Cc: Adam Witney <awitney@sgul.ac.uk>; pgsql-admin@postgresql.org, "Abraham, Danny" <danny_abraham@bmc.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/
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2007-07-12 21:52 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-12 15:13 How can I tell that the underlying OS is Windows? Abraham, Danny <danny_abraham@bmc.com>
2007-07-12 15:27 ` Geoffrey <lists@serioustechnology.com>
2007-07-12 15:34 ` Adam Witney <awitney@sgul.ac.uk>
2007-07-12 21:02 ` Benjamin Krajmalnik <kraj@illumen.com>
2007-07-12 21:38 ` Joshua D. Drake <jd@commandprompt.com>
2007-07-12 21:44 ` Benjamin Krajmalnik <kraj@illumen.com>
2007-07-12 21:52 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox