mucking around with
the core, particularly this close to release.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
ut, 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() is buggered to use the
locale's collation.
The real solution is for the vendors to fix their broken locales.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
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 ever been:
[snip]
Is that the code after any
-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
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.
The select_views delta looks like a sort
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
at cleaning the old out.
Sometimes a little too good :-/.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
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
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
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
---(end of broadcast
s code on the surface seems
reasonable to me -- am I missing something? The 6.2 code (found in
/etc/rc.d/init.d/functions, for those who might not know where to find
killproc) sets a default killlevel but never uses it -- ignorant but not
stupid.
--
Lamar Owen
WGCR Internet Radi
, 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]
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: you can get off all lists at once with the unregister
s
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 an appropriate
subscribe-nomail command to [EMAIL PRO
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)---
TIP 2
, 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 of a brainstorm
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
s 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)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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
---(end of broadcast
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 would be easy enough.
What can postmaster
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 appropriate
subscribe-nomail command to [EMAIL PRO
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't think we are prepared to require ps
status
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])
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 it
was robust enough to be used (for anything
(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
work, as that IS what pg_ctl is supposed to accomplish.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
ublic 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 all lists at once with the unregister command
(send &
? 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: if posting/reading
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
---(end of broadcast
ain 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 command
(send "unregister YourE
/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
the
library. The executable is therefore covered by this License.
Section 6 states terms for distribution of such executables.
stifles ROTFL
Everyone does realize that on Linux PostgreSQL binaries link against glibc,
which is LGPL..
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
On Wednesday 02 April 2003 22:39, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
stifles ROTFL
Everyone does realize that on Linux PostgreSQL binaries link against
glibc, which is LGPL..
And your point is?
That everyone is being entirely too picky. Hey, we link against other
On Wednesday 02 April 2003 21:59, Stephan Szabo wrote:
On Wed, 2 Apr 2003, Lamar Owen wrote:
However, linking a work that uses the Library with the Library
creates an executable that is a derivative of the Library (because it
contains portions of the Library), rather than a work
On Thursday 03 April 2003 00:04, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
And its stubs are in the backend, of all places.
Really? I must have missed that.
On Linux as compiled in Red Hat 9, at least:
[EMAIL PROTECTED] lowen]$ ldd /usr/bin/postgres
libpam.so.0 = /lib
On Thursday 03 April 2003 09:29, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
And its stubs are in the backend, of all places.
Really? I must have missed that.
On Linux as compiled in Red Hat 9, at least:
[EMAIL PROTECTED] lowen]$ ldd /usr/bin/postgres
libreadline.so
out the cdbs files (which contain the broadcast stuff as well as
more) at /pub/Bureaus/Mass_Media/Databases/cdbs/ (which I would be more
interested in doing, since I am a broadcast engineer by profession)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end
together open source tools to do much of the same stuff.
With the release of the FCC's Fortran source, I've been able to do virtually
everything I need to do.
But while the LMR dataset is larger, the MB dataset is just as varied. I'm
interested in both, however.
--
Lamar Owen
WGCR Internet
, with automatic nightly
import, at some point in time. Just probably not as quickly as Josh needs a
dataset to crank on.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get off all lists at once
or runtime environments. With the
other portions of PostgreSQL, nothing beyond the stock distribution is
required for build.)
I think it would best serve the users for an active JDBC developer to make
that distribution. Please advise how you would like to handle this.
--
Lamar Owen
WGCR
to
someone.
++
7.3.x branch:
* Tue May 27 2003 Lamar Owen [EMAIL PROTECTED] 7.3.3-1PGDG
- Synced up with RawHide.
- 7.3.3
- Eliminate spurious symlink of libpq.so.2.
- Dropped isblank patch; 7.3.3 uses pg_isblank
* Wed Apr 16 2003 Andrew Overholt [EMAIL
Hat
Software. They are being made available by the PostgreSQL Global Development
Group.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs
://www.steffann.nl/PostgreSQL/v7.3.3/ if somebody needs them quickly.
Uploading now. Thanks, Sander, and Thanks, Timothy!
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Friday 13 June 2003 12:46, Nigel J. Andrews wrote:
On Fri, 13 Jun 2003, Lamar Owen wrote:
Incidentally, Red Hat as of about 7.0 began insisting on swap space at
least as large as twice RAM size. In my case on my 512MB RAM notebook,
that meant it wanted 1GB swap. If you upgrade your RAM
On Friday 13 June 2003 15:29, Lamar Owen wrote:
It is or was a Linux kernel problem. The 2.2 kernel required double swap
space, even though it wasn't well documented. Early 2.4 kernels also
required double swap space, and it was better documented. Current Red Hat
2.4 kernels, I'm not sure
overcommit-accounting mode 2 to
prevent kills on OOM. Theoretically mode 2 will prevent the possiblity of
OOM completely.
If I read things right, if you have double swap space mode 0 will not OOM
nearly as quickly.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end
.
If you find testing fun, more power to you. :-)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(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
parameter). I have a little experience in this regard,
having maintained the mainline PostgreSQL RPM's for four years.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
On Sunday 13 July 2003 18:09, Matthew T. O'Connor wrote:
I know it's early, but I was just wondering if there would be 7.4 rpms
during beta?
I plan to have them. I'm on vacation this week, so it will be next at
earliest, depending upon when the beta itself is ready.
--
Lamar Owen
WGCR
confident that PostgreSQL will rise to the occassion. Some of the
plates in question are over 100 years old.
New challenges, new opportunities. But still the same PostgreSQL.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---(end
under those conditions is $100 per hour. (and I have been paid
that rate before.) But the official set will only get uploaded once I've had
the time to build it and test it.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---(end
about it. I should have checked: that IS my responsibility.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---(end of broadcast)---
TIP 8: explain analyze is your friend
... Tough call, but I think I'll leave them be, since they will install on
a fully-updated installation. Although I can't imagine an RHAS install not
updated, but that's a different topic.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
? If there is, you would want to build it that way; principle of least
surprise.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Tuesday 05 August 2003 08:14, Andrew Dunstan wrote:
Will check later today.
When you do, let me know, so that I can post them.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---(end of broadcast)---
TIP
On Friday 22 August 2003 18:42, Josh Berkus wrote:
Bad link. This gives me a post by Lamar Owen talking about usng OIDs to
name files.
I think he may be referring to the last paragraph. Vadim had said that the
tablenames would go to OIDs. They have always been individual files. Been
.
If I could even get the box up to RHL 6.2 I'd be better off, because
PostgreSQL 7.3.x builds and runs well there.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end
On Friday 26 September 2003 10:52, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
This isn't necessarily true. That old of a version of PostgreSQL is
probably running on a quite out-of-date OS -- for instance, if the OS was
Red Hat Linux, then the point at which 6.2.1 was shipped
services that 6.2 has out of the box.
7.3.4 is buildable on 6.2, which makes it a nice balance point for those who
want to do this sort of thing.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
).
So, anyway, looking forward to seeing some progress in this department... :-)
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast
image. Maybe a photograph of an elephant.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast)---
TIP 9: In versions below 8.0
compliance;
maybe iSCSI, but NFS?!?!).
The behavior, in my opinion, should be configurable and ON by default.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast
401 - 460 of 460 matches
Mail list logo