Perhaps I am missing something, but the documentation on external
storage appears remarkably sparse. It says it is better for substring
searches, but otherwise doesn't say very much.
I have a table with two modest-length bytea fields (around 9K and 2K
respectively) of already compressed data.
Thanks. We don't really expect DBAs to go hunting through the source code,
though, do we?
cheers
andrew
- Original Message -
From: Joe Conway [EMAIL PROTECTED]
To: Andrew Dunstan [EMAIL PROTECTED]
Cc: Postgresql Hackers [EMAIL PROTECTED]
Sent: Monday, November 03, 2003 9:50 PM
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What still needs to be addressed is the IO storm cause by checkpoints. I
see it much relaxed when stretching out the BufferSync() over most of
the time until the next one should occur. But the kernel sync at it's
end still pushes the
Tom Lane wrote:
snip excellent scheme for improving List /snip
Just a thought - if we are messing with the List definition should we at
the same time address the strict aliasing issues arising from Node's
multiple personalities (I think it is the main offender).
Or is the intention never to
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Just a thought - if we are messing with the List definition should we at
the same time address the strict aliasing issues arising from Node's
multiple personalities (I think it is the main offender).
Or is the intention never
Marc G. Fournier wrote:
On Tue, 4 Nov 2003, Joshua D. Drake wrote:
Hello,
If that is the case that is fine. I just wanted to throw it out there
but doesn't that mean that
psql would be separate as well?
no new client applications
BTW, Joshua, thanks for releasing this - all my
scott.marlowe wrote:
On Tue, 4 Nov 2003, Tom Lane wrote:
The main problem with this is knowing which files need to be fsync'd.
Wasn't this a problem that the win32 port had to solve by keeping a list
of all files that need fsyncing since Windows doesn't do sync() in the
classical sense?
Andreas Pflug wrote:
Marc G. Fournier wrote:
JSP, remotely, through Jakarta-Tomcat? One of the limitations of
pgAdmin,
as far as I'm concerned, is the fact that you can run it remotely ... if
you could run pgManage under something like Jakarta-Tomcat as a JSP,
that
would be *really* cool
Dave Page wrote:
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Don't get me wrong - pgadmin is cool - I especially recommend
it to my Windows oriented clients and colleagues who hate
using command lines.
Why not your Linux or FreeBSD oriented colleagues
Jan Wieck wrote:
How portable is getrusage()? Could the postmaster issue that
frequently for RUSAGE_CHILDREN and leave the result somewhere in the
shared memory for whoever is concerned?
SVr4, BSD4.3, SUS2 and POSIX1003.1, I believe.
I also believe there is a M$ dll available that gives that
Bruce Momjian wrote:
Tom Lane wrote:
Josh Berkus [EMAIL PROTECTED] writes:
B) What contributors are listed under Major Developers who haven't
contributed any code since 7.1.0?
I think we had agreed that formerly-listed contributors would not be
deleted, but would be moved to a
Tom Lane wrote:
The reason the spec defines these views this way is that it expects
constraint names to be unique across a whole schema. We don't enforce
that, and I don't think we want to start doing so (that was already
proposed and shot down at least once). You are of course free to use
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
I don't think we really need a method to guarantee unique names. It would
already help a lot if we just added the table name, or something that was
until a short time before the action believed to be the table name, or
even only the
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
When I start up with -i, I get the following log:
LOG: could not bind IPv4 socket: Address already in use
There is no other postmaster running anywhere. I suspect that this has to
do with IPv6. This is a SuSE 8.something
Tom Lane wrote:
Kurt Roeckx [EMAIL PROTECTED] writes:
Should we just not give that error message, in case we already
binded to AF_INET6 ::?
Seems like a cure worse than the disease to me --- it could mask
real problems. I suppose we could think about dropping it from LOG
to DEBUG1 level,
Philip Warner wrote:
At 03:37 AM 7/11/2003, Peter Eisentraut wrote:
It would
already help a lot if we just added the table name, or something that
was
until a short time before the action believed to be the table name, or
even only the table OID, before (or after) the $1.
Can we
Bruce Momjian wrote:
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Thu, Nov 06, 2003 at 11:42:13AM -0500, Tom Lane wrote:
I don't have a problem with switching from $1 to tablename_$1, or
some such, for auto-generated constraint names. But if it's not
guaranteed
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
. add tableoid or tablename to information_schema.{check_constraints,
referential_constraints} (I think those are the only places where it
would be needed, from my quick skimming).
. add tableoid or tablename to autogenerated table
Alvaro Herrera wrote:
I don't have an opinion on the Win32 issue.
I do :-)
I think the most important thing for Win32 is for you to set the
direction somewhat (i.e. in more detail than is on your win32 page) and
then jump on Joshua's offer of a dedicated developer (possibly two) to
work on
Marc G. Fournier wrote:
On Fri, 7 Nov 2003, Robert Treat wrote:
I know most people have talked about using bugzilla, but is anyone
familiar with GNATS? I'm currently rereading Open Sources and there's a
paragraph or two mentioning it's use and the fact that it can be
interfaced with
Christopher Browne wrote:
[EMAIL PROTECTED] (Bruce Momjian) writes:
The worst was my upstairs hallway that had no light fixtures, so late at
night if no other lights were on in the house, you had to walk down the
hallway with your hands out in front of you so you didn't bump into
anything. We
Greg Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I am not really aiming at removing sync() alltogether. We know already
that open,fsync,close does not guarantee you flush dirty OS-buffers for
which another process might so far only have done open,write. And you
So for what
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Bugzilla is far from perfect. But it's getting better.
FWIW, I would like to try a bugzilla-based tracking system for Postgres.
Our last attempt at a tracking system failed miserably, but I think that
was (a) because the software we
Robert Treat wrote:
On Fri, 2003-11-07 at 15:28, Andrew Dunstan wrote:
Marc G. Fournier wrote:
On Fri, 7 Nov 2003, Robert Treat wrote:
I know most people have talked about using bugzilla, but is anyone
familiar with GNATS? I'm currently rereading Open Sources and there's
Dave Cramer wrote:
Jira is a fantastic bug tracking project management system and is
available free of charge for open source projects.
http://www.atlassian.com/software/jira/
Wow, that looks very cool indeed! And they are Aussies to boot! :-)
cheers
andreew
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
I don't think we need decicated bug transferrers. Typically, when someone
reports a problem by email, the first step is that some developer or other
expert responds (unless the reporter gets blown away by fellow users as
clueless
Christopher Kings-Lynne wrote:
The doesn't quite make the best use of PG quote is one of the best
examples of buck-passing I've seen in awhile. If Bugzilla had been
designed with some thought to DB independence to start with, we'd not
be having this discussion.
You have to laugh at an app
Marc G. Fournier wrote:
'k, this doesn't look right, but it could be that I'm overlooking
something ...
The function I created:
CREATE FUNCTION month_trunc (timestamp without time zone) RETURNS timestamp without
time zone
AS 'SELECT date_trunc(''month'', $1 )'
LANGUAGE sql IMMUTABLE;
The
Peter Eisentraut wrote:
Andrew Dunstan writes:
Seriously, I have wondered if it might be a good idea to assemble a
small hit team that would take some high profile open source projects
and make sure they worked with Postgres. Bugzilla would be the most
obvious candidate
Peter Eisentraut wrote:
Andrew Dunstan writes:
Your suggestion elsewhere of pick your second favourite app is likely
to result in a more scattergun approach. Also, if it had the imprimatur
of the PostgreSQL community to some extent appraoches to projects might
be more welcome - Dear open
Tom Lane wrote:
Robert Treat [EMAIL PROTECTED] writes:
Also (and maybe someone from Red Hat can weigh in here) are there any
plans from Red Hat to release RHEL rpms for postgresql in the future,
I can tell you that Red Hat is getting beat up regularly for having
omitted Postgres (and
I wrote:
I just spent 15 minutes searching on the RH web site trying to locate
a complete list of packages in the various RHEL personalities, with
conspicuous lack of success. How anyone can make decisions about it
without knowing exactly what is in it is beyond me.
However, you can see a
and the problem seen here with the order of messages sent by initdb has
been fixed by Tom in the head branch (which is the only place it would
have occurred).
cheers
andrew
Robert Treat wrote:
They are no longer in sync. Jan has started committing some of his ARC
work (though I think it
The shell script said this:
$ECHO_N fixing permissions on existing directory $PGDATA...
$ECHO_C
chmod go-rwx $PGDATA || exit_nicely
There's no more rationale than that for this patch.
I'm inclined to agree with you, though.
cheers
andrew
Greg Stark wrote:
+ if
Tom Lane wrote:
Greg Stark [EMAIL PROTECTED] writes:
I'm not suggesting making that the default setup, just loosening the
paranoia check so that if an admin sets the directory to be group
readable the database doesn't refuse to start up.
In previous discussions of this point, paranoia was
Marc G. Fournier wrote:
On Fri, 14 Nov 2003, Bruce Momjian wrote:
Tom Lane wrote:
I said:
This worked in 7.3:
regression=# select '1999-jan-08'::date;
ERROR: date/time field value out of range: 1999-jan-08
HINT: Perhaps you need a different datestyle setting.
Setting
darnit!
patch attached.
(Thinks - do we need to worry about suid sgid and sticky bits on data dir?)
andrew
Tom Lane wrote:
Joe Conway [EMAIL PROTECTED] writes:
I just noticed tonight that the new initdb introduced a subtle change of
behavior. I use a shell script to automate the process
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
darnit!
patch attached.
Applied with correction (you got the return-value check backwards)
and further work to deal reasonably with error conditions occurring
in check_data_dir.
darnit again.
I'm taking a break - my head
Er, that's a per-server limit, not a per-database limit (which is what
he asked for), isn't it?
cheers
andrew
Dann Corbit wrote:
It's a command line option for the server.
http://developer.postgresql.org/docs/postgres/app-postmaster.html
-Original Message-
From: [EMAIL PROTECTED]
Claudio Natoli wrote:
I'm sorry if I'm being alow here - is there any problem with running a
production server on cygwin's postgresql? Is the cygwin port of lesser
quality, or otherwise inferior?
Performance, performance, perfomance... and perfomance... it is (almost)
always worse
Bruce Momjian wrote:
I am ready to work with anyone to make fork/exec happen. It requires we
find out what globals are being set by the postmaster, and have the
child run those same routines. I can show you examples of what I have
done and walk you through areas that need work. If you look at
ow wrote:
Have *never* seen ppl running Oracle or Sybase on Windows. Not sure about DB/2
or Informix, never worked with them, but I'd suspect the picture is the same.
Then you need to get out more. I have seen Oracle, Sybase, DB2 (and
probably Informix, I forget) all running on Windows in a
Josh Berkus wrote:
Guys,
I agree with Neil ... it's not the length of the development part of the
cycle, it's the length of the beta testing.
I do think an online bug tracker (bugzilla or whatever) would help. I also
think that having a person in charge of testing would help as well ... no
Marc G. Fournier wrote:
On Tue, 18 Nov 2003, Andrew Dunstan wrote:
Maybe some sort of automated distributed build farm would be a good
idea. Check out http://build.samba.org/about.html to see how samba does
it (much lighter than the Mozilla tinderbox approach).
We wouldn't need
Peter Eisentraut wrote:
Andrew Dunstan writes:
If there's general interest I'll try to cook something up. (This kind of
stuff is right up my alley). I'd prefer some automated display of
results, though. A simple CGI script should be all that's required for
that.
The real problem
strk wrote:
Running initdb:
creating template1 database in /pgroot-cvs/data/base/1 ... child process was terminated by signal 11
It is working fine for me (RH9). Can you provide more details? Platform?
How you are calling initdb?
cheers
andrew
---(end of
Peter Eisentraut wrote:
Andrew Dunstan writes:
Useful is probably subjective. That list would at least be a good
place to start, though. What combinations of variables do you think we
would need?
First of all, I don't necessarily think that a large list of CPU/operation
system
Peter Eisentraut wrote:
The Samba build daemon suite is pretty good. We have a couple of those
hosts in our office in fact. (I think they're building PostgreSQL
regularly as well.) A tip: You might find that adopting the source code
of the Samba suite to PostgreSQL is harder than writing a new
This whole thing is starting to make my head hurt. There has been more
effort spent over this license issue than I would have spent if I hadn't
taken the shortcut of using the FreeBSD code.
I think maybe the simplest thing is for me to prepare a patch that rips
that code out and replaces it
Peter Eisentraut wrote:
Andrew Dunstan writes:
Essentially what I have is something like this pseudocode:
cvs update
Be sure check past branches as well.
check if there really was an update and if not exit
OK.
configure; get config.log
Ideally, you'd try all
Rod Taylor wrote:
I think maybe the simplest thing is for me to prepare a patch that rips
that code out and replaces it with a (slightly simpler - less umask
hacking required, I think) piece of code that I will write.
The FreeBSD folks sorted it out for us.
Everyones names should be in
Marc G. Fournier wrote:
On Thu, 20 Nov 2003, Joshua D. Drake wrote:
Based on the below wouldn't they also have to go after Microsoft?
Depends ... does MicroSoft use BSD TCP/IP, or did they write their own? I
know that Linux is not using BSD TCP/IP (or, at least, they didn't in
their
Tom Lane wrote:
I think the main value of a build farm is that we'd get nearly immediate
feedback about the majority of simple porting problems. Your previous
arguments that it wouldn't smoke everything out are certainly valid ---
but we wouldn't abandon the regression tests just because they
Peter Eisentraut wrote:
Here is what I get:
peter ~$ pg-install/bin/initdb pg-install/var/data
...
creating directory pg-install/var/data ... initdb: failed
No points for details in the error message here either.
If I create pg-install/var first, then it work.
I will check it out. I know I
Tom Lane wrote:
AFAICS mkdatadir() shouldn't consider subdir == NULL as a reason to
fail rather than trying mkdir_p. Indeed, if anything the opposite:
when subdir isn't NULL the immediately prior directory level should
exist already.
Right. In fact, I can't see any good reason to call mkdir
Andrew Dunstan wrote:
Peter Eisentraut wrote:
Here is what I get:
peter ~$ pg-install/bin/initdb pg-install/var/data
...
creating directory pg-install/var/data ... initdb: failed
No points for details in the error message here either.
If I create pg-install/var first, then it work.
I
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
AFAICS mkdatadir() shouldn't consider subdir == NULL as a reason to
fail rather than trying mkdir_p.
Right. In fact, I can't see any good reason to call mkdir and then
mkdir_p at all. See my patch from
Jean-Michel POURE wrote:
Le Vendredi 21 Novembre 2003 19:47, Tom Lane a crit :
I think the main value of a build farm is that we'd get nearly immediate
feedback about the majority of simple porting problems. Your previous
arguments that it wouldn't smoke everything out are certainly valid
Bruce Momjian wrote:
FYI, the HP testdrive farm, http://www.testdrive.hp.com, has shared
directories for most of the machines, meaning you can CVS update once
and telnet in to compile for each platform.
As Peter pointed out, these machines are firewalled. But presumably one could upload a
Bruce Momjian wrote:
Andrew Dunstan wrote:
Bruce Momjian wrote:
FYI, the HP testdrive farm, http://www.testdrive.hp.com, has shared
directories for most of the machines, meaning you can CVS update once
and telnet in to compile for each platform.
As Peter pointed out
Greg Stark wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
Then it needs to be stated very prominently. But the place to put a
sign saying Dangerous cliff edge is beside the path that leads along
it.
The only way to make this prominent would be a file with the *name* THIS
DIRECTORY
What's happening to the remaining patches that were held over for 7.5,
e.g. mine which does some logging enhancements?
cheers
andrew
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tony and Bryn Reina wrote:
1. Which parts of MSYS and Mingw are needed for the building a Win32
version of PostgreSQL?
There are several packages listed on the Mingw website:
MingGW-3.1.0-1.exe
mingw-utils-0.2
mingw-runtime-3.2
msys-1.0.9.exe
msysDTK-1.0.1.exe
binutils
gcc
win32api-2.4
E.Rodichev wrote:
On Fri, 28 Nov 2003, Tom Lane wrote:
E.Rodichev [EMAIL PROTECTED] writes:
/e:2createdb test
test | er | SQL_ASCII - Incorrect!
(3 rows)
Let's note than the last line is in fact completely incorrect.
What's incorrect about it? You
Tom Lane wrote:
[EMAIL PROTECTED] (David Fetter) writes:
While PL/Perl is great, it's not available everywhere, and I'd like to
be able to grab atoms from a regex match in, say, a SELECT. Is there
some way to get access to them?
There's a three-parameter variant of substring() that
E.Rodichev wrote:
On Wed, 3 Dec 2003, Stephan Szabo wrote:
On Wed, 3 Dec 2003, E.Rodichev wrote:
On Fri, 28 Nov 2003, Tom Lane wrote:
E.Rodichev [EMAIL PROTECTED] writes:
/e:2createdb test
test | er | SQL_ASCII - Incorrect!
(3 rows)
E.Rodichev wrote:
On Wed, 3 Dec 2003, Stephan Szabo wrote:
The locale settings depend on LC_* at initdb time only. When the
postmaster starts it sets the locale based on the stored values from
initdb, not on the current environment.
With an SQL_ASCII database being accessed from a client with
Marc G. Fournier wrote:
run it through syslog?
or set log_timestamp = true in postgresql.conf ?
On Thu, 4 Dec 2003, Steve Wampler wrote:
Would it be (is it?) possible to add timestamp to the log
messages put out by postgresql? I've got several databases
running in an environment where
Bruce Momjian wrote:
Gaetano Mendola wrote:
I don't think the article is available online, alas, but you can find some
related source code demonstrating the technique at:
http://www.semantics.org/tyr/tyr0_5/list.h
That certainly is an amazing idea. You know the pointer you are
Kurt Roeckx wrote:
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
Hi,
The ident server we currently use is pidentd 3.0.16
from :
http://www.lysator.liu.se/ or
ftp://ftp.lysator.liu.se/pub/ident/servers
The ChangeLog of it says: Solaris 8 (including IPv6) support
added.
fresh checkout just compiled fine for me on Linux (RH8) with ssl
enabled. Maybe it is your openssl installation?
cheers
andrew
Bruce Momjian wrote:
Attached is a compile failure I am seeing in CVS HEAD in bin/pg_dump.
The offending lines are:
gmake[3]: Leaving directory
Bruce Momjian wrote:
Andrew Dunstan wrote:
fresh checkout just compiled fine for me on Linux (RH8) with ssl
enabled. Maybe it is your openssl installation?
It is openssl 0.9.7c. 7.4 CVS compiles fine so I don't see how it can
be my SSL install.
I just tried with this version
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Where is the typedef here:
int CRYPTO_set_locked_mem_functions(void *(*m)(size_t), void (*free_func)(void *));
size_t ...
If there's a missing typedef shouldn't we see something like this:
`size_t' undeclared (first use in this
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Andrew Dunstan wrote:
fresh checkout just compiled fine for me on Linux (RH8) with ssl
enabled. Maybe it is your openssl installation?
It is openssl 0.9.7c. 7.4 CVS compiles fine so I don't see how it can
be my SSL
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
I've been able to reproduce this on one of my machines, and it's nasty.
In that case I'm confused about why this code compiles on my machine:
What compiler are you using? I'm using gcc 2.95.3
Frank Wiles wrote:
On Tue, 9 Dec 2003 07:15:41 -0800 (PST)
Ivelin Ivanov [EMAIL PROTECTED] wrote:
Has this subject been discussed before?
I did not find any references to it in the archives.
I think that a co-bundle between an open source J2EE
container like JBoss and a scalable database like
Neil Conway wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
As a Java programmer, I do agree that having a pure Java RDBMS
system would be a Good Thing (tm)
Are there any advantages that this would provide that we could get
without investing so much effort? For example, PL/Java seems like
D'Arcy J.M. Cain wrote:
On December 9, 2003 12:15 pm, Neil Conway wrote:
P.S. While we're contemplating pies-in-the-sky, I'd personally love to
rewrite PostgreSQL in Objective Caml.
I vote for InterCal. :-)
Pick your poison from this site: http://99-bottles-of-beer.ls-la.net/
(see
Dave Cramer wrote:
Have a look at Axion for a pure java db
http://axion.tigris.org/
Not as full featured,but still useful.
Er, I take it that not as full featured is an example of meiosis :-)
Here's what the web page says:
Not (Yet) Supported
Thomas Hallgren wrote:
Hi,
I'm working on a new pl/java prototype that I hope will become production
quality some time in the future. Before my project gets to far, I'd like to
gather some input from other users. I've taken a slightly different approach
than what seems to be the case for other
Thomas Hallgren wrote:
The JVM will be started on-demand.
Although I realize that one JVM per connection will consume a fair amount of
resources, I still think it is the best solution. The description of this
system must of course make it very clear that this is what happens and
ultimately
You also need to quote values containing the separator.
cheers
andrew (who used to set creating CSV as a programming exercise -
students almost never get it right)
David Fetter wrote:
Kind people,
I've come up with yet another little hack, this time for turning 1-d
arrays into CSV format.
Tom Lane wrote:
Dave Page [EMAIL PROTECTED] writes:
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE
-I/usr/include -c -o path.o path.c
gcc: cannot specify -o with -c or -S and multiple compilations
How is prod getting
Peter Eisentraut wrote:
Thomas Hallgren wrote:
What are your thoughts and ideas?
Instead of making up your own stuff, there's a whole SQL standard that
tells you how Java embedded in an SQL server should work. Of course
that doesn't tell you about implementation details.
Where
Nigel J. Andrews said:
On Thu, 11 Dec 2003, Alvaro Herrera wrote:
On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote:
Our dbcommands.c has for create database:
snprintf(buf, sizeof(buf), cp -r '%s' '%s', src_loc,
target_dir);
[...]
I think we should switch to
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
but my BSD/OS manual only documents 'cp -R' and mentions:
I think we should switch to -R in our code.
And break the code on who knows how many other systems? No thanks.
If we want to do anything at all with this code, we should
re Windows: pipes, yes, hard links, no (and no sane symlinks either) -
also of course no (sane) shell - is this going to be a script or a C
program?
Maybe use an option which you would disable on Windows to copy the files
instead of hardlinking them. Yes it would take lots more time and space,
Matthew T. O'Connor wrote:
On Fri, 2003-12-12 at 14:51, Andrew Dunstan wrote:
re Windows: pipes, yes, hard links, no (and no sane symlinks either)
Actually, NTFS does support hard links, there is just no support for it
in any MS file management GUI.
http://msdn.microsoft.com/library
[moved to hackers / win32]
Claudio Natoli wrote:
Or do people have strong leanings towards fix as you go along? Just feels
like that way could see us getting bogged down making things perfect
instead of advancing the port...
w.r.t. Win32, I think the way to proceed is (in this order):
. make
Bruce Momjian wrote:
Andrew Dunstan wrote:
Now for the fun
part (signals).
Actually, no. I thought fork/exec would be a real mess (as did Tom),
but Claudio has done an excellent job of producing a minimal patch. The
work isn't done yet, but this small patch has taken us much closer, so
Bruce Momjian wrote:
Have you looked at the CONNX signal code on the Win32 page:
http://momjian.postgresql.org/main/writings/pgsql/win32.html
It uses shared memory and events.
Yes, and I just did again. I guess I must be missing something, though -
I don't see what in that code causes the
Magnus Hagander wrote:
Bruce Momjian wrote:
Have you looked at the CONNX signal code on the Win32 page:
http://momjian.postgresql.org/main/writings/pgsql/win32.html
It uses shared memory and events.
Yes, and I just did again. I guess I must be missing
something, though -
I don't see what
Magnus Hagander wrote:
Absolutely, but there are other signals to send, no? Or you might want
to send a signal directly to a backend (to cancel for example), as you
can do on Unix.
In normal operation the only thing that should be signalling a backend
is the postmaster.
cheers
andrew
Neil Conway said:
Andrew Dunstan [EMAIL PROTECTED] writes:
In normal operation the only thing that should be signalling a
backend is the postmaster.
Oh? What about LISTEN/NOTIFY?
er, yeah. *self-lart*
+ ... or another backend
cheers
andrew
---(end of broadcast
Andreas Pflug wrote:
Tom Lane wrote:
I think the minimum amount of additional work that has to be done before
we can apply it is to teach psql's input parser about $QUOTE$ ---
without that, the feature is not only useless but counterproductive.
IMHO it's not useless. pgAdmin already knows
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
I see that psql/mainloop.c contains this comment:
* FIXME: rewrite this whole thing with flex
Is now the time to do that?
If you feel like giving it a shot, ain't nobody gonna stand in your way.
MainLoop() is well past the level
Jonathan Gardner wrote:
Marko Zmak wrote:
I've been usin psql for quite a long time and I found it to be very
comfortable. Since some web providers in my country refuse to put psql
while some thing are still in psql TODO list, I'm interested in
following...
I'd like to know when are you
Tom Lane said:
Andrew Dunstan [EMAIL PROTECTED] writes:
case 6 - limit all users' connections regardless of database:
limit all all n
That's called max_connections. Don't think we need a redundant
implementation of same ...
no - this was intended to limit *each* user - max-connections
Þórhallur Hálfdánarson said:
I'd like to mention that administrators likely to use the this feature
would probably like to be able to tune this without having to modify a
file -- updating via SQL (= storing this in a system table) would be
extremely nice...
We set connection permissions in
If people are happy with Tom's suggestion of using '*' instead of 'all'
in pg_hba.conf I will prepare a patch for it.
(I will also replace the ugly long IP6 localhost netmask with a CIDR mask).
cheers
andrew
---(end of broadcast)---
TIP 2: you
1 - 100 of 8267 matches
Mail list logo