Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Larry Rosenman wrote:
I agree. the only issue is how to set up our makefiles to only do the
-Kpthread/-pthreads(gcc) flags on the client code, and not do it for
the backend itself.
I think mixing a pgport that has thread flags
On Wed, 12 May 2004, Tom Lane wrote:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
2. When an object foo is called and needs to refer to another object
bar, it should assume that bar exists in the same schema as foo, and NOT
in the current search_path.
That would be great if a C
--On Thursday, May 13, 2004 10:05:22 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Basically, as things set right now in CVS, Unixware is ready to go
because it thread for everything. We don't have per-template thread
settings anymore because we test all of it in configure.
Was a change made
Larry Rosenman wrote:
-- Start of PGP signed section.
--On Thursday, May 13, 2004 10:05:22 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Basically, as things set right now in CVS, Unixware is ready to go
because it thread for everything. We don't have per-template thread
settings
--On Thursday, May 13, 2004 11:44:59 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Larry Rosenman wrote:
-- Start of PGP signed section.
--On Thursday, May 13, 2004 10:05:22 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Basically, as things set right now in CVS, Unixware is ready to go
Larry Rosenman wrote:
Really? You are configuring with --enable-thread-safety? I just
updated your template in CVS, and it is attached. However, any old CVS
should work fine.
Nope, initdb is where we still die:
OH! I remember now. What we have to do for this platform only is to
pass
I know, this sucks, but, I don't see any other way, other than linking
*ALL* libpq-using programs (including initdb and friends) with -K
pthread.
How about making a libpq.so (without pthread) and a thread safe
libpq_r.so ?
Andreas
---(end of
Ken Ashcraft [EMAIL PROTECTED] writes:
I work at Coverity where we use static analysis to find bugs in
software. I ran a security checker over postgresql-7.4.1 and I think I
found a security hole.
In the code below, fld_size gets copied in from a user specified file.
It is passed as the
Le jeudi 13 Mai 2004 04:42, Tom Lane a crit :
I got tired of reading complaints about how upper/lower don't work with
Unicode, so I went and prototyped a solution. The attached code uses
the C99-standard functions mbstowcs and wcstombs to convert to and from
a wchar_t[] representation that can
--On Thursday, May 13, 2004 09:54:02 +0200 Zeugswetter Andreas SB SD
[EMAIL PROTECTED] wrote:
I know, this sucks, but, I don't see any other way, other than linking
*ALL* libpq-using programs (including initdb and friends) with -K
pthread.
How about making a libpq.so (without pthread) and a
Hi Everyone,
Is there a way to find out how many dead index nodes are in a btree based
index? I'm attempting to track down how much of my index is bloated because
of dead nodes...
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
I ran the new Pgpool-1.2.2 and it was a bit faster on
the TCP but still slower than on UNIX socket. I used
the same script as before.
TCP Socket (Pgpool 1.2.0)
--
2.39 sec
TCP Socket (Pgpool 1.2.2)
--
0.80 sec
0.80 sec
0.79 sec
UNIX Socket (Pgpool 1.2.2)
Ken Ashcraft [EMAIL PROTECTED] writes:
... thus opening up the problem to anyone who can get past the
initial postmaster authentication check. So this is more severe than we
first thought.
Great. Thanks for the feedback. If it is serious, is an advisory in order?
No, we'll just push out
Larry Rosenman [EMAIL PROTECTED] writes:
I did get a note from my SCO contacts that they are looking into how
to make it easier for stuff to be threads ready, but I don't expect
that to be ready for 7.5 release.
The -Kpthread on all libpq using programs is the easiest way FOR NOW.
Hmm. If
Alvaro Herrera [EMAIL PROTECTED] writes:
I'm stuck trying to figure out how to decrease reference counting for
relcache entries at subtransaction abort.
Initially I thought I could just drop them all to zero,
Nope, you can't. An active query plan will surely have open relations.
--On Thursday, May 13, 2004 09:18:21 -0400 Tom Lane [EMAIL PROTECTED]
wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I did get a note from my SCO contacts that they are looking into how
to make it easier for stuff to be threads ready, but I don't expect
that to be ready for 7.5 release.
The
Larry Rosenman wrote:
-- Start of PGP signed section.
--On Thursday, May 13, 2004 09:18:21 -0400 Tom Lane [EMAIL PROTECTED]
wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I did get a note from my SCO contacts that they are looking into how
to make it easier for stuff to be threads
Bruce Momjian [EMAIL PROTECTED] writes:
Larry Rosenman wrote:
I agree. the only issue is how to set up our makefiles to only do the
-Kpthread/-pthreads(gcc) flags on the client code, and not do it for
the backend itself.
I think mixing a pgport that has thread flags with a backend that does
Hi all,
loading a function written in C I get this error:
#create function email_in( cstring ) returns email AS 'emaildt.so', 'email_in'
LANGUAGE C STRICT;
NOTICE: type email is not yet defined
DETAIL: Creating a shell type definition.
ERROR: could not load library emaildt.so: emaildt.so:
I see this code in pg_ctl:
PID=`sed -n 1p $PIDFILE`
if [ $PID -lt 0 ];then
PID=`expr 0 - $PID`
Wnen it is possible (and why) to have a negative number in postmaster.pid?
Thanks,
Mike
---(end of broadcast)---
TIP 7: don't forget
Dave Page wrote:
Any comments/criticisms/gasps of horror at all the win32 code? :-)
Sorry for not jumping in sooner but I have been offline for several days.
Anyway, not having looked at this at all, how will this be effected when
pg_autovacuum is integrated into the backend. I assume that
On 9 Feb, Tom Lane wrote:
[EMAIL PROTECTED] writes:
I'll see what I can do about the explain and explain analyze
results. I remember in the past that someone said it would be most
interesting to execute the latter while the test while running, as
opposed to before or after a test. Should I
Sorry, I should have checked the source first.
Just found this in miscinit.c :
* By convention, the owning process' PID is negated if it is a standalone
* backend rather than a postmaster. This is just for informational
purposes.
-Original Message-
I see this
Deepak Bhole of Red Hat asked me about the following situation:
regression=# create table test (f1 int);
CREATE TABLE
regression=# revoke insert,update,delete,references on test from postgres;
REVOKE
regression=# \z test
Access privileges for database regression
Schema | Name | Type |
Our customer has problems with Pg 7.3.2 on Solaris.
There are numerous errors in the app. server log and in the database log,
including these:
LOG: open of /mnt_c1t2d0s0/some-path/postgresql/pg_xlog/0001
(log file 0, segment 1) failed: No such file or directory
LOG: invalid primary
Tom Lane wrote:
I think the printout format is fine and the silent non-removal of
grant options was a bad idea, particularly since it doesn't seem to
be saving any code (GRANT/REVOKE check ownerness anyway). I propose
that we take out the special cases in merge_acl_with_grant that
prohibit
Jan Wieck wrote:
This is the reason why the setting has to be at least per database and
cannot be changed after DB creation.
I think there's overwhelming consensus that db creation time is the
latest you can specify the canonical name setting for it. There's
probably a good case to be
Michael Brusser [EMAIL PROTECTED] writes:
I wonder if message
open of /mnt_c1t2d0s0/... (log file 0, segment 1) failed: No such file or
directory
may indicate some kind of NFS problem.
Running a database over NFS is widely considered a horrid idea --- the
NFS protocol is simply too prone to
On Thu, 5 Feb 2004, Rod Taylor wrote:
Don't know. But apparently different users will have
different demands From a database.
Of course, but I would argue that my claim that PostgreSQL is reliable
is backed up by the lack of people posting messages like 'we had a
powercut and now
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane wrote:
I think the printout format is fine and the silent non-removal of
grant options was a bad idea, particularly since it doesn't seem to
be saving any code (GRANT/REVOKE check ownerness anyway). I propose
that we take out the special
It looks that No such file or directory followed by the abort signal
resulted from manually removing logs. pg_resetxlog took care of this,
but other problems persisted.
I got a copy of the database and installed it on the local partition.
It does seem badly corrupted, these are some hard errors.
Gaetano Mendola [EMAIL PROTECTED] writes:
which library I have to link in order to have the symbol pg_begintypsend ?
I think you want pq_begintypsend.
Consider paying more attention to unknown-function warnings from your
compiler.
regards, tom lane
Michael Brusser [EMAIL PROTECTED] writes:
It looks that No such file or directory followed by the abort signal
resulted from manually removing logs. pg_resetxlog took care of this,
but other problems persisted.
pg_dump: ERROR: XLogFlush: request 0/A971020 is not satisfied ---
flushed only
Mark,
Ok, I've found that the kit does capture explain results and I've
added a Query Plans links under the query time charts on each of the
pages. Um, but I did notice a couple of problems. It looks liks one of
the 22 queries is missing and they're not labeled. I'll see about
getting
Schema | Name | Type |Access privileges
+-+---+--
public | mytable | table | {miriam=a*r*w*d*R*x*t*/miriam,=r/miriam}
Changing the default ACL would take this down to
public | mytable | table |
I wrote:
If you like that, I have a further suggestion, which is to not include
the owner's grant options in the default ACL, either.
I've been thinking more about this, and realizing that there are more
implications than I first thought. Specifically, we have to consider
how any hacking we do
Greg Stark wrote:
Jan Wieck [EMAIL PROTECTED] writes:
The whole sync() vs. fsync() discussion is in my opinion nonsense at this
point. Without the ability to limit the amount of files to a reasonable number,
by employing tablespaces in the form of larger container files, the risk of
forcing
scott.marlowe [EMAIL PROTECTED] writes:
but I'm not sure you can test that without power off tests...
Well the approach that's been taken manually on the list is to look at the
timing results and conclude they're just physically impossible.
Doing this automatically could be interesting. If
38 matches
Mail list logo