public inbox for [email protected]  
help / color / mirror / Atom feed
SELinux & Redhat
24+ messages / 16 participants
[nested] [flat]

* SELinux & Redhat
@ 2005-05-06 14:43 Jeff - <[email protected]>
  2005-05-06 14:55 ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  0 siblings, 2 replies; 24+ messages in thread

From: Jeff - @ 2005-05-06 14:43 UTC (permalink / raw)
  To: pgsql-docs

I think we should put some notes about SELinux causing issues with  
pgsql in the OS notes or FAQ.

Myself and a few coworkers just spent a few hours tracking down why  
pg_dump would produce no output.  We'd fire it up in strace and we'd  
see all the successful write calls, but not output.

We copied pg_dump from another machine and it worked fine, and that  
machine was running the same OS & pg rpms.

Eventually we found it was SELinux was preventing pg_dump from  
producing output.

Any thoughts?  I could write up a short blurb but I'm not terribly  
familiar with selinux. we just disabled the whole thing to make it work.

For the record:
CentOS 4.0
postgresql-8.0.2-1PGDG.i686.rpm (and associated) rpms from  
postgresql.org's ftp server

--
Jeff Trout <[email protected]>
http://www.jefftrout.com/
http://www.stuarthamm.net/







^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
@ 2005-05-06 14:55 ` Bruce Momjian <[email protected]>
  2005-05-06 15:13   ` Re: SELinux & Redhat Peter Eisentraut <[email protected]>
  1 sibling, 1 reply; 24+ messages in thread

From: Bruce Momjian @ 2005-05-06 14:55 UTC (permalink / raw)
  To: Jeff - <[email protected]>; +Cc: pgsql-docs

Jeff - wrote:
> I think we should put some notes about SELinux causing issues with  
> pgsql in the OS notes or FAQ.
> 
> Myself and a few coworkers just spent a few hours tracking down why  
> pg_dump would produce no output.  We'd fire it up in strace and we'd  
> see all the successful write calls, but not output.
> 
> We copied pg_dump from another machine and it worked fine, and that  
> machine was running the same OS & pg rpms.
> 
> Eventually we found it was SELinux was preventing pg_dump from  
> producing output.
> 
> Any thoughts?  I could write up a short blurb but I'm not terribly  
> familiar with selinux. we just disabled the whole thing to make it work.
> 
> For the record:
> CentOS 4.0
> postgresql-8.0.2-1PGDG.i686.rpm (and associated) rpms from  
> postgresql.org's ftp server

A blurb about what?  No one else has reported such a problem so we have
no reason to assume it isn't a misconfiguration on your end.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 14:55 ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
@ 2005-05-06 15:13   ` Peter Eisentraut <[email protected]>
  2005-05-06 15:21     ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
  2005-05-06 15:28     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  0 siblings, 2 replies; 24+ messages in thread

From: Peter Eisentraut @ 2005-05-06 15:13 UTC (permalink / raw)
  To: Bruce Momjian <[email protected]>; +Cc: Jeff - <[email protected]>; pgsql-docs

Am Freitag, 6. Mai 2005 16:55 schrieb Bruce Momjian:
> A blurb about what?  No one else has reported such a problem so we have
> no reason to assume it isn't a misconfiguration on your end.

*Countless* people are constantly reporting problems that can be attributed to 
selinux.  We really need to write something about it.  Of course, most 
people, including myself, just solve these issues by turning off selinux, but 
I'd be interested in a more thorough treatment.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 14:55 ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
  2005-05-06 15:13   ` Re: SELinux & Redhat Peter Eisentraut <[email protected]>
@ 2005-05-06 15:21     ` Bruce Momjian <[email protected]>
  2005-05-06 15:42       ` Re: SELinux & Redhat Alvaro Herrera <[email protected]>
  1 sibling, 1 reply; 24+ messages in thread

