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
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
Tom
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
>
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
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 be
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 d
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
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 effecti
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 s
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
"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 broadcast)-
On Fri, 4 Apr 2003, Ed L. wrote:
> On Friday April 4 2003 2:17, scott.marlowe wrote:
> >
> > OK, So I tried putting the 2>&1 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
> > /u
On Friday April 4 2003 2:17, scott.marlowe wrote:
>
> OK, So I tried putting the 2>&1 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 inpu
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+"$@"
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
"Ed L." <[EMAIL PROTECTED]> writes:
> Hmmm. I would have agreed 2>&1 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 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 r
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
every
> 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.
>
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 cur
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
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 comp
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
Ma
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+"$@"} > 2>&1 &
>
> Most if not all of the postmaste
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 ch
"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+"$@"} &1 &
Most if not all of the postmaster's log output goes to stderr, so you'd need
"$po_path" ${1+"$@
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
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 itsel
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 altern
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. T
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
A
"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
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> 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).
AFAICS, the only practical way to do this is to have a single process
collecting the stdout/stderr
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 i
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
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 nam
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
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 relat
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 wil
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 sta
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 ris
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
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 th
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
do
"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
> 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
installation/da
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 exte
47 matches
Mail list logo
