Hello all,
I am very glad to announce first public release of Open Application Server.
This is an application framework built in C++, to make use of existing APIs in
internet
application.
It provides
* A thread based request delivery architecture
* support of request handlers loaded from
Also, per other discussions, we are removing backend autocommit support
in 7.4. It was the wrong way to do it.
Somehow I did not see that conclusion made.
I thought, at least for JDBC, it is already successfully used ?
I think the backend autocommit is useful. Maybe only the
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes:
Somehow I did not see that conclusion made.
I thought, at least for JDBC, it is already successfully used ?
Barry, at least, seemed to be happy with removing it, given the planned
protocol change to report current transaction state after every
Andrew Sullivan writes:
Is anyone interested in having pglog-rotator?
What would get me a whole lot more excited is if the server could write
directly to a file and do its own rotating (or at least reopening of
files).
Considering that your rotator is tailored to a rather specific setup, it
Jeff, Mlw,
Absolutely. We could just use one large state or several small ones and
let folks download the whole thing if they wanted. Using that technique
you could control the size of the test quite closely and still make
something potentially quite valuable as a contribution beyond the
On Fri, 4 Apr 2003, Peter Eisentraut wrote:
Andrew Sullivan writes:
Is anyone interested in having pglog-rotator?
What would get me a whole lot more excited is if the server could write
directly to a file and do its own rotating (or at least reopening of
files).
Considering that your
On Fri, Apr 04, 2003 at 09:16:39AM -0700, scott.marlowe wrote:
where -r is the rotation period in seconds. If it's an external program
Ours rotates based on size rather than time. I can see some
advantages to the time-based approach, but if you have wide
variations in traffic, you run the
On Fri, Apr 04, 2003 at 05:13:13PM +0200, Peter Eisentraut wrote:
use of pg_ctl, it's written in Perl, and it doesn't do anything for
Windows users, I think it's not suitable for a general audience.
It doesn't prevent the use of pg_ctl, although it does indeed prevent
the use of pg_ctl for
When a sequence is created in 7.3.2, it appears you get a new table for each
sequence object. Is it ever possible for the sequence_name in a sequence
relation not to match the name of the relation itself?
For example, suppose I create a table:
CREATE TABLE t1(id serial);
A new
On Friday April 4 2003 9:16, scott.marlowe wrote:
That said, a log rotation capability built right into pg_ctl or
thereabouts would be a very nice feature. I.e. 'pg_ctl -r 86400 -l
$PGDATA/logs/pgsql start'
where -r is the rotation period in seconds. If it's an external program
that
On Friday April 4 2003 10:04, Ed L. wrote:
By way of feature ideas, one very convenient but not widely used feature
of Apache's log rotator is the ability to specify a strftime() format
string for the file extension. For example, if I want to have my logs
rollover every 24 hours and be named
Peter Eisentraut wrote:
Andrew Sullivan writes:
Is anyone interested in having pglog-rotator?
What would get me a whole lot more excited is if the server could write
directly to a file and do its own rotating (or at least reopening of
files).
From a technical point of view I don't
On Fri, 4 Apr 2003, Andrew Sullivan wrote:
On Fri, Apr 04, 2003 at 09:16:39AM -0700, scott.marlowe wrote:
where -r is the rotation period in seconds. If it's an external program
Ours rotates based on size rather than time. I can see some
advantages to the time-based approach, but if you
Ed L. [EMAIL PROTECTED] writes:
When a sequence is created in 7.3.2, it appears you get a new table for each
sequence object. Is it ever possible for the sequence_name in a sequence
relation not to match the name of the relation itself?
ALTER TABLE RENAME on a sequence doesn't update the
On Friday April 4 2003 10:19, Tom Lane wrote:
I feel we really ought to have *some* rotator included in the standard
distro, just so that the Admin Guide can point to a concrete solution
instead of having to arm-wave about what you can get off the net.
If someone can offer a better
On Friday April 4 2003 10:24, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
When a sequence is created in 7.3.2, it appears you get a new table for
each sequence object. Is it ever possible for the sequence_name in a
sequence relation not to match the name of the relation itself?
In
On Fri, 4 Apr 2003, Ed L. wrote:
On Friday April 4 2003 10:19, Tom Lane wrote:
I feel we really ought to have *some* rotator included in the standard
distro, just so that the Admin Guide can point to a concrete solution
instead of having to arm-wave about what you can get off the net.
scott.marlowe [EMAIL PROTECTED] writes:
rotatelogs is in my path and all, it just never sees it.
You mean the command fails? Or just that it doesn't capture output?
$po_path ${1+$@} /dev/null | $PGPATH/rotatelogs $logfile $DURATION 21
Most if not all of the postmaster's log output goes to
On Friday April 4 2003 11:58, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
rotatelogs is in my path and all, it just never sees it.
You mean the command fails? Or just that it doesn't capture output?
$po_path ${1+$} /dev/null | $PGPATH/rotatelogs $logfile $DURATION
21
Most
My build failed in interfaces/ecpg/compatlib because the Makefile
references pgtypeslib instead of compatlib. I was wondering why
nobody else got that problem. Maybe because they have an old version
of informix.c lying around in pgtypeslib? Anyway, this patch should
fix that problem.
Servus
On Fri, 4 Apr 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
rotatelogs is in my path and all, it just never sees it.
You mean the command fails? Or just that it doesn't capture output?
The database starts, but rotatelogs doesn't get run. I.e. it's just like
everything
Ed L. [EMAIL PROTECTED] writes:
Hmmm. I would have agreed 21 was needed, too, but this command seems to
routinely capture all output, including ERRORs:
nohup pg_ctl start | nohup rotatelogs server_log.%a 86400
That's 'cause pg_ctl internally redirects the postmaster's stderr.
On Fri, 4 Apr 2003, Ed L. wrote:
On Friday April 4 2003 11:58, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
rotatelogs is in my path and all, it just never sees it.
You mean the command fails? Or just that it doesn't capture output?
$po_path ${1+$@} /dev/null |
On Friday April 4 2003 2:17, scott.marlowe wrote:
OK, So I tried putting the 21 before the | and all. No matter what I
try, every from the | on is ignored. ps doesn't show it, and neither
does pg_ctl status. Both show a command line of
/usr/local/pgsql/bin/postmaster as the only input to
On Fri, 4 Apr 2003, Ed L. wrote:
On Friday April 4 2003 2:17, scott.marlowe wrote:
OK, So I tried putting the 21 before the | and all. No matter what I
try, every from the | on is ignored. ps doesn't show it, and neither
does pg_ctl status. Both show a command line of
scott.marlowe [EMAIL PROTECTED] writes:
Hey, do you guys think that a setting of silent_mode = false might affect
no log files getting created?
No, but setting it to true would be bad news.
regards, tom lane
---(end of
Tom Lane wrote:
Kevin Brown [EMAIL PROTECTED] writes:
When a heavy INSERT or UPDATE load on a table is occurring (lots of
quick INSERTs or UPDATEs within a single transaction), a VACUUM
ANALYZE (or just straight VACUUM) has a really good chance (10% or so)
of causing either the
On Fri, 4 Apr 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Hey, do you guys think that a setting of silent_mode = false might affect
no log files getting created?
No, but setting it to true would be bad news.
That's what I'd meant actually. I had to turn of silent
Kevin Brown [EMAIL PROTECTED] writes:
I finally got 7.3.2 installed, and confirmed that the problem does not
exist on that version. So this is something that's limited to the
7.2.x tree. Which, I guess, means that it's not going to get fixed
for that tree (I assume that 7.2.x is effectively
On Thu, Apr 03, 2003 at 04:47:45PM -0500, Tom Lane wrote:
The IPv6 patch seems to still be a few bricks shy of a load. Grepping
for places that handle AF_INET but not AF_INET6 revealed these
unimplemented features:
1. IDENT authorization. Fails if either local or remote address is IPv6.
Kurt Roeckx [EMAIL PROTECTED] writes:
2. SSL. Postmaster allows SSL for AF_INET but not AF_INET6.
Hmm, it really shouldn't matter if it uses AF_INET or AF_INET6
... I should look into that.
Yeah, I suspect it just needs to replace the == AF_INET test with
an isAF_INETx() test. But I don't
Tom Lane writes:
AFAICS, the only practical way to do this is to have a single process
collecting the stdout/stderr from the postmaster and all its children.
I think not. It's a little tricky handling it directly in the child
processes, but it's been done before.
If someone can offer a
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
AFAICS, the only practical way to do this is to have a single process
collecting the stdout/stderr from the postmaster and all its children.
I think not. It's a little tricky handling it directly in the child
processes, but it's
Andrew Sullivan wrote:
On Thu, Apr 03, 2003 at 02:39:17PM -0500, Tom Lane wrote:
just not listing zero_damaged_pages in postgresql.conf.sample? We
already have several variables deliberately not listed there ...
Hey, that might be a good solution. Of course, it doesn't solve the
Andreas,
From the JDBC side it really doesn't make that much difference. The
JDBC code needs to support both ways of doing it (explicit begin/commits
for 7.2 and earlier servers, and set autocommit for 7.3 servers), so
however it ends up for 7.4 it shouldn't be too much work to adopt. As
Kevin Brown [EMAIL PROTECTED] writes:
Shouldn't each variable listed in postgresql.conf.sample have comments
right above it explaining what it does anyway?
Not really --- if you can't be bothered to consult the Admin Guide when
in doubt, you have no business editing the config file. A word or
The fcc FTP site is ftp.fcc.gov
The location of the data of interest is at
/pub/Bureaus/Wireless/Databases/uls/.
There are zip files (pipe delimited) in complete and the daily changed
files in daily. Theres lots of info in documentation which includes
excel spreadsheets of the schema. These
Merlin,
The fcc FTP site is ftp.fcc.gov
The location of the data of interest is at
/pub/Bureaus/Wireless/Databases/uls/.
Cool. I'll tackle this in a week or two. Right now, I'm being paid to
convert a client's data and that'll keep me busy through the weekend ...
--
-Josh Berkus
Josh Berkus wrote:
Cool. I'll tackle this in a week or two. Right now, I'm being paid
to
convert a client's data and that'll keep me busy through the weekend
...
I would suggest downloading the data now. I can help get you started
with the create table statements and the import scripts.
On Friday 04 April 2003 11:47, Merlin Moncure wrote:
The location of the data of interest is at
/pub/Bureaus/Wireless/Databases/uls/.
wireless services. This includes most two way systems and point to
multipoint (microwave) but not broadcast (AM, FM, TV) and not advanced
radio.
Also check
Lamar Owen wrote:
Also check 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)
--
Up until about 6 months ago, I worked at a company
Lamar,
Also check 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)
Hey, if you're willing to do the text -- postgres conversions,
On Friday 04 April 2003 14:23, Merlin Moncure wrote:
Up until about 6 months ago, I worked at a company called RadioSoft.
They are a provider of high quality database, engineering, and GIS
software. The company has its roots as source of engineering tools for
broadcast engineers. They
I'm quite familiar with RadioSoft. Can't afford any of the software;
familiar
with the products... :-)
I've been putting 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
On Friday 04 April 2003 14:54, Merlin Moncure wrote:
I can tell you, though; the land mobile database is much more
complicated. Getting it to run decently on pc hardware is a significant
engineering challenge.
Then it sounds like it's a better fit for Josh's requirements.
ill-fated DTV
Lamar,
I do still want to get CDBS in a PostgreSQL setup, with automatic nightly
import, at some point in time. Just probably not as quickly as Josh needs a
dataset to crank on.
Oh, I don't know. I expect setting this up to take several weeks. And if
we do the CDBS database as part of
46 matches
Mail list logo