From: Bruce Momjian @ 2005-05-06 15:21 UTC (permalink / raw)
  To: Peter Eisentraut <[email protected]>; +Cc: Jeff - <[email protected]>; pgsql-docs

Peter Eisentraut wrote:
> Am Freitag, 6. Mai 2005 16:55 schrieb Bruce Momjian:
> > A blurb about what?  No one else has reported such a problem so we have
> > no reason to assume it isn't a misconfiguration on your end.
> 
> *Countless* people are constantly reporting problems that can be attributed to 
> selinux.  We really need to write something about it.  Of course, most 
> people, including myself, just solve these issues by turning off selinux, but 
> I'd be interested in a more thorough treatment.

Who makes SE Linux?  Is it SuSE?  What would we say in an FAQ?  I would
rather report something to people using that OS.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 14:55 ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
  2005-05-06 15:13   ` Re: SELinux & Redhat Peter Eisentraut <[email protected]>
  2005-05-06 15:21     ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
@ 2005-05-06 15:42       ` Alvaro Herrera <[email protected]>
  0 siblings, 0 replies; 24+ messages in thread

From: Alvaro Herrera @ 2005-05-06 15:42 UTC (permalink / raw)
  To: Bruce Momjian <[email protected]>; +Cc: Peter Eisentraut <[email protected]>; Jeff - <[email protected]>; pgsql-docs

On Fri, May 06, 2005 at 11:21:26AM -0400, Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Am Freitag, 6. Mai 2005 16:55 schrieb Bruce Momjian:
> > > A blurb about what?  No one else has reported such a problem so we have
> > > no reason to assume it isn't a misconfiguration on your end.
> > 
> > *Countless* people are constantly reporting problems that can be attributed to 
> > selinux.  We really need to write something about it.  Of course, most 
> > people, including myself, just solve these issues by turning off selinux, but 
> > I'd be interested in a more thorough treatment.
> 
> Who makes SE Linux?  Is it SuSE?  What would we say in an FAQ?  I would
> rather report something to people using that OS.

