Rebuilding Perl and all it’s related ports fixed it.
Dealing with the FreeBSD folks on what all we (FreeBSD) need to put in
/usr/ports/UPDATING and / or
/usr/src/UPDATING
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l
Looks like the upgrade of this machine to the inode64 commit of FreeBSD busted
stuff.
I’m rebuilding perl and all the ports to see if that fixes it.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail
o"
etc
Less code, no confusion because we have just one client tool - psql.
Several of them have the ability to connect to several databases, some
even do that in parallel.
vacuumdb being one that I've needed recently to do a number of DB's in a
row.
--
Larry Rosenman
ps that have been written
assuming the first part of the version number is only a single digit.
Is that likely? That would be remarkably myopic, but I guess possible.
Thom
We (FreeBSD) had lots of that kind of fallout when 9->10. Autoconf, and
other tools
thought we were a.out and not
regards, tom lane
Definitive FreeBSD Sources:
https://svnweb.freebsd.org/base/
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961
--
Sent via pgsql-hack
On 2016-02-10 17:00, Tom Lane wrote:
Larry Rosenman <l...@lerctr.org> writes:
On 2016-02-10 16:19, Tom Lane wrote:
I looked into the OS X sources, and found that indeed you are right:
*scanf processes the input a byte at a time, and applies isspace() to
each byte separately, eve
On 2015-11-24 13:43, Alvaro Herrera wrote:
Larry Rosenman wrote:
On 2015-11-24 13:11, Tom Lane wrote:
>Kevin Grittner <kgri...@gmail.com> writes:
>>On Tue, Nov 24, 2015 at 11:10 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>>>>change the From header (and add
ll allow you to do.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make cha
to a FreeBSD 10 system that is totally ZFS.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 (c) E-Mail: l...@lerctr.org
US Mail: 108 Turvey Cove, Hutto, TX 78634-5688
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 3/6/2012 8:32 AM, Robert Haas wrote:
On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman l...@lerctr.org
wrote:
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1
Is there any way to get more info out of CLUSTER VERBOSE so it
says what index it's
processes are running.
Do I need to cogitate on the code, or is one of the hackers that knows
it better interested?
Thanks!
- --
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: l...@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 3/7/2012 2:42 PM, Tom Lane wrote:
Larry Rosenman l...@lerctr.org writes:
On 3/7/2012 12:31 PM, Alvaro Herrera wrote:
Also, this isn't limited to CLUSTER; anything that rewrites
the table and indexes would benefit. Meaning ALTER TABLE
versions in 4224437 pages
DETAIL: 0 dead row versions cannot be removed yet.
CPU 168.02s/4324.68u sec elapsed 8379.12 sec.
And at this point it's doing something(tm), I assume re-doing the indexes.
It would be nice(tm) to get more info.
Ideas?
- --
Larry Rosenman http
AND Streaming Replication hit the
tree, the release number would go to 9.0.
Both are in the tree.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: l...@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
--
Sent via pgsql
I might be able to help with:
Sparc
PA-Risc (HP-UX)
IA64
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683E-Mail: l...@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-Original Message-
From: pgsql-hackers-ow
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
Larry Rosenman http
, per filesystem. At least that
was the case on SCO UnixWare (No, I no longer run it).
LER
regards, tom lane
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED]
US Mail: 430 Valona Loop
would the community accept a patch that would allow the making of 4-way fat
binaries on Mac OS X 10.5+? (Obviously for 8.4+).
I'm thinking about attempting it for an inside project here at work, but
was wondering if there was community interest?
Thanks!
--
Larry Rosenman
On Mon, 21 Jan 2008, Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
would the community accept a patch that would allow the making of 4-way fat
binaries on Mac OS X 10.5+? (Obviously for 8.4+).
Depends on how big and ugly it is, I think. If you can do it just by
hacking CFLAGS
On Tue, 22 Jan 2008, Gregory Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
Larry Rosenman [EMAIL PROTECTED] writes:
would the community accept a patch that would allow the making of 4-way fat
binaries on Mac OS X 10.5+? (Obviously for 8.4+).
Depends on how big and ugly it is, I think
owner.
Shouldn't everything that is in the DB be owned by the purported owner?
This is on 8.2.3, btw.
Thanks!
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683E-Mail: [EMAIL PROTECTED]
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
On Mon, 16 Apr 2007, Andrew Dunstan wrote:
Larry Rosenman wrote:
Greetings,
I think I found a bug, or at least a POLA violation. At work, I
created
a user that is NOT a superuser, nor can that user create databases. When I
did a create database foo owner bar, all the schemas are set
On Mon, 16 Apr 2007, Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
When I try and RESTORE a pg_dump in the current state, we get errors because
the public schema is owned by postgres, and the grant commands are issued
as the user (since I'm restoring as the purported owner.
That's
on it.
This will take a week or 2, but I have permission now.
(This box can get out to the internet via our proxy).
LER
Cheers,
Adrian Maier
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock
On Mon, 9 Apr 2007, Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
I think I'll be able to set up my HP-UX 11.11 box here, as soon as it gets
fixed, and assuming either the bundled compiler will work or I can get
GCC on it.
If the bundled compiler is still the same non-ANSI-C weakling
question is:
1) what os(s) do we need more coverage on
2) what collection of options for OS' in 1?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
forget to increase your free space map settings
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
---(end of broadcast
On Fri, 6 Apr 2007, Andrew Dunstan wrote:
Larry Rosenman wrote:
It doesn't matter as far as MY box is concerned. I use VMWare extensively
in my current $DAYJOB, and I want to be able to test/play with things
related
to that as well. The box I'm building will be using the (free) VMWare
On Fri, 6 Apr 2007, Stefan Kaltenbrunner wrote:
Andrew Dunstan wrote:
Larry Rosenman wrote:
It doesn't matter as far as MY box is concerned. I use VMWare
extensively
in my current $DAYJOB, and I want to be able to test/play with things
related
to that as well. The box I'm building
.
What OS's do we need coverage for?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
I might use that as the base then, since the hardware finishes getting here
tomorrow.
My question still stands on what OS's we need coverage for.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona
.
The stats collector CPU usage has dropped from inexcess of 95% to 5%
Thanks.
Any guess on when we'd see an 8.2.4? I have a business reason for asking.
Thanks!
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US
I can set up build farm on it if yall need it. Its running 6.2/amd64
--- Original Message ---
From: Andrew Hammond [EMAIL PROTECTED]
To: Larry Rosenman ler@lerctr.org
Sent: 2/8/07, 12:19:07 PM
Subject: Re: BuildFarm: Do we need another FreeBSD/amd64 member?
On Jan 19 2006, 9:36 pm
No, since my time is up in the air at the moment, I've bowed out for now.
Once I get settled at Surgient, I might take it up again, but not right now.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
Sent: Saturday, September 02, 2006 5:42
both autovacuum and manual
vacuum
as well as analyze (both from the Autovacuum daemon and manual).
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
Bruce Momjian wrote:
Larry Rosenman wrote:
Alvaro Herrera wrote:
Bruce Momjian wrote:
Matthew T. O'Connor wrote:
Bruce Momjian wrote:
Matthew T. O'Connor wrote:
and increasing the log level when autovacuum actually fires off
a VACUUM or ANALYZE command.
This was not done because
, delete) since the last stats reset, then the
vacuum info isn't recorded because we refuse to create the pgstat
entry for the table.
Do I need to write a Doc patch for that? It seemed consistent with other
functions of the
same class when I did the date patch.
--
Larry Rosenman
I've used and use RT. It is web based for admin, but all the transactions
are E-Mail based.
http://www.bestpractical.com
I can also make a test queue on my instance if someone wants to play.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683
about that.
I'd like to echo Jim's sentiment. The last 9 months here have been
great, and
the community is still as wonderful as ever.
I hope I've been a positive asset to both Pervasive and the community
(mailing-list
and IRC).
--
Larry Rosenman
Database Support Engineer
PERVASIVE
on the host for this?
I might be able to use either my house machine or my work desktop
here @pervasive, or one of my test boxes here @pervasive.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop
.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
---(end of broadcast)---
TIP 5: don't forget to increase your
on a dual-xeon in 64-bit mode. HTT *IS* enabled.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast
)
on FreeBSD/amd64, Dual Xeon's in HTT mode help?
What can I do to further the investigation?
It has 8.1.4 on it.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
: Intel(R) Xeon(TM) CPU 3.00GHz
hw.ncpu: 4
hw.byteorder: 1234
hw.physmem: 4286132224
hw.usermem: 4003151872
hw.pagesize: 4096
hw.floatingpoint: 1
hw.machine_arch: amd64
hw.realmem: 5368709120
[snip]
the database is 8.1.4
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1
---(end of
broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Larry Rosenman said:
If I generate fixes for firefly (I'm the owner), would they have a
prayer Of being applied?
Sure, although I wouldn't bother with 7.3 - just take 7.3 out of
firefly's build schedule. That's not carte blanche
Larry Rosenman wrote:
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Larry Rosenman said:
If I generate fixes for firefly (I'm the owner), would they have a
prayer Of being applied?
Sure, although I wouldn't bother with 7.3 - just take 7.3 out of
firefly's build schedule
Larry Rosenman wrote:
Larry Rosenman wrote:
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Larry Rosenman said:
If I generate fixes for firefly (I'm the owner), would they have a
prayer Of being applied?
Sure, although I wouldn't bother with 7.3 - just take 7.3 out
of the
people have no idea how it is set up.
I truly *WANT* to help here, but getting the information is tough.
Larry Rosenman
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax
of testing?
I remember reading something abou this as well but the big question
is:
Where is the scripting?
it's in an admin project on pgfoundry, and VERY lacking in details.
It assumes a LOT of knowledge that is not readily apparent.
--
Larry Rosenman
Database Support
section of the documentation.
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL PROTECTED]
Web: www.pervasive.com
---(end of broadcast
been shot down.
How is this different?
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL PROTECTED]
Web: www.pervasive.com
---(end
Bruce Momjian wrote:
Larry Rosenman wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I thought about this. Attached is a patch you can use to
popen(pg_config) and then look for the thread flag to configure.
One idea would be to add this sample to our libpq documentation
Bruce Momjian wrote:
Larry Rosenman wrote:
Bruce Momjian wrote:
Larry Rosenman wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I thought about this. Attached is a patch you can use to
popen(pg_config) and then look for the thread flag to
configure. One idea would
Bruce Momjian wrote:
Larry Rosenman wrote:
Bruce Momjian wrote:
Larry Rosenman wrote:
Bruce Momjian wrote:
Larry Rosenman wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I thought about this. Attached is a patch you can use to
popen(pg_config) and then look
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
Uh, it is an _admin_ function, not an application programmer
function.
but libpq is the only thing that knows where it is, and I had
proposed a way for psql to use the function to get it.
It'd make more sense for pg_config
for it.
Thanks,
Larry Rosenman
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL PROTECTED]
Web: www.pervasive.com
---(end of broadcast
the logging?
I still don't see a consensus on what needs to come out.
Do we still need the autovacuum_verbosity type change?
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax
see a direct hit looking at the routines we talked about
yesterday, but
I can't be sure.
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL PROTECTED]
Web
Simon Riggs wrote:
On Fri, 2006-04-28 at 22:38 +0200, Martijn van Oosterhout wrote:
On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote:
Martijn van Oosterhout kleptog@svana.org writes:
You know, rather than adding new columns to pg_class, why not
extend the stats collector
, it includes docs as well.
Thanks!
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL PROTECTED]
Web: www.pervasive.com
---(end of broadcast
Larry Rosenman wrote:
Greetings,
I've got a patch to be reviewed for having the stats system keep
track of the last
time a table was vacuumed or analyzed either by the user or via
AutoVacuum.
The patch is at:
http://www.lerctr.org/~ler/pg-dev/vacuum-autovacuum-times-stats.diff
I'd
still reading
code to see whether I can determine
at the time they are cut that this was autovacuum that did it.
Thanks for the nice introductory project :)
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel
Jim C. Nasby wrote:
On Mon, May 01, 2006 at 12:28:21PM -0500, Larry Rosenman wrote:
Since both vacuum and autovacuum will be cutting stats records, do we
want to just have the autovacuum
stats record have the fact that it was autovacuum that did the
vacuum?
Or, is there a way when vacuum
Larry Rosenman wrote:
Jim C. Nasby wrote:
On Mon, May 01, 2006 at 12:28:21PM -0500, Larry Rosenman wrote:
Since both vacuum and autovacuum will be cutting stats records, do
we want to just have the autovacuum
stats record have the fact that it was autovacuum that did the
vacuum
Larry Rosenman wrote:
Simon Riggs wrote:
On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I'd like to see a more concrete definition of what we
want Autovacuum to output and at what levels.
autovacuum_verbosity
Should we call
Robert Treat wrote:
On Friday 28 April 2006 12:09, Larry Rosenman wrote:
Larry Rosenman wrote:
Simon Riggs wrote:
On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I'd like to see a more concrete definition of what we
want Autovacuum to output
(as a relative noobie)
to
do.
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL PROTECTED]
Web: www.pervasive.com
---(end of broadcast
Martijn van Oosterhout wrote:
On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote:
Martijn van Oosterhout kleptog@svana.org writes:
You know, rather than adding new columns to pg_class, why not
extend the stats collector to collect this information.
That sounds doable. And a lot
, and it is very
flexible.
We definitely need to do something wrt autovacuum messages,
but this doesn't say what gets logged at what level for autovacuum.
I'd like to see a more concrete definition of what we
want Autovacuum to output and at what levels.
LER
--
Larry Rosenman
Database
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I'd like to see a more concrete definition of what we
want Autovacuum to output and at what levels.
I would argue that what people typically want is
(0) nothing
(1) per-database log messages
or
(2
---
This sounds like a winner to me. Anyone else want to grab it? I'm
in the position to try and do this, but don't want to step on anyone
else's toes.
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX
that made all
of autovac's vacuums be VERBOSE.
I was thinking along those exact lines. (A 3rd level).
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
people
select it with log_min_messages.
regards, tom lane
I was going to make that same comment, as this seems to be more
implementation
detail, which should be at DEBUGn.
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA
Simon Riggs wrote:
On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I'd like to see a more concrete definition of what we
want Autovacuum to output and at what levels.
autovacuum_verbosity
Should we call it autovacuum_messages?
In current
the following batch file with arguments of 40 40 1000 is
almost guaranteed to trigger the problem, though...
@echo off
dropdb bench
createdb bench
pgbench -i -s %1 bench
pgbench -t %3 -c %2 -n bench
It seems to hang up just fine on my XPSP2, PG 8.1.2 HTT box.
:(
LER
--
Larry Rosenman
Larry Rosenman wrote:
Jim C. Nasby wrote:
On Thu, Apr 20, 2006 at 08:06:30PM +0200, Magnus Hagander wrote:
It reuqires a multi-CPU box, right? I don't hav eone with pgwin32 on
ATM. Do you know if it's enough with hyperthreading?
Hrm... not sure. Let me see if I can find a box with HT here
distro changes it, and you then
overwrite parts of it,
it would be useful for diagnostics.
Comments?
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
1) expose DEFAULT_PGSOCKET_DIR via a libpq call
2) add this information to the psql --version output (or some other
switch, I'm agnostic).
pg_config would seem to be the appropriate place, not libpq nor psql.
The issue is when you
Darcy Buskermolen wrote:
On Tuesday 28 March 2006 14:07, Larry Rosenman wrote:
Greetings,
After helping a user on irc, I was wondering if there would be
any objection to my making a patch that would:
1) expose DEFAULT_PGSOCKET_DIR via a libpq call
2) add this information to the psql
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
Tom Lane wrote:
pg_config would seem to be the appropriate place, not libpq nor
psql.
The issue is what psql (and any libpq using program) is going to use
to find the UNIX socket.
No, the issue is where the server put the socket
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
The other issue is borked installs where the server and libpq
disagree. What I'm looking for is to expose what libpq has for it's
default as well as what the server is using. There is currently no
way to determine what libpq has
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
That's making the assumption that you know which libpq. I was hoping
to have a psql commandline Switch to dump the info, but with your
objection(s), I'll just crawl back under my rock.
It's not that I don't feel your pain ... but if you
that
the windows code
doesn't enable HAVE_UNIX_SOCKETS, and therefore even if the library returns
a string, it's
useless.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
What's the harm of a (pseudo code):
const char *PQgetunixsocketdir(void)
{
return(DEFAULT_PGSOCKET_DIR)
}
In libpq, and a psql command line switch to call it.
By the time you get done adding the infrastructure
the new
diffs (optionally compressed) from the ,v files that are needed to
bring the clients' repository mirror up to date.
As a complete out of nowhere suggestion, you might also look
at csup in FreeBSD's CVS (or the project page), which is a cvsup clone
in C.
LER
--
Larry Rosenman
in 1975.
Started posting on UseNet in 1988.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
of that.
Please do **NOT** change the I/O formats.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
---(end of broadcast
Greetings,
I've got a fast FreeBSD/amd64 server available to run Buildfarm on.
However, I see we already have a couple of others running it.
My questions are:
1) do we need another one?
2) if yes, what options need coverage?
Thanks,
LER
--
Larry Rosenman
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I've got a fast FreeBSD/amd64 server available to run Buildfarm
on.
However, I see we already have a couple of others running it.
My questions are:
1) do we need another one?
2) if yes, what options need
(SCO UDK) / 4.2
For more information, see
http://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=fireflybr=HEAD
This is a Stats failure. I thought the latest change Tom put in would fix
it.
I guess not.
How can I help?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Reposting, since it seems to not have made it :(
Larry Rosenman wrote:
Ever since the stats collector changes, I've seen intermittent
failures
on 'firefly' in the buildfarm. This is my machine.
There is one posted now, and the history has them as well.
Could someone look and tell me
Michael Glaesemann wrote:
On Jan 8, 2006, at 12:12 , Larry Rosenman wrote:
I was thinking of handling the TODO for ISO8601 Interval output.
Just to be clear, you're talking about the ISO8601 duration syntax
(PnYnMnDTnHnMnS), correct? (The SQL standard made the unfortunate
choice
, but got a bounce :(
Thanks,
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast)---
TIP 1
, and I have
a DynDns.org
Hostname that changes to support that, as well as a CNAME out of my
domain to
Point to it.
Just more things to think about.
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel
Bruno Wolff III wrote:
On Tue, Jan 03, 2006 at 12:08:46 -0600,
Larry Rosenman [EMAIL PROTECTED] wrote:
The issue is folks that DON'T set reverse DNS, I.E. have generic
rDNS set on their IP's.
I've seen (in my ISP days, and on my mailserver) LOTS of folks that
can't/won't update
the 4.11-FreeBSD guy refered to above, and with a
very simple table, it comes right back with NO results, but I may not have
what it's looking for in the table definition.
I **DO** get the explain failure, which seems, to me, to be a bug. :(
LER
--
Larry Rosenman, Database Support Engineer, E
Sorry for the top post. If you can get a UDK license, that will work
better.
LER
On Nov 22, 2005, at 12:02 PM, Guillaume Lelarge wrote:
Sorry for answering this late.
2005/11/16, Larry Rosenman ler@lerctr.org:
Bruce Momjian wrote:
The SCO compiler is so buggy (and for so many years) I
1 - 100 of 712 matches
Mail list logo