Re: OID wraparound (was Re: [HACKERS] pg_depend)

2001-07-18 Thread Lamar Owen
sort of thing addressed by any SQL standard (Thomas?)? -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: OID wraparound (was Re: [HACKERS] pg_depend)

2001-07-18 Thread Lamar Owen
of _Red_Hat_ is what gives PG credibilitiy -- and, you have to admit, RH's adoption of PG does increase, in many circles, PG's credibility. Of course, PG has credibility with me for other reasons -- it was, IMHO, just a matter of time before Red Hat saw the PostgreSQL Light. -- Lama

Re: [HACKERS] What I do with PostgreSQL

2001-07-17 Thread Lamar Owen
serious test of 'scalability' no matter which way you slice it. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 2 gig file size limit

2001-07-07 Thread Lamar Owen
limit will be when making backups using pg_dump or pg_dumpall. You may need to pipe the output of those commands into a file splitting utility, and then you'll have to pipe through a reassembly utility to restore. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---

Re: [HACKERS] Pg on SMP half-powered

2001-07-07 Thread Lamar Owen
mark queries. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: 7.1.2 schedule (was Re: [HACKERS] Posted 7.1 RPMs for Mandrake 7.2)

2001-05-11 Thread Lamar Owen
've found that things like "scp" > don't respect a .cshrc umask setting, so you will likely need to check > permissions when you are working in those directories anyway. Ah. Of course, Idon't use the csh :-). But I _do_ use scp exclusively

Re: 7.1.2 schedule (was Re: [HACKERS] Posted 7.1 RPMs for Mandrake 7.2)

2001-05-11 Thread Lamar Owen
o release a 7.1-2 set that includes RPM-specific bugfixes to the initscript and files list. Thomas, which pgtcl problem are you referring to? FWIW, my extant CHANGELOG entry for the 7.1.1 RPMs currently reads: * Mon May 07 2001 Lamar Owen <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> -

Re: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Lamar Owen
ave to get myself in gear and get it done. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Lamar Owen
cvs tree. (i am also > > > curious on why it is different, and how the RPM is built). > > > > Lamar Owen and I. > > Is the current snapshot available? The current snapshot is the 7.1-1 release as of this time. >I have submitted fixes twice now for what I am fairly

Re: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Lamar Owen
all, I'd vote for > putting it in the main tree. > Perhaps src/rpm-tools/ or some such name. Let's see where the rest of core and hackers weighs in -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Lamar Owen
have no use for > it don't end up pulling/downloading it. Not counting the JDBC jars, it's a hundred K or so uncompressed. The spec file is around 30k -- a small amount of code. contrib/rpm-dist? -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadca

Re: [HACKERS] Packaging 7.1.1

2001-05-03 Thread Lamar Owen
r, otherwise I might miss it). I have a list of messages in an 'RPMS for 7.1' subfolder of my mail folder 'Postgres' that I work through for each release. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3:

Re: [HACKERS] Extrordinarily Poor Performance....

2001-05-03 Thread Lamar Owen
L 7.0.3, we could ask Alfred about his lazy vacuum patches, as they work as well for Red Hat 7 as they do for FreeBSD. Personally, I look forward to the following note being placed into the docs: VACUUM: deprecated. And the feature that makes that note possible. -- Lamar Owen WGCR Internet Radio 1

Re: [HACKERS] Packaging 7.1.1

2001-05-03 Thread Lamar Owen
fferent, and how the RPM is built). > > Lamar Owen and I. Egads! I forgot to mention Trond! My apologies! (I'm being serious...) Trond, of Red Hat; Reinhard Max, of SuSE; and Thomas Lockhart, of PostgreSQL Inc (:-)) have all been major contributors to the RPM distribution. Karl De

Re: [HACKERS] Packaging 7.1.1

2001-05-03 Thread Lamar Owen
ey're not likely to be), I am opposed to the idea -- not to keep the stuff to myself, but to not hinder the platform-neutral stance. IMHO, of course. Of course, there are many projects that DO include all the files necessary to build RPMs from their Official Tarball (TM). Bruce, should porti

Re: [HACKERS] start / stop scripts question

2001-04-24 Thread Lamar Owen
Bruce Momjian wrote: > > I would like to know myself. I just did a recursive grep of the entire > PostgreSQL tree and don't see it. My guess is that it is part of the > RPM. Not sure who to report that to. I know Lamar Owen works on it, > but I don't know if he i

[HACKERS] Another news story in need of 'enlightenment'

2001-04-17 Thread Lamar Owen
tent/enterprise/datawatch/101041201.asp He seems to be ok on some things, though. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 7.1 on 7.1

2001-04-16 Thread Lamar Owen
for 7.1 on 7.1 in our RPM area. Red Hat 7.1 is _nice_. The PostgreSQL speed appears to be very good, compared to 6.2/7.0 with the 2.2 kernel. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Lamar Owen
this group is more civil than that, IMHO. She likely is off for the weekend, and hasn't read any responses yet. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Hey guys, check this out.

2001-04-14 Thread Lamar Owen
http://www.crn.com/Sections/Fast_Forward/fast_forward.asp?ArticleID=25670 Marc will be pleased to note that the PostgreSQL project came out of the FreeBSD project, and is Great Bridge's database. Gotta love journalistic license. -- Lamar Owen WGCR Internet Radio 1 Peter

Re: [HACKERS] Re: 7.1 RPMs

2001-04-14 Thread Lamar Owen
ackers group has built out of trees. And I have to know some details of the trees occasionally. I'm sure Oliver would agree. And, to let everyone know, I'm having a blast doing this. And I'm glad my work schedule eased up some in the last month so I could put some time to

Re: [HACKERS] Re: 7.1 RPMs

2001-04-14 Thread Lamar Owen
o. Although, I'd recommend pgsql-cygwin, lest someone erroneously think we directly support Win32. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [HACKERS] Re: 7.1 RPMs

2001-04-14 Thread Lamar Owen
a Jikes-built JDBC sound to people? Ormaybe I don't understand the Java Way well enough to decide. Gotta learn it a little -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, plea

[HACKERS] 7.1-1 RPMset uploading...

2001-04-13 Thread Lamar Owen
NARY tree stored offline so that you can go back to your previous version if the need arises. Otherwise, enjoy the RPMset :-) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 README.rpm-dist ----- Version 3.2, for PostgreSQL

Re: [HACKERS] Re: 7.1 RPMs

2001-04-13 Thread Lamar Owen
On Fri, 13 Apr 2001, Peter Eisentraut wrote: > Lamar Owen writes: > > In the postgresql-docs subpackage, along with the SGML source. > Why would you want to ship the source? For those with SGML tools and viewers, who might like to build hardcopy of their own. Frankly, it was an e

[HACKERS] Re: 7.1 RPMs

2001-04-13 Thread Lamar Owen
y standard by consensus -- kaffe ships with RedHat 7.0 -- isthat an acceptable JDK-substitute?) or someone needs to package 7.1 JDBC jars for my packaging pleasure. I'm running low enough on disk space on my devel machines (one of which is a notebook) to make my own JDK a second choice. Oli

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-11 Thread Lamar Owen
Peter Eisentraut wrote: > Lamar Owen writes: > > Yes, I am, actually. But it seems a broken way of dealing with it. > > Although I do have another idea, thanks to Trond. Rather than package > > '7.1RC4-1' I could package '7.1-0.1RC4' -- giving a straig

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-11 Thread Lamar Owen
Oliver Elphick wrote: > Lamar Owen wrote: > >as the Debian packages have the same issue -- and I don't know if .deb > >has an analog to Serial:. > We have epochs, that is, the package version is preceded by an integer > and a colon, which overrides every oth

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-11 Thread Lamar Owen
Peter Eisentraut wrote: > > Lamar Owen writes: > > > One quick note -- since 'R' < 'b', the RC RPM's must be forced to > > install with --oldpackage, as RPM does a simple strcmp of version > > numbers -- 7.1RC3 < 7.1beta1, for instance.

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-08 Thread Lamar Owen
e're not likely to release a 7.1.0 then a 7.0.4 that fixes bugs in the STABLE branch, whereas at one point Linux 2.0.39, a 2.2.x, and 2.4.0 were being released concurrently. The same happens with FreeBSDand others -- but not us. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 -

Re: [HACKERS] RPMS for RC3

2001-04-08 Thread Lamar Owen
> stuff you do under '# man pages' needs some work. The man pages are still in a separate tarball, or not? > You probably want > to run gzip on the files after installation. Done automagically by the buildrootpolicy of the rpm build system, on distributions that do buildrootpol

[HACKERS] RC3-3 RPMS.

2001-04-07 Thread Lamar Owen
don't have a good JDK on any of my devel boxen -- meaning I'm still shipping the 7.0 JDBC in the jdbc subpackage. ftp://ftp.postgresql.org/pub/dev/test-rpms,as usual. See README.rpm-dist in the main package for more details, as it is actually up to date at this time. -- Lamar Owen WGCR I

[HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-07 Thread Lamar Owen
One quick note -- since 'R' < 'b', the RC RPM's must be forced to install with --oldpackage, as RPM does a simple strcmp of version numbers -- 7.1RC3 < 7.1beta1, for instance. Just force it with --oldpackage if you have a 7.1beta RPM already installed. -- Lamar Owe

Re: [HACKERS] Re: RC3 ... and rpms...

2001-04-07 Thread Lamar Owen
ckage to place docs in the main package %doc. HTML docs and man pages are with the main package; SGML source and any hardcopy docs will go into the docs subpackage. The contrib tree is getting its own subpackage. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(en

[HACKERS] RPMS for RC3

2001-04-07 Thread Lamar Owen
Uploaded. Please take a look. ftp://ftp.postgresql.org/pub/dev/test-rpms There _are_ changes. I will detail the changes for the RC4 RPMset. Karl's pl/perl changes will go into the next set. pg_dumplo will have a built binary, to be located in /usr/lib/pgsql/contrib. -- Lamar Owen

Re: [HACKERS] A more useful way to split the distribution

2001-04-07 Thread Lamar Owen
h else -- well, actually, I just want to make sure I get it right before release, as I'd like to not have but a couple of days before an RPM release after the announcement. Sounds like a plan. I'm going to upload a set of RC3 RPM's tonight -- there are changes that I need people to c

Re: [HACKERS] Re: RC3 ...

2001-04-07 Thread Lamar Owen
The Hermit Hacker wrote: > On Sat, 7 Apr 2001, Lamar Owen wrote: > > Just not well-tested for the RPM build environment :-). > Ya, but you could concievably test that now, without us doign an RC4 .. > the files are all there :) So the structure isn't going to change -- ju

Re: [HACKERS] Re: RC3 ... and rpms...

2001-04-07 Thread Lamar Owen
he very least will remain in the main package. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message

Re: [HACKERS] Re: RC3 ...

2001-04-07 Thread Lamar Owen
ports collection using the individual packages instead of > the great big one) so from a packaging perspective, its well tested ... Just not well-tested for the RPM build environment :-). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--

Re: [HACKERS] Re: RC3 ...

2001-04-07 Thread Lamar Owen
to doing this -- just questioning the timing. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Re: RC3 ...

2001-04-07 Thread Lamar Owen
6.1.1 look pretty puny. I'm looking at the package reorganization for the RPM's this morning -- we'll see what I find in a few hours. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Re: RC3 ... and rpms...

2001-04-07 Thread Lamar Owen
-devel|grep itup /usr/include/pgsql/access/itup.h [root@utility i386]# -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROT

Re: [HACKERS] Re: RC3 ...

2001-04-06 Thread Lamar Owen
cs? Ideas? Comments? The 'Internals' document is still in the main package, FWIW. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-n

Re: [HACKERS] RC3 ...

2001-04-06 Thread Lamar Owen
pload a quickie RC3 RPMset... :-) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Re: Indexes vs indices

2001-04-02 Thread Lamar Owen
matter. 'Indexes' is just fine. It's certainly a better plural than 'Vaxen' was in its time; although I am still inclined to use 'boxen' when referring to more than one computer. -- Lamar Owen WGCR Internet Radio Professor of English, Anchor Baptist Bib

Re: [HACKERS] 7.1 RC1 RPM

2001-03-28 Thread Lamar Owen
Hiroshi Inoue wrote: > Lamar Owen wrote: > > H. Hiroshi committed an update to GNUmakefile to 'enable multibyte > > support' for ODBC. But that was only 33 hours ago -- meaning it wasn't > > updated in time for RC1. Lessee. I'm rebuilding RC1

Re: [HACKERS] Re: 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
ve to trace the build in detail. And the html docs tree is going to the wrong place... In any case, a unified or context diff against the 7.1beta4 spec would be useful. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
tp site right now for ODBC is broken. I'll fix it tonight or tomorrow -- and the source RPM won't rebuild on RH 6.2. I'll upload a -2 set tonight or tomorrow to fix that, and a few other issues I found while dinking with it today. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Lamar Owen wrote: > Well, in any case, preliminary 7.1RC1 RPMS are up. There are some odd > issues with the packaging that I am working on. Be sure to read > README.rpm-dist -- attached to this message for your convenience. Forgot to attach the file. :-(. -- Lamar Owen WGCR Interne

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Lamar Owen wrote: > > Mike Cannon-Brookes wrote: > > > > Any change of getting a 7.1 RC1 RPM? I'm using the beta4 RPMs at the moment > > but don't seem to be any more recent ones. > > I'm building a quickie RC1-1 RPM right now. There are some oth

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
release -- and I plan on working a while this Saturday on that -- but my week is so loaded that I'm going to put out a rebuild of 7.1beta6->7.1RC1 as is -- once I get it to build..... Stay tuned... -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)-

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Lamar Owen
Trond Eivind Glomsrød wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > Did you get the message from Trond about Linux 2.4 x86? I can also > > verify all tests passed on a RedHat Public Beta installation with kernel > > 2.4. > I haven't put those in the lis

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Lamar Owen
; Linux 2.2.16 x86 7.1 2001-03-19, Thomas Lockhart Did you get the message from Trond about Linux 2.4 x86? I can also verify all tests passed on a RedHat Public Beta installation with kernel 2.4. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 --

[HACKERS] Re: Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
the regression failure that subsequently took the rest of the afternoon to track. Before final release I have a rewrite of the README to do, as well as a full update of the migration scripts for testing. I'm looking at /usr/lib/pgsql/contrib/* for the contrib stu

[HACKERS] Re: Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
to hub.). Tomorrow morning, if I can get out of the snow-covered driveway and to work, I can upload it much quicker. I'll go ahead and upload the one I'm testing with right now if you'd like. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast

Re: [HACKERS] Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
now much more leery of our regression suite -- this issue isn't even tested, in reality. Do we have _any_ WAL-related tests? The parallel testing is a good thing -- but I wonder what boundary conditions aren't getting tested. -- Lamar Owen WGCR Internet Radio 1 Pe

Re: [HACKERS] Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
rs are you using --- -B and so forth? Default. To be changed before RPM release, but currently it is the default. The only option that postmaster.opts records is -D, and I'm not passing anything else. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast

Re: [HACKERS] Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
On Tue, 20 Mar 2001, Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > DROP TABLE temptest; > > + NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0, >global 1) > > + ERROR: heap_drop_with_catalog: FlushRelationBuffers returned

Re: [HACKERS] Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
On Tue, 20 Mar 2001, Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > DROP TABLE temptest; > > + NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0, >global 1) > > + ERROR: heap_drop_with_catalog: FlushRelationBuffers r

[HACKERS] Beta 6 Regression results on Redat 7.0.

2001-03-20 Thread Lamar Owen
RPM's, or will it be a day or two before RC1? -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 *** ./expected/temp.out Sat Jan 8 22:48:39 2000 --- ./results/temp.out Tue Mar 20 16:06:10 2001 *** *** 23,32 (1 row) DROP TABLE temptest; SELECT * FROM temptest; col --

Re: [HACKERS] Do you plan an RPM release of beta 6

2001-03-19 Thread Lamar Owen
Been far too busy for my own good here at work in the last three weeks to touch RPM stuff. This set will be built on both RH 7 and RH 6.2, if I can swing it. More to follow. Pray for snow in Western North Carolina :-). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(

Re: [HACKERS] Allowing WAL fsync to be done via O_SYNC

2001-03-15 Thread Lamar Owen
. See the thread starting at http://www.postgresql.org/mhonarc/pgsql-hackers/2000-03/msg00107.html for details. (And the search is working :-)). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Red Hat bashing

2001-03-06 Thread Lamar Owen
ter, even if it is masking a certain amount of shortsightedness on a certain initscripts author's part. :-) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister com

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-06 Thread Lamar Owen
ndards, has had a brown paper bag release -- we all still make mistakes (I know -- I've made more than my share of them). Anyway, that's more than what the rest of the list wanted to read. Replies to private e-mail, please. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 -

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-06 Thread Lamar Owen
ry here? At least they are payrolling Second Chair on the Linux kernel hierarchy. And they are very supportive of PostgreSQL (by shipping us with their distribution). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-06 Thread Lamar Owen
en. Should be fixed in the latest public beta of RedHat, that actually has the 2.4 kernel. I can't really say any more about that, however. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2: you can get off a

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-06 Thread Lamar Owen
-- I am going to sleep 1 and loop sixty times) -- no need to unnecessarily delay system shutdown (and potential restart). And I won't put in the -KILL unless I can find a safe and thorough way to do so. Or I may go ahead and pg_ctl-ize things and let pg_ctl do the dirty

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-06 Thread Lamar Owen
Peter Eisentraut wrote: > > Lamar Owen writes: > > > I missed something somehwere: wasn't the consensus a few weeks ago that > > pg_ctl shouldn't be used for a system initscript? > > The consensus(?) was that there was some work to do in pg_ctl before i

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
the grim reaper yank them in the wrong order for you, in any case. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> If you think it's easy enough, enlighten the rest of us ;-). > > If postgres reported PGDATA on the command line it would be easy enough. > In ps status you mean? I don

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
e backends I'll have to experiment. But not tonight -- last week was more taxing than I thought. :-(. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an approp

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
Tom Lane wrote: > Lamar Owen wrote: > > Postmaster can easily enough find out if zombie backends are 'out there' > > during startup, right? > If you think it's easy enough, enlighten the rest of us ;-). If postgres reported PGDATA on the command line it wo

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
that day? :-) I certainly have no problem using pg_ctl for this purpose -- as I have been using pg_ctl to start postmaster all along (then why am I not using it to stop -- don't answer that :-)).. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
al solution is elsewhere, anyway. I just have to make sure it is not data-corruption broken. And, if leaving the -9 out completely is the only solution, then, well, it's the only solution. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
postmaster coming up and try to 'sync up' with that postmaster, like the baroque GEMM handshake dance performed by 386 memory managers when Windows needs to start its own VMM? Or should we spend that much time protecting Barney Fife's from their own single bullet? :-) Just a nor-easter

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
Tom Lane wrote: > The tricky part of this is not to give up the ability to restart when > there *has* been a crash. But kill -9 effectively _is_ an admin-initiated crash. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)-

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
MIPS for such a purpose)? The last thing I want to do is wait too long on some platforms and not long enough on others. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send a

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
where it doesn't, blame Red Hat. :-) So we're going to credit Linux for PostgreSQL being shipped as part of the RedHat distribution since RH 5.0, then? :-0 -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2:

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
my RH _4_.1 CD, but that's just a _little_ old :-). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
RC=$? [ $RC -eq 0 ] && success "$base $killlevel" || failure "$base $killlevel" fi fi Is 6.1 this different from 6.2? This code on the surface seems reasonable to me -- am I missing something? The 6.2 code (found i

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-05 Thread Lamar Owen
something cleaner -- compatible, but cleaner. I'll have to research what the defaults are for later RH's -- but, as 6.1 is one of my target platforms at this time, I have to fix that issue for sure. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 -

Re: [HACKERS] beta5 packages ...

2001-02-23 Thread Lamar Owen
that I get the contrib stuff in beta5's RPMset -- I will attempt to do that, but I'm making no guarantees at this point. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] beta5 ...

2001-02-21 Thread Lamar Owen
re are other more capable packages out there, but Netscape works the same on Win9x and Linux, both of which are in use on my notebook. I have to keep up, or the e-mail flood after a couple of days is just about unbearable. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] beta5 ...

2001-02-21 Thread Lamar Owen
.2.18 for RedHat 6.2 (the kernel patches applied could in fact be different enough to matter)? These are all hypothetical examples, of course -- but Linux is not the only platform that has these versioning problems just waiting to bite. Linux probably has more of them than most, but it is not alone in having them. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: old include files (was Re: [HACKERS] PHP 4.0.4pl1 / Beta 5)

2001-02-19 Thread Lamar Owen
. RPM is pretty good at cleaning the old out. Sometimes a little too good :-/. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Microsecond sleeps with select()

2001-02-17 Thread Lamar Owen
Bruce Momjian wrote: > In fact, the kernel doesn't even contain have a way > to measure microsecond timings. Linux has patches available to do microsecond timings, but they're nonportable, of course. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Non-locale 7.1beta4 binaries on RedHat 6.2 test results.

2001-02-17 Thread Lamar Owen
Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > The locale enabled regression results fail due to > > currency format and collation errors. Diffs attached. I'm not sure I > > understand the select_views failure, either. Locale used was en_US. >

[HACKERS] Non-locale 7.1beta4 binaries on RedHat 6.2 test results.

2001-02-17 Thread Lamar Owen
t in a non-locale RPM distribution, or? The locale enabled regression results fail due to currency format and collation errors. Diffs attached. I'm not sure I understand the select_views failure, either. Locale used was en_US. Comments? -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 locale-run.diffs

Re: [HACKERS] locale support

2001-02-13 Thread Lamar Owen
Peter Eisentraut wrote: > Lamar Owen writes: > > And building without locale support doesn't work, either, because, at > > least on RH 6.1, strncmp() is buggered to use the locale's collation. > I don't think so. On RH 6.1, strncmp() is the same it's eve

Re: [HACKERS] locale support

2001-02-13 Thread Lamar Owen
While I want to make sure that a broken locale data set isn't used, I also want to make sure that a good locale set isn't thrown out, either. Forcing to LC_COLLATE=C is overkill, IMHO. And building without locale support doesn't work, either, because, at least on RH 6.1, strncmp

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-09 Thread Lamar Owen
tion that works is better than mucking around with the core, particularly this close to release. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-08 Thread Lamar Owen
Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > AOLserver is one example that successfully redirects dynamic linker > > messages to it's own log. > Oh? How? Are you sure they're not just piping stderr to a program > of their own devising? T

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-08 Thread Lamar Owen
"Dominic J. Eidson" wrote: > On Thu, 8 Feb 2001, Lamar Owen wrote: > > A syslogger of stderr would make a nice place to pipe the output :-). > > 'postmaster 2>&1 | output-to-syslog-program -f facility.desired' or > 2>&1 | logger -p

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-08 Thread Lamar Owen
lready have generic log analysis tools set up to work with the OS vendor's logrotate, etc, it pays to not reinvent the wheel but use the conventions and tools already provided in the OS. Syslog is a standard way to do this. Why even have syslog support otherwise? (Extremist? Maybe.) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-08 Thread Lamar Owen
he logs. We're not > > replacing the system fprintf , are we? (my assumption is that we are > > NOT). The usage of puts(), OTOH, has been well nigh eradicated. Where is elog() safe? (Going to Bruce 'comb through the archives' mode here...) If someone can educate me i

Re: [HACKERS] pg_ctl changes

2001-02-07 Thread Lamar Owen
changes there. Sounds good to me. It appears that you haven't checked in your changes to CVS as of a few minutes ago, but I like the looks of what you've posted. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Include files for SPI are not installed

2001-02-07 Thread Lamar Owen
d be, but if > people like this idea I will do the legwork to make the list. Count me as liking it. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Include files for SPI are not installed

2001-02-06 Thread Lamar Owen
'm just being a little more specific). The contents of -devel-spi (or maybe just -spi) would be all the other headers (no duplicates) (again, expounding upon what Tom said already). Comments? -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [HACKERS] Include files for SPI are not installed

2001-02-06 Thread Lamar Owen
option for > your gcc? No. Full tree takes at minimum 36MB -- even pulling the _entire_ src/include tree over is only 2MB. > I expect header files on /usr/include/pgsql for client programming not > for SPI. Why? I know of several people doing SPI work with no source tree installed. -

Re: [HACKERS] Include files for SPI are not installed

2001-02-06 Thread Lamar Owen
. (1MB of _headers_? Yow!) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

<    1   2   3   4   5   6   >