It's linux-distribution agnostic.  Redhat is including it on its
distributions, as is Debian.  Not sure about the others but that is
already a large population.  (Of course it's Linux only.)

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 14:55 ` Re: SELinux & Redhat Bruce Momjian <[email protected]>
  2005-05-06 15:13   ` Re: SELinux & Redhat Peter Eisentraut <[email protected]>
@ 2005-05-06 15:28     ` Tom Lane <[email protected]>
  1 sibling, 0 replies; 24+ messages in thread

From: Tom Lane @ 2005-05-06 15:28 UTC (permalink / raw)
  To: Peter Eisentraut <[email protected]>; +Cc: Bruce Momjian <[email protected]>; Jeff - <[email protected]>; pgsql-docs

Peter Eisentraut <[email protected]> writes:
> Am Freitag, 6. Mai 2005 16:55 schrieb Bruce Momjian:
>> A blurb about what?  No one else has reported such a problem so we have
>> no reason to assume it isn't a misconfiguration on your end.

> *Countless* people are constantly reporting problems that can be
> attributed to selinux.

That's mostly because selinux outright broke postgres in the initial
FC3 releases :-(.  I have to take most of the blame for this myself;
I didn't realize there might be problems, and didn't test adequately.
I believe the problems are all resolved in the latest Fedora RPMs,
though this pg_dump report may be something new.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
@ 2005-05-06 15:23 ` Tom Lane <[email protected]>
  2005-05-06 15:33   ` Re: SELinux & Redhat Devrim GUNDUZ <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  1 sibling, 2 replies; 24+ messages in thread

From: Tom Lane @ 2005-05-06 15:23 UTC (permalink / raw)
  To: Jeff - <[email protected]>; +Cc: pgsql-docs

Jeff - <[email protected]> writes:
> Eventually we found it was SELinux was preventing pg_dump from  
> producing output.

That's a new one on me.  Why was it doing that --- mislabeling on
the pg_dump executable, or what?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
@ 2005-05-06 15:33   ` Devrim GUNDUZ <[email protected]>
  1 sibling, 0 replies; 24+ messages in thread

From: Devrim GUNDUZ @ 2005-05-06 15:33 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: Jeff - <[email protected]>; pgsql-docs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 6 May 2005, Tom Lane wrote:

> Jeff - <[email protected]> writes:
>> Eventually we found it was SELinux was preventing pg_dump from
>> producing output.
>
> That's a new one on me.  Why was it doing that --- mislabeling on
> the pg_dump executable, or what?

Looking at the strace report that someone has sent me before, there is a 
problem with devices:

===================================================================
<snip>
fstat64(1, {st_mode=S_IFCHR|0666, st_rdev=makedev(1, 3), ...}) = 0
ioctl(1, SNDCTL_TMR_TIMEBASE or TCGETS, 0xbfe16a8c) = -1 ENOTTY
(Inappropriate ioctl for device)
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0xb7dee000
write(1, "pg_dump dumps a database as a te"..., 2367) = 2367
munmap(0xb7dee000, 4096)                = 0
exit_group(0)                           = ?
===================================================================

This one is from a server with SELinux enabled. My server does not produce 
this, and uses virtual console (as expected?). However with SELinux 
enabled, it wants to use ramdisk (expected? I think no...)

Regards,
- --
Devrim GUNDUZ 
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr                      http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFCe45Btl86P3SPfQ4RAhpbAJ0UhBh8dlOEpPsNm2NB1QIJ82X2swCg7JOg
A1OCBrZRHxoOPQo0U9hNdNY=
=ENTC
-----END PGP SIGNATURE-----



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
@ 2005-05-06 15:46   ` Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  1 sibling, 1 reply; 24+ messages in thread

From: Jeff - @ 2005-05-06 15:46 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: pgsql-docs


On May 6, 2005, at 11:23 AM, Tom Lane wrote:

> Jeff - <[email protected]> writes:
>
>> Eventually we found it was SELinux was preventing pg_dump from
>> producing output.
>>
>
> That's a new one on me.  Why was it doing that --- mislabeling on
> the pg_dump executable, or what?
>

We've got a stock CentOS 4 install
I nabbed the rpms I mentioned (8.0.2) (-rw-r--r--  1 root root  
2955126 May  4 11:51 postgresql-8.0.2-1PGDG.i686.rpm & company)

from /etc/selinux/targeted/contexts/files/file_contexts I see

file_contexts:/usr/bin/pg_dump  --       
system_u:object_r:postgresql_exec_t
file_contexts:/usr/bin/pg_dumpall       --       
system_u:object_r:postgresql_exec_t

Syslog logs:

May  6 09:01:25 starslice kernel: audit(1115384485.559:0): avc:   
denied  { execute_no_trans } for  pid=4485 exe=/bin/bash path=/usr/ 
bin/pg_dump dev=sda3 ino=5272966  
scontext=user_u:system_r:postgresql_t  
tcontext=system_u:object_r:postgresql_exec_t tclass=file


SELinux is on and under system-config-securitylevel's selinux tab,  
"SELinux Protection services" disable postgresql is not clicked.

When I run pg_dump w/these settings the following happens running  
pg_dump (.broken is hte original file from the rpm)

bash-3.00$ /usr/bin/pg_dump.broken planet
bash-3.00$

Stracing it I get
....
write(1, "file_pkey; Type: CONSTRAINT; Sch"..., 4096) = 4096
write(1, "\n-- Name: userprofile_pkey; Type"..., 4096) = 4096
write(1, "_idx_1 OWNER TO planet;\n\n--\n-- N"..., 4096) = 4096
rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0
send(3, "X\0\0\0\4", 5, 0)              = 5
rt_sigaction(SIGPIPE, {SIG_DFL}, {SIG_IGN}, 8) = 0
close(3)                                = 0
write(1, "me: top3_cmtcount_idx; Type: IND"..., 3992) = 3992
munmap(0xb7df0000, 4096)                = 0
exit_group(0)                           = ?


and what is interesting is it seems only sometimes things get logged  
to syslog about the failure.

If I copy the file (not mv) it will work (possibly due to xattrs  
being set?)

and if I disable pg checking, (or selinux all together) it works.


COOL, HUH?

--
Jeff Trout <[email protected]>
http://www.jefftrout.com/
http://www.stuarthamm.net/







^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
@ 2005-05-06 15:57     ` Tom Lane <[email protected]>
  2005-05-06 17:37       ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  0 siblings, 2 replies; 24+ messages in thread

From: Tom Lane @ 2005-05-06 15:57 UTC (permalink / raw)
  To: Jeff - <[email protected]>; +Cc: pgsql-docs

Jeff - <[email protected]> writes:
> When I run pg_dump w/these settings the following happens running  
> pg_dump (.broken is hte original file from the rpm)

> bash-3.00$ /usr/bin/pg_dump.broken planet
> bash-3.00$

Does it work if you direct the output into a file, instead of letting it
come to your terminal (which seems a bit useless anyway)?

I've been bugging dwalsh about the fact that the selinux policy
disallows writes to /dev/tty to things it thinks are daemons;
that seems pretty stupid.  But pg_dump isn't a daemon so there's
no reason for it to be restricted this way anyway...

> and what is interesting is it seems only sometimes things get logged  
> to syslog about the failure.

Someone told me there's a rate limit on selinux complaints going to
syslog, to keep it from swamping your logs.  I suspect there are some
actual bugs there too, because I've noticed cases where an action was
blocked and there wasn't any log message, nor enough activity to
justify a rate limit.  Feel free to file a bugzilla report if you can
get a reproducible case.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: SELinux & Redhat
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
@ 2005-05-06 17:37       ` Jeff - <[email protected]>
  1 sibling, 0 replies; 24+ messages in thread

From: Jeff - @ 2005-05-06 17:37 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: pgsql-docs


On May 6, 2005, at 11:57 AM, Tom Lane wrote:
>> bash-3.00$ /usr/bin/pg_dump.broken planet
>> bash-3.00$
>>
>
> Does it work if you direct the output into a file, instead of  
> letting it
> come to your terminal (which seems a bit useless anyway)?
>

Interesting.

Redirecting it worked, but I'm pretty sure at one point it didn't  
work. (I could also be smoking crack).

Hmm.. piping it into another app worked.

I only found out about this when another developer here tried to run  
it and got nothing.

in any case, it might be something useful to jot somewhere.

--
Jeff Trout <[email protected]>
http://www.jefftrout.com/
http://www.stuarthamm.net/







^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
@ 2005-05-06 21:39       ` Mischa Sandberg <[email protected]>
  2005-05-06 22:09         ` Re: Whence the Opterons? Ian Meyer <[email protected]>
  2005-05-06 22:29         ` Re: Whence the Opterons? Steve Poe <[email protected]>
  2005-05-07 14:57         ` Re: Whence the Opterons? Andrew Sullivan <[email protected]>
  2005-05-08 21:59         ` Re: Whence the Opterons? Sam Vilain <[email protected]>
  2005-05-09 02:17         ` Re: Whence the Opterons? Geoffrey <[email protected]>
  2005-06-10 12:34         ` Re: Whence the Opterons? Richard Rowell <[email protected]>
  1 sibling, 6 replies; 24+ messages in thread

From: Mischa Sandberg @ 2005-05-06 21:39 UTC (permalink / raw)
  To: [email protected]

After reading the comparisons between Opteron and Xeon processors for Linux,
I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison.

IBM, Sun and HP have their fairly pricey Opteron systems.
The IT people are not swell about unsupported purchases off ebay.
Anyone care to suggest any other vendors/distributors?
Looking for names with national support, so that we can recommend as much to our
customers.

Many thanks in advance.
-- 
"Dreams come true, not free." -- S.Sondheim




^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
@ 2005-05-06 22:09         ` Ian Meyer <[email protected]>
  5 siblings, 0 replies; 24+ messages in thread

From: Ian Meyer @ 2005-05-06 22:09 UTC (permalink / raw)
  To: Mischa Sandberg <[email protected]>; +Cc: [email protected]

Mischa,

What kind of budget are you on? penguincomputing.com deals with
Opteron servers. I looked at a couple of their servers before deciding
on a HP DL145.

Ian

On 5/6/05, Mischa Sandberg <[email protected]> wrote:
> After reading the comparisons between Opteron and Xeon processors for Linux,
> I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison.
> 
> IBM, Sun and HP have their fairly pricey Opteron systems.
> The IT people are not swell about unsupported purchases off ebay.
> Anyone care to suggest any other vendors/distributors?
> Looking for names with national support, so that we can recommend as much to our
> customers.
> 
> Many thanks in advance.
> --
> "Dreams come true, not free." -- S.Sondheim
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
@ 2005-05-06 22:29         ` Steve Poe <[email protected]>
  2005-05-06 22:44           ` Re: Whence the Opterons? Gavin M. Roy <[email protected]>
  5 siblings, 1 reply; 24+ messages in thread

From: Steve Poe @ 2005-05-06 22:29 UTC (permalink / raw)
  To: Mischa Sandberg <[email protected]>; +Cc: [email protected]

>IBM, Sun and HP have their fairly pricey Opteron systems.
>The IT people are not swell about unsupported purchases off ebay.


Mischa,

I certainly understand your concern, but the  price and support 
sometimes go hand-in-hand. You may have to pick your batttles if your 
want more bang for the buck or more support. I might be wrong on this, 
but not everything you buy on E-Bay is unsupported.

We purchase a dual Operton from Sun off their E-Bay store  for about $3K 
less than the "buy it now" price.

 From an IT perspective, support is not as critical if I can do it 
myself. If it is for business 24/7 operations, then the company should 
be able to put some money behind what they want to put their business 
on. Your mileage may vary.

Steve





^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  2005-05-06 22:29         ` Re: Whence the Opterons? Steve Poe <[email protected]>
@ 2005-05-06 22:44           ` Gavin M. Roy <[email protected]>
  0 siblings, 0 replies; 24+ messages in thread

From: Gavin M. Roy @ 2005-05-06 22:44 UTC (permalink / raw)
  To: Steve Poe <[email protected]>; +Cc: Mischa Sandberg <[email protected]>; [email protected]

Please wait a week before buying Sun v20z's or v40z's from off of Ebay 
(j/k). (As I'm in the process of picking up a few)  From everything I 
hear the v20z/v40z's are a great way to go and I'll know more in 15 days 
or so.

Regards,

Gavin


Steve Poe wrote:

>> IBM, Sun and HP have their fairly pricey Opteron systems.
>> The IT people are not swell about unsupported purchases off ebay.
>
>
>
> Mischa,
>
> I certainly understand your concern, but the  price and support 
> sometimes go hand-in-hand. You may have to pick your batttles if your 
> want more bang for the buck or more support. I might be wrong on this, 
> but not everything you buy on E-Bay is unsupported.
>
> We purchase a dual Operton from Sun off their E-Bay store  for about 
> $3K less than the "buy it now" price.
>
> From an IT perspective, support is not as critical if I can do it 
> myself. If it is for business 24/7 operations, then the company should 
> be able to put some money behind what they want to put their business 
> on. Your mileage may vary.
>
> Steve
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org





^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
@ 2005-05-07 14:57         ` Andrew Sullivan <[email protected]>
  2005-05-07 21:00           ` Re: Whence the Opterons? Josh Berkus <[email protected]>
  5 siblings, 1 reply; 24+ messages in thread

From: Andrew Sullivan @ 2005-05-07 14:57 UTC (permalink / raw)
  To: [email protected]

On Fri, May 06, 2005 at 02:39:11PM -0700, Mischa Sandberg wrote:
> IBM, Sun and HP have their fairly pricey Opteron systems.

We've had some quite good experiences with the HP boxes.  They're not
cheap, it's true, but boy are they sweet.

A


-- 
Andrew Sullivan  | [email protected]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism. 
                --Brad Holland



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  2005-05-07 14:57         ` Re: Whence the Opterons? Andrew Sullivan <[email protected]>
@ 2005-05-07 21:00           ` Josh Berkus <[email protected]>
  2005-05-13 21:07             ` Re: Whence the Opterons? Andrew Sullivan <[email protected]>
  0 siblings, 1 reply; 24+ messages in thread

From: Josh Berkus @ 2005-05-07 21:00 UTC (permalink / raw)
  To: Andrew Sullivan <[email protected]>; +Cc: [email protected]

A-

> On Fri, May 06, 2005 at 02:39:11PM -0700, Mischa Sandberg wrote:
> > IBM, Sun and HP have their fairly pricey Opteron systems.
>
> We've had some quite good experiences with the HP boxes.  They're not
> cheap, it's true, but boy are they sweet.

Question, though: is HP still using their proprietary RAID card?   And, if so, 
have they fixed its performance problems?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  2005-05-07 14:57         ` Re: Whence the Opterons? Andrew Sullivan <[email protected]>
  2005-05-07 21:00           ` Re: Whence the Opterons? Josh Berkus <[email protected]>
@ 2005-05-13 21:07             ` Andrew Sullivan <[email protected]>
  0 siblings, 0 replies; 24+ messages in thread

From: Andrew Sullivan @ 2005-05-13 21:07 UTC (permalink / raw)
  To: [email protected]

On Sat, May 07, 2005 at 02:00:34PM -0700, Josh Berkus wrote:
> 
> Question, though: is HP still using their proprietary RAID card?   And, if so, 
> have they fixed its performance problems?

According to my folks here, we're using the CCISS controllers, so I
guess they are.  The systems are nevertheless performing very well --
we did a load test that was pretty impressive.  Also, Chris Browne
pointed me to this for the drivers:

http://sourceforge.net/projects/cciss/

A

-- 
Andrew Sullivan  | [email protected]
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
		--Alexander Hamilton



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
@ 2005-05-08 21:59         ` Sam Vilain <[email protected]>
  2005-05-08 22:33           ` Re: Whence the Opterons? Mischa Sandberg <[email protected]>
  5 siblings, 1 reply; 24+ messages in thread

From: Sam Vilain @ 2005-05-08 21:59 UTC (permalink / raw)
  To: Mischa Sandberg <[email protected]>; +Cc: [email protected]

Mischa Sandberg wrote:
> After reading the comparisons between Opteron and Xeon processors for Linux,
> I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison.
> IBM, Sun and HP have their fairly pricey Opteron systems.
> The IT people are not swell about unsupported purchases off ebay.
> Anyone care to suggest any other vendors/distributors?

Check out the Tyan Transport systems.  Tyan are an ex Sparc clone manufacturer, and
released the second available Opteron board - widely considered the first serious
Opteron board to hit the market.

Sam.



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  2005-05-08 21:59         ` Re: Whence the Opterons? Sam Vilain <[email protected]>
@ 2005-05-08 22:33           ` Mischa Sandberg <[email protected]>
  0 siblings, 0 replies; 24+ messages in thread

From: Mischa Sandberg @ 2005-05-08 22:33 UTC (permalink / raw)
  To: Sam Vilain <[email protected]>; +Cc: [email protected]

Thanks to everyone for their pointers to suppliers of Opteron systems.

The system I'm pricing is under a tighter budget than a production machine,
because it will be for perftests. Our customers tend to run on Dells but
occasionally run on (Sun) Opterons. 





^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
@ 2005-05-09 02:17         ` Geoffrey <[email protected]>
  2005-05-09 15:18           ` Re: Whence the Opterons? John A Meinel <[email protected]>
  5 siblings, 1 reply; 24+ messages in thread

From: Geoffrey @ 2005-05-09 02:17 UTC (permalink / raw)
  To: Mischa Sandberg <[email protected]>; +Cc: [email protected]

Mischa Sandberg wrote:
> After reading the comparisons between Opteron and Xeon processors for Linux,
> I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison.
> 
> IBM, Sun and HP have their fairly pricey Opteron systems.
> The IT people are not swell about unsupported purchases off ebay.
> Anyone care to suggest any other vendors/distributors?
> Looking for names with national support, so that we can recommend as much to our
> customers.

Monarch Computer http://www.monarchcomputer.com/

They have prebuilt and custom built systems.

-- 
Until later, Geoffrey



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  2005-05-09 02:17         ` Re: Whence the Opterons? Geoffrey <[email protected]>
@ 2005-05-09 15:18           ` John A Meinel <[email protected]>
  2005-05-09 20:00             ` Re: Whence the Opterons? Geoffrey <[email protected]>
  0 siblings, 1 reply; 24+ messages in thread

From: John A Meinel @ 2005-05-09 15:18 UTC (permalink / raw)
  To: Geoffrey <[email protected]>; +Cc: Mischa Sandberg <[email protected]>; [email protected]

Geoffrey wrote:
> Mischa Sandberg wrote:
>
>> After reading the comparisons between Opteron and Xeon processors for
>> Linux,
>> I'd like to add an Opteron box to our stable of Dells and Sparcs, for
>> comparison.
>>
>> IBM, Sun and HP have their fairly pricey Opteron systems.
>> The IT people are not swell about unsupported purchases off ebay.
>> Anyone care to suggest any other vendors/distributors?
>> Looking for names with national support, so that we can recommend as
>> much to our
>> customers.
>
>
> Monarch Computer http://www.monarchcomputer.com/
>
> They have prebuilt and custom built systems.
>

I believe we have had some issues with their workstation class systems.
Just a high rate of part failure, and DOA systems.

I believe they RMA'd without too great of difficulties, but it was
something like 50%.

John
=:->


Attachments:

  [application/pgp-signature] signature.asc (251B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
  2005-05-09 02:17         ` Re: Whence the Opterons? Geoffrey <[email protected]>
  2005-05-09 15:18           ` Re: Whence the Opterons? John A Meinel <[email protected]>
@ 2005-05-09 20:00             ` Geoffrey <[email protected]>
  0 siblings, 0 replies; 24+ messages in thread

From: Geoffrey @ 2005-05-09 20:00 UTC (permalink / raw)
  To: [email protected]

John A Meinel wrote:
> Geoffrey wrote:
> 
>> Mischa Sandberg wrote:
>>
>>> After reading the comparisons between Opteron and Xeon processors for
>>> Linux,
>>> I'd like to add an Opteron box to our stable of Dells and Sparcs, for
>>> comparison.
>>>
>>> IBM, Sun and HP have their fairly pricey Opteron systems.
>>> The IT people are not swell about unsupported purchases off ebay.
>>> Anyone care to suggest any other vendors/distributors?
>>> Looking for names with national support, so that we can recommend as
>>> much to our
>>> customers.
>>
>>
>>
>> Monarch Computer http://www.monarchcomputer.com/
>>
>> They have prebuilt and custom built systems.
>>
> 
> I believe we have had some issues with their workstation class systems.
> Just a high rate of part failure, and DOA systems.
> 
> I believe they RMA'd without too great of difficulties, but it was
> something like 50%.

Ouch, that's not been my experiences.  I'd like to hear if anyone else 
has had such problems with Monarch.

-- 
Until later, Geoffrey



^ permalink  raw  reply  [nested|flat] 24+ messages in thread

* Re: Whence the Opterons?
  2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:23 ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 15:46   ` Re: SELinux & Redhat Jeff - <[email protected]>
  2005-05-06 15:57     ` Re: SELinux & Redhat Tom Lane <[email protected]>
  2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
@ 2005-06-10 12:34         ` Richard Rowell <[email protected]>
  5 siblings, 0 replies; 24+ messages in thread

From: Richard Rowell @ 2005-06-10 12:34 UTC (permalink / raw)
  To: [email protected]

I will second the nod to Penguin computing.  We have a bit of Penguin
hardware here (though the majority is Dell).  We did have issues with
one machine a couple of years ago, but Penguin was very pro-active in
addressing that.

We recently picked up a Dual Opteron system from them and have been very
pleased with it so far.  

I would be careful of the RHES that it ships with though.  We had
machine lockups immediately after the suggested  kernel update (had to
down grade manually).  Also, the RH supplied Postgres binary has issues,
so you would need to compile Postgres yourself until the next RH update.

On Fri, 2005-05-06 at 14:39 -0700, Mischa Sandberg wrote:
> After reading the comparisons between Opteron and Xeon processors for Linux,
> I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison.
> 
> IBM, Sun and HP have their fairly pricey Opteron systems.
> The IT people are not swell about unsupported purchases off ebay.
> Anyone care to suggest any other vendors/distributors?
> Looking for names with national support, so that we can recommend as much to our
> customers.
> 
> Many thanks in advance.
-- 
--
Richard Rowell
[email protected]
Bowman Systems
(318) 213-8780





^ permalink  raw  reply  [nested|flat] 24+ messages in thread


end of thread, other threads:[~2005-06-10 12:34 UTC | newest]

Thread overview: 24+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-06 14:43 SELinux & Redhat Jeff - <[email protected]>
2005-05-06 14:55 ` Bruce Momjian <[email protected]>
2005-05-06 15:13   ` Peter Eisentraut <[email protected]>
2005-05-06 15:21     ` Bruce Momjian <[email protected]>
2005-05-06 15:42       ` Alvaro Herrera <[email protected]>
2005-05-06 15:28     ` Tom Lane <[email protected]>
2005-05-06 15:23 ` Tom Lane <[email protected]>
2005-05-06 15:33   ` Devrim GUNDUZ <[email protected]>
2005-05-06 15:46   ` Jeff - <[email protected]>
2005-05-06 15:57     ` Tom Lane <[email protected]>
2005-05-06 17:37       ` Jeff - <[email protected]>
2005-05-06 21:39       ` Whence the Opterons? Mischa Sandberg <[email protected]>
2005-05-06 22:09         ` Re: Whence the Opterons? Ian Meyer <[email protected]>
2005-05-06 22:29         ` Re: Whence the Opterons? Steve Poe <[email protected]>
2005-05-06 22:44           ` Re: Whence the Opterons? Gavin M. Roy <[email protected]>
2005-05-07 14:57         ` Re: Whence the Opterons? Andrew Sullivan <[email protected]>
2005-05-07 21:00           ` Re: Whence the Opterons? Josh Berkus <[email protected]>
2005-05-13 21:07             ` Re: Whence the Opterons? Andrew Sullivan <[email protected]>
2005-05-08 21:59         ` Re: Whence the Opterons? Sam Vilain <[email protected]>
2005-05-08 22:33           ` Re: Whence the Opterons? Mischa Sandberg <[email protected]>
2005-05-09 02:17         ` Re: Whence the Opterons? Geoffrey <[email protected]>
2005-05-09 15:18           ` Re: Whence the Opterons? John A Meinel <[email protected]>
2005-05-09 20:00             ` Re: Whence the Opterons? Geoffrey <[email protected]>
2005-06-10 12:34         ` Re: Whence the Opterons? Richard Rowell <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox