I am having some problems with our proxy server (wget times out on header)
and would like to know whether it would be possible to install http access
to the snapshots and other download files ?
This would probably also benefit others, no ?
Thanks
Andreas
test/bench/{create|runtest}.sh uses switch '-Q' for
postgres, but postgres gives error on it. Otherwise
seems working, only lots of debug output is seen.
--
marko
On Sat, 24 Feb 2001 18:48:15 -0800 "Richard T. Robino"
[EMAIL PROTECTED] wrote:
Use binary type for transferring files via FTP.
it's the same
On Sat, 24 Feb 2001 09:27:43 +0100 Stefan Huber
[EMAIL PROTECTED] wrote:
wild guess: maybe you must escape the pipe-symbol: ...USING DELIMITERS
'\|'
the
Regardless of whether this particular behavior is fixable, this brings
up something that I think we *must* do before 7.1 release: create a
utility that blows away a corrupted logfile to allow the system to
restart with whatever is in the datafiles. Otherwise, there is no
recovery technique
On Mon, 26 Feb 2001, Zeugswetter Andreas SB wrote:
I am having some problems with our proxy server (wget times out on header)
and would like to know whether it would be possible to install http access
to the snapshots and other download files ?
This would probably also benefit others, no ?
Just an FYI -- It works well from behind my proxy..
-Mitch
- Original Message -
From: "Vince Vielhaber" [EMAIL PROTECTED]
To: "Zeugswetter Andreas SB" [EMAIL PROTECTED]
Cc: "'The Hermit Hacker'" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 7:53 AM
Subject: Re:
I am having some problems with our proxy server (wget times out on header)
and would like to know whether it would be possible to install http access
to the snapshots and other download files ?
This would probably also benefit others, no ?
See if this works:
Vince Vielhaber wrote:
On Sun, 25 Feb 2001, Kaare Rasmussen wrote:
Hi
I've tried to search the site, but no usable pages turned up.
My question is about monitoring PostgreSQL and if it turns out to be "down"
to notify a person to take action.
I'm surprised that I couldn't
Hmmm... that's good to know. Basically, I'm trying to model fixed order
tables in another application through a proxy mechanism (see
http://rpgsql.sourceforge.net/). I guess I will have to force row
ordering on all proxied tables.
Tim
Tom Lane wrote:
"Timothy H. Keitt" [EMAIL PROTECTED]
Zeugswetter Andreas SB [EMAIL PROTECTED] writes:
Imho this write at logfile init time adds a substantial amount of IO,
that would better be avoided. If we really need this, it would imho
be better to preallocate N logfiles and reuse them after checkpoint.
Already done. See the WAL_FILES
Imho this write at logfile init time adds a substantial amount of IO,
that would better be avoided. If we really need this, it would imho
be better to preallocate N logfiles and reuse them after checkpoint.
Already done. See the WAL_FILES parameter.
I meant something else. I did not
Morning all ...
Are there any major outstandings that ppl have on their plates,
that should prevent a release? I'd like to put out an RC1 by Friday this
week, with a full release schedualed for March 15th ... this would give
Thomas his two weeks for the docs freeze ...
Are there any major outstandings that ppl have on their plates,
that should prevent a release?
Imho startup after a failing WAL recovery is a 'must do' before release,
as Tom pointed out. Remember that you can currently run into this situation
with as easy a mistake as running out of
[EMAIL PROTECTED] (Nathan Myers) writes:
This is supported on Linux and BSD, but not on Solarix 7. It's not
necessary; you can just map /dev/zero on SysV systems that don't
have MAP_ANON.
HPUX says:
The mmap() function is supported for regular files. Support for any
other type
Tom Lane [EMAIL PROTECTED] writes:
Since mmap() is how everybody implements shared libraries,
Now *there's* a sweeping generalization. Documentation of this
claim, please?
I've seen a lot of shared library implementations (I used to be the
GNU binutils maintainer), and Nathan is
[ Charset ISO-8859-1 unsupported, converting... ]
Regardless of whether this particular behavior is fixable, this brings
up something that I think we *must* do before 7.1 release: create a
utility that blows away a corrupted logfile to allow the system to
restart with whatever is in the
One thing that I remember from a performance test we once did is, that the results
are a lot more realistic, better and more stable, if you try to decouple the startup
of
the different clients a little bit, so they are not all in the same section of code at
the same time.
We inserted random
Can anyone tell me what is going on, when I get a stuck spinlock?
Is there a data corruption or anything else to worry about ?
I've found some references about spinlocks in the -hackers list,
so is that fixed with a later version than beta4 already?
Actually I was running a stack of pgbench jobs
I just put the regress test tool online. It's just a simple form, I'll
add the borders and stuff later. No reporting tool yet, but I'm working
on that now.
http://www.postgresql.org/~vev/regress/
Be prepared, it's gonna ask you for your regression.out and
regression.diff files. I just
hi i'm re-sending this mail again to seek more help since i haven't got
any solution as yet. Additionaly , could it be an oracle taking up so much
resource so that i postgres can't get any of them?
Katsu
-- Forwarded message --
Date: Sun, 18 Feb 2001 15:27:47 +1100 (EST)
is regression.out and/or regression.diff deleted if the tests pass? I've
never seen all tests pass so I don't know but I just had someone tell me
that it does.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL
There is also a component of netsaint (www.netsaint.org) that will
check PostgreSQL postmasters. I hope to add to that the ability to
Thanks.
I've also seen a lot of announcements of OpenNMS at freshmeat. All I know is
that it's Java based, and as fas as I can tell will work without agents.
Peter Schindler [EMAIL PROTECTED] writes:
FATAL: s_lock(fcc01067) at xlog.c:2088, stuck spinlock. Aborting.
Judging from the line number, this is in CreateCheckPoint. I'm
betting that your platform (Solaris 2.7, you said?) has the same odd
behavior that I discovered a couple days ago on HPUX:
On Tue, 27 Feb 2001, jamexu wrote:
Hello Tom,
Tuesday, February 27, 2001, 12:23:25 AM, you wrote:
TL This looks a lot like exchanging the devil we know (SysV shmem) for a
TL devil we don't know. Do I need to remind you about, for example, the
TL mmap bugs in early Linux releases? (I
the only problem is because if we need to tune Postermaster to use
large buffer while system havn't so many SYSV shared memory, in many
systemes, we need to recompile OS kernel, this is a small problem to install
PGSQL to product environment.
Of course, if you haven't got mmap(), a recompile
On Tue, 27 Feb 2001, jamexu wrote:
Hello The,
Tuesday, February 27, 2001, 11:00:05 AM, you wrote:
THH On Tue, 27 Feb 2001, jamexu wrote:
Hello Tom,
Tuesday, February 27, 2001, 12:23:25 AM, you wrote:
TL This looks a lot like exchanging the devil we know (SysV shmem) for a
TL
On Mon, 26 Feb 2001, Bruce Momjian wrote:
the only problem is because if we need to tune Postermaster to use
large buffer while system havn't so many SYSV shared memory, in many
systemes, we need to recompile OS kernel, this is a small problem to install
PGSQL to product environment.
Tatsuo Ishii [EMAIL PROTECTED] writes:
*** parse_coerce.c.orig Sat Feb 3 20:07:53 2001
--- parse_coerce.cTue Feb 27 11:33:01 2001
***
*** 190,195
--- 190,201
Oid inputTypeId = input_typeids[i];
Oid
the only problem is because if we need to tune Postermaster to use
large buffer while system havn't so many SYSV shared memory, in many
systemes, we need to recompile OS kernel, this is a small problem to install
PGSQL to product environment.
What? You don't automatically recompile
This looks very safe and I believe should be applied.
vacuum analyze on pg_type fails if bogus entries remain in pg_operator.
Here is a sample script to reproduce the problem.
drop table t1;
create table t1(i int);
drop function foo(t1,t1);
create function foo(t1,t1) returns bool as
Okay ... same applies to MMAP() though, I had to disappoint ... there are
kernel limits that, at least under FreeBSD, do require a kernel
recompile in order to exceed ... alot of them have been moved (maybe all
now) to sysctl settable values ... but, again, under some of the
commercial OSs,
I'd suggest not arbitrarily erroring out when there is no need for
a conversion, and not doing the cache lookup implied by typeidIsValid
when it's not necessary to touch the type at all. Hence, I'd recommend
moving this down a few lines. Also, conform to the surrounding coding
style and
On Mon, 26 Feb 2001, Bruce Momjian wrote:
Okay ... same applies to MMAP() though, I had to disappoint ... there are
kernel limits that, at least under FreeBSD, do require a kernel
recompile in order to exceed ... alot of them have been moved (maybe all
now) to sysctl settable values ...
But the mmap() limits are much larger than the SysV limits, aren't they,
to the point where you would never have to fiddle with the mmap() limits
to get 100mb of buffers, right?
Not necessarily ... it depends on the admin of the server ... then again,
I don't consider it a hassle to add
Tatsuo Ishii [EMAIL PROTECTED] writes:
I thought "typeidIsValid(targetTypeId) == false" is better than
"!typeidIsValid(targetTypeId)"?
I've always thought that "== true" and "== false" on something that's
already a boolean are not good style. It's a matter of taste I suppose.
But note that
Tatsuo Ishii [EMAIL PROTECTED] writes:
I thought "typeidIsValid(targetTypeId) == false" is better than
"!typeidIsValid(targetTypeId)"?
I've always thought that "== true" and "== false" on something that's
already a boolean are not good style. It's a matter of taste I suppose.
But note
Bruce Momjian [EMAIL PROTECTED] writes:
I know it is easy for you, but the number of reports and problems we
hear about shows it is an issue for some.
We hear some reports, but not a lot. We have no idea whatever what
problems might ensue if we used mmap instead. I'm dubious that SysV
shmem
Hello Tom,
Tuesday, February 27, 2001, 12:45:18 PM, you wrote:
TL Bruce Momjian [EMAIL PROTECTED] writes:
I know it is easy for you, but the number of reports and problems we
hear about shows it is an issue for some.
TL We hear some reports, but not a lot. We have no idea whatever what
TL
I have comitted the fix to parser/parse_coarse.c. My previous patches
was not correct and I changed the checking right after
typeInheritsFrom.
--
Tatsuo Ishii
vacuum analyze on pg_type fails if bogus entries remain in pg_operator.
Here is a sample script to reproduce the problem.
drop
39 matches
Mail list logo