pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: PostgreSQL on AIX
6+ messages / 4 participants
[nested] [flat]
* Re: PostgreSQL on AIX
@ 2002-06-06 10:34 D'Arcy J.M. Cain <darcy@druid.net>
2002-06-06 12:47 ` Re: PostgreSQL on AIX Travis Hoyt <thoyt@npc.net>
2002-06-08 02:51 ` Re: PostgreSQL on AIX Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 2 replies; 6+ messages in thread
From: D'Arcy J.M. Cain @ 2002-06-06 10:34 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-sql; +Cc: pgsql-sql; pgsql-hackers@postgresql.org
On June 5, 2002 12:33 pm, Bruce Momjian wrote:
> D'Arcy J.M. Cain wrote:
> > On May 13, 2002 12:50 am, Rajesh Kumar Mallah. wrote:
Catching up on an old mailbox, Bruce? :-)
> > Now if only I could get IBM to understand that. They still claim that my
> > problem is that PostgreSQL (an "unsupported" application) is doing
> > something to catch SIGKILL.
>
> First, an application can't catch SIGKILL. It never arrives to
> applications. It is supposed to pull the process with no warning.
>
> However, there are things processes can do to wedge themselves in a
> system call so they don't see the SIGKILL. Of course, as soon as they
> return from the system call, they die.
Exactly. What IBM was saying was was that we were "catching" SIGKILL and I
could not convince the (supposedly technical) IBMers that they were talking
out their ass.
Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it
happens this project is back on the table for me so it is interesting that
your email popped up now. I just compiled the latest version of PostgreSQL
on my AIX system and it generated lots of errors and then completed and
installed fine. Makes me sort of nervous. We'll see how it goes. Anyone
have any horror/success stories about PostgreSQL on AIX for me?
Changed subject and mailing list.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL on AIX
2002-06-06 10:34 Re: PostgreSQL on AIX D'Arcy J.M. Cain <darcy@druid.net>
@ 2002-06-06 12:47 ` Travis Hoyt <thoyt@npc.net>
2002-06-08 02:51 ` Re: PostgreSQL on AIX Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 6+ messages in thread
From: Travis Hoyt @ 2002-06-06 12:47 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-sql
I've been using PosgreSQL 7.2 on AIX 4.3.3 with no probelms at all.
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of D'Arcy J.M. Cain
Sent: Thursday, June 06, 2002 6:35 AM
To: Bruce Momjian; pgsql-sql@postgresql.org
Cc: pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [SQL] PostgreSQL on AIX
On June 5, 2002 12:33 pm, Bruce Momjian wrote:
> D'Arcy J.M. Cain wrote:
> > On May 13, 2002 12:50 am, Rajesh Kumar Mallah. wrote:
Catching up on an old mailbox, Bruce? :-)
> > Now if only I could get IBM to understand that. They still claim that
my
> > problem is that PostgreSQL (an "unsupported" application) is doing
> > something to catch SIGKILL.
>
> First, an application can't catch SIGKILL. It never arrives to
> applications. It is supposed to pull the process with no warning.
>
> However, there are things processes can do to wedge themselves in a
> system call so they don't see the SIGKILL. Of course, as soon as they
> return from the system call, they die.
Exactly. What IBM was saying was was that we were "catching" SIGKILL and
I
could not convince the (supposedly technical) IBMers that they were
talking
out their ass.
Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it
happens this project is back on the table for me so it is interesting that
your email popped up now. I just compiled the latest version of
PostgreSQL
on my AIX system and it generated lots of errors and then completed and
installed fine. Makes me sort of nervous. We'll see how it goes. Anyone
have any horror/success stories about PostgreSQL on AIX for me?
Changed subject and mailing list.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.0K) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL on AIX
2002-06-06 10:34 Re: PostgreSQL on AIX D'Arcy J.M. Cain <darcy@druid.net>
2002-06-06 12:47 ` Re: PostgreSQL on AIX Travis Hoyt <thoyt@npc.net>
@ 2002-06-08 02:51 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2002-06-08 02:51 UTC (permalink / raw)
To: Travis Hoyt <thoyt@npc.net>; +Cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org, Tatsuo Ishii <t-ishii@sra.co.jp>
Also, Tatsuo uses AIX a lot and knows all the issues.
---------------------------------------------------------------------------
Travis Hoyt wrote:
> I've been using PosgreSQL 7.2 on AIX 4.3.3 with no probelms at all.
>
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of D'Arcy J.M. Cain
> Sent: Thursday, June 06, 2002 6:35 AM
> To: Bruce Momjian; pgsql-sql@postgresql.org
> Cc: pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org
> Subject: Re: [SQL] PostgreSQL on AIX
>
>
> On June 5, 2002 12:33 pm, Bruce Momjian wrote:
> > D'Arcy J.M. Cain wrote:
> > > On May 13, 2002 12:50 am, Rajesh Kumar Mallah. wrote:
>
> Catching up on an old mailbox, Bruce? :-)
>
> > > Now if only I could get IBM to understand that. They still claim that
> my
> > > problem is that PostgreSQL (an "unsupported" application) is doing
> > > something to catch SIGKILL.
> >
> > First, an application can't catch SIGKILL. It never arrives to
> > applications. It is supposed to pull the process with no warning.
> >
> > However, there are things processes can do to wedge themselves in a
> > system call so they don't see the SIGKILL. Of course, as soon as they
> > return from the system call, they die.
>
> Exactly. What IBM was saying was was that we were "catching" SIGKILL and
> I
> could not convince the (supposedly technical) IBMers that they were
> talking
> out their ass.
>
> Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it
> happens this project is back on the table for me so it is interesting that
> your email popped up now. I just compiled the latest version of
> PostgreSQL
> on my AIX system and it generated lots of errors and then completed and
> installed fine. Makes me sort of nervous. We'll see how it goes. Anyone
> have any horror/success stories about PostgreSQL on AIX for me?
>
> Changed subject and mailing list.
>
> --
> D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
> http://www.druid.net/darcy/ | and a sheep voting on
> +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL on AIX
2002-06-06 10:34 Re: PostgreSQL on AIX D'Arcy J.M. Cain <darcy@druid.net>
@ 2002-06-08 02:51 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2002-06-08 02:51 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; +Cc: pgsql-sql
D'Arcy J.M. Cain wrote:
> On June 5, 2002 12:33 pm, Bruce Momjian wrote:
> > D'Arcy J.M. Cain wrote:
> > > On May 13, 2002 12:50 am, Rajesh Kumar Mallah. wrote:
>
> Catching up on an old mailbox, Bruce? :-)
>
> > > Now if only I could get IBM to understand that. They still claim that my
> > > problem is that PostgreSQL (an "unsupported" application) is doing
> > > something to catch SIGKILL.
> >
> > First, an application can't catch SIGKILL. It never arrives to
> > applications. It is supposed to pull the process with no warning.
> >
> > However, there are things processes can do to wedge themselves in a
> > system call so they don't see the SIGKILL. Of course, as soon as they
> > return from the system call, they die.
>
> Exactly. What IBM was saying was was that we were "catching" SIGKILL and I
> could not convince the (supposedly technical) IBMers that they were talking
> out their ass.
Yes, they didn't know "catching" from "ignoring because in
uninterruptible system call".
> Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it
> happens this project is back on the table for me so it is interesting that
> your email popped up now. I just compiled the latest version of PostgreSQL
> on my AIX system and it generated lots of errors and then completed and
> installed fine. Makes me sort of nervous. We'll see how it goes. Anyone
> have any horror/success stories about PostgreSQL on AIX for me?
Would you check those error/warnings and send us patches or a list of
them. Sometimes different compilers like AIX can show problems gcc
doesn't.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] PostgreSQL on AIX
@ 2002-06-07 14:23 Zeugswetter Andreas SB SD <ZeugswetterA@spardat.at>
2002-06-08 02:53 ` Re: [HACKERS] PostgreSQL on AIX Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Zeugswetter Andreas SB SD @ 2002-06-07 14:23 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-sql
> Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it
> happens this project is back on the table for me so it is interesting that
> your email popped up now. I just compiled the latest version of PostgreSQL
> on my AIX system and it generated lots of errors and then completed and
> installed fine. Makes me sort of nervous. We'll see how it goes. Anyone
> have any horror/success stories about PostgreSQL on AIX for me?
The "errors" are mostly duplicate symbol warnings, that are part of generating
a shared lib on AIX (in a mostly gcc and xlc independent way), and can be safely
ignored.
The imho most needed effort for AIX would be to switch the TAS stuff from
cs() to fetch_and_or() or a PowerPC assembler or the test_and_set() that is
undocumented/intended for kernel, see discussions from last year.
The fetch_and_or() is a lot faster on multi processor systems but a little
slower on single processor. But cs() is documented as depricated, so ...
I might get round to doing this.
Andreas
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] PostgreSQL on AIX
2002-06-07 14:23 Re: [HACKERS] PostgreSQL on AIX Zeugswetter Andreas SB SD <ZeugswetterA@spardat.at>
@ 2002-06-08 02:53 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2002-06-08 02:53 UTC (permalink / raw)
To: Zeugswetter Andreas SB SD <ZeugswetterA@spardat.at>; +Cc: pgsql-hackers@postgresql.org; pgsql-sql
Zeugswetter Andreas SB SD wrote:
>
> > Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it
> > happens this project is back on the table for me so it is interesting that
> > your email popped up now. I just compiled the latest version of PostgreSQL
> > on my AIX system and it generated lots of errors and then completed and
> > installed fine. Makes me sort of nervous. We'll see how it goes. Anyone
> > have any horror/success stories about PostgreSQL on AIX for me?
>
> The "errors" are mostly duplicate symbol warnings, that are part of generating
> a shared lib on AIX (in a mostly gcc and xlc independent way), and can be safely
> ignored.
>
> The imho most needed effort for AIX would be to switch the TAS stuff from
> cs() to fetch_and_or() or a PowerPC assembler or the test_and_set() that is
> undocumented/intended for kernel, see discussions from last year.
Yes, TODO has:
* Evaluate AIX cs() spinlock macro for performance optimizations (Tatsuo)
> The fetch_and_or() is a lot faster on multi processor systems but a little
> slower on single processor. But cs() is documented as depricated, so ...
Should I update the TODO item?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2002-06-08 02:53 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-06 10:34 Re: PostgreSQL on AIX D'Arcy J.M. Cain <darcy@druid.net>
2002-06-06 12:47 ` Travis Hoyt <thoyt@npc.net>
2002-06-08 02:51 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-06-08 02:51 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-06-07 14:23 Re: [HACKERS] PostgreSQL on AIX Zeugswetter Andreas SB SD <ZeugswetterA@spardat.at>
2002-06-08 02:53 ` Bruce Momjian <pgman@candle.pha.pa.us>
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