When I try to commit to cvs it gets stuck and outputs this messages every
30:th second:
cvs server: [11:11:28] waiting for ishii's lock in
/cvsroot/pgsql-server/src/bin/pg_controldata/po
--
/Dennis Björklund
---(end of broadcast)---
TIP 9: the
Mark Lubratt [EMAIL PROTECTED] writes:
On Feb 27, 2004, at 10:28 PM, Tom Lane wrote:
Mark Lubratt [EMAIL PROTECTED] writes:
I've been trying to be careful, but I've gotten out of synch with
whether or not I've applied the changes I've made to the development
system to the production system.
Working with current CVS:
$ createlang plpgsql
createlang: language installation failed:
ERROR: could not load library /pgroot-cvs/lib/postgresql/plpgsql.so:
/pgroot-cvs/lib/postgresql/plpgsql.so:
undefined symbol: downcase_truncate_identifier
--strk;
---(end of
On Saturday 28 February 2004 15:39, Tom Lane wrote:
Mark Lubratt [EMAIL PROTECTED] writes:
On Feb 27, 2004, at 10:28 PM, Tom Lane wrote:
Mark Lubratt [EMAIL PROTECTED] writes:
I've been trying to be careful, but I've gotten out of synch with
whether or not I've applied the changes I've
Interestingly I tried to address the same problem few days ago.
I used pg_dump, grep, etc - in the end I got what I needed, but
it was a cumbersome ordeal.
I think ideally it would be great to have a utility that would
give me a clean diff. between the schemas.
Perhaps pg_dump could have a new
Hello ,
Can somebody please tell me how to get the name of the relation (Attribute
also) from the Oid and the otherway back (Oid from name) ??
thanks
-Ramu
_
Masterpieces made affordable! Buy art prints.
On Saturday 28 February 2004 18:47, Ramanujam H S Iyengar wrote:
Hello ,
Can somebody please tell me how to get the name of the relation (Attribute
also) from the Oid and the otherway back (Oid from name) ??
The pg_class table is what you want.
See the system-tables chapter of the manuals
I'm looking at doing the bundle up on Sunday night, and announce on Monday
... any outstanding back-patches that need to get in? Tom/Bruce, on
scheduale for doing the docs changes?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED]
Hello,
I wanted to submit some changes to the bundled postgres startup
script for Mac OS X. I added calls to utilize the bundled apache
rotatelogs script in the DB startup for log rotation. Also modified
startup parameters file to allow using the SystemStarter utility to
start/stop/restart
Hi,
Recently, I ran a huge update on an Integer column affecting 100 million
rows in my database. What happened was my disk space increased in size and
my IO load was very high. It appears that MVCC wants to rewrite each row
(each row was about 5kB due to a bytea column). In addition, VACUUM
[EMAIL PROTECTED] (Tom Lane) wrote in message (in part)
...
Hmm. This may be OS-specific. The shlibs certainly show up in the
output of lsof in every variant I've checked, but do they count against
your open-file limit?
From the lsof FAQ:
5.2 Why doesn't Apple Darwin lsof report text
On Tue, 24 Feb 2004, Stephen wrote:
It came to my mind that what if there could be a mechanism in place to allow
overwriting portions of the same row *whenever possible* instead of creating
a new row as MVCC would require.
How would you do a rollback if an error occurred mid-query? How would
Marc G. Fournier wrote:
I'm looking at doing the bundle up on Sunday night, and announce on Monday
... any outstanding back-patches that need to get in? Tom/Bruce, on
scheduale for doing the docs changes?
I can package up this week, but not this weekend, and we should have the
release item
On Sat, 7 Feb 2004, Bruce Momjian wrote:
Please have a look and comment, the patches can be found here:
http://www.iki.fi/hlinnaka/pgsql/
What is the schedule for 7.5? Any chance of getting this in?
7.5 is certainly possible. We are months away from beta on 7.5 and I
would like ot see
Mark,
On Mon, 23 Feb 2004 09:42:34 -0800 (PST), [EMAIL PROTECTED] said:
Mark http://developer.osdl.org/markw/ia64/dbt2/
Mark I have a summary of intial results from our DBT-2 workload with
Mark PostgreSQL 7.4.1 on a 4-way Itanium2 system with 16GB of memory and 56
Mark drives using LVM2
On Fri, Feb 20, 2004 at 05:26:46AM -0500, Neil Conway wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Kenneth Marshall would like me to post this:
I agree that in order to manage today's large memory machines, we
need to have less contention in our buffer management strategies.
The two main
Hi all!
Sorry for my latencies.
An IRC chat is ok for me, anytime.
On Sun, Feb 22, 2004 at 08:08:00PM +0100, Thomas Hallgren wrote:
I'm in Sweden. Some time tuesday evening (european time) perhaps?
Why is your work not made public somewhere? The project on sourceforge is
inactive it seems.
Hello all,
PostgreSQL, at least until version 7.4, has rather weak support for
various collating sequences. What you get when you do
select * from table order by column
is hardcoded in the database cluster at the initdb time. Yet, it is
reasonable request to want one select to order by
Alex,
In our quest to see if we can get better performance out of PostgreSQL
by throwing more HW at it, I would have recommended a V880 also. I'm
curious to find out why you would have: (in the past, I would have
suggested a Sun V880 for this database, but we are using Linux on
x86) too.
Cheers,
Shridhar Daithankar
[EMAIL PROTECTED] 25/02/2004 10:31:16
On Wednesday 25 February 2004 15:38, Paul Simpson
wrote: Thank you for the advice, unfortunately, that isn't an
option, you see I didn't write the application and so cannot control
the calls it makes. What I need is for PG to do as
There is a roundup version for postgresql. I have not tried it.
For python people, this is the ultimate solution. It is
customizable to death. I have the mailing list archives for
the last couple of months.
I like round up and use it. It has a great email interface
and a nosy list feature which
On Friday 27 February 2004 22:24, Lee Kindness wrote:
Sort of related, I was thinking about adding some more thread-related
code such that if a connection wasn't explicitely specified then the
last connection SET or CONNECTed to for the current thread is used,
rather than just the last
Hi,
please look at CodeBeamer (www.intland.com) it has all featured you
described and for selected open source projects is free now.
It is a web based collaborative software development platform with
-project tracking (dashboard)
-tracker
-document manager (sharing + versioning)
-forum
-cvs,
Is it possible for Postgres Btrees to support access by logical row number ?
If not available is ti a huge job to support for sombebody willing to have a go ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello ,
Can somebody please tell me how to get the name of the
relation (Attribute also) from the Oid and the
otherway back (Oid from name) ??
thanks
-Ramu
=
Karyathuranaam na Sukham na Nidhra
www.it.iitb.ac.in/~ramu
Hi
Thinking of producing a modified version of Postgres to allow clients
bypass the SQL type intefaces.
How easy is to to get cursor access to the indexes and fine grained
control of the transaction system, are their fairly clean internal
APIs I can leverage.
Cheers
Chad
On Feb 26, 2004, at 6:53 PM, Joseph Tate wrote:
Josh Berkus wrote:
Folks,
Discuss:
Has anyone talked to the people at collabnet (http://www.collab.net)?
I wonder if they'd be willing to put something together for the
PostgreSQL team? They run the tigris.org site, which is one of the
nicest
qmis wrote:
Hi all
How can i read transactions from write ahead logpg_xlog ?
It is possible ?
No, it is all binary and read only on startup after a crash. If you want
to interpret it, you have to read the backend code that reads it during
recovery.
--
Bruce Momjian
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
** 4. Make the postmaster spawn threads rather than processes **
I know this is very controversial and perhaps I should not bring it up at
all. But then again, why not? Most readers are open-minded right?
It's been considered and
Janos,
So far, all of the solutions that are being seriously considered seem to be
free, open-source software. I can't find any indication on your site that
this is software the PostgreSQL community can hack to bits as needed over
the years. Even if it's free now, there's the possibility that it
Ordering the pg_dump output by name within classes instead of OID sounds
good to me, too.
Also, something that might be easier for comparing schemata between
databases: rather than dumping the database, have you tried using PostgreSQL
Autodoc (http://www.rbt.ca/autodoc/) which just outputs the
Why GForge?
GForge seems to be technically OK. But what about the future outlook. The home
page lists 5 projects, whereof the 4 are tests. Are you sure they will not
fold in a month or two, will they be reliable, responsive and real nice (the
three r's) ?
--
Kaare Rasmussen
Hi all,
We are providing database solutions in postgreSQL...Now using PostgreSQL 7.3. It is performing well. But Now we have some enterprice level requirements.
One of Our requirement is to provide a distributed solution in PostgreSQL.
The questions are...1. Is it posible to provide a distributed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 24 February 2004 01:48 pm, Robert Treat wrote:
On Tue, 2004-02-24 at 12:11, Richard Huxton wrote:
On Tuesday 24 February 2004 16:11, Jonathan M. Gardner wrote:
I've written a summary of my findings on implementing and using
Richard Huxton [EMAIL PROTECTED] writes:
I've been looking at storing $REVISION$ in comments for each object, so my
install scripts can halt if there is a problem. Not wanting to use my only
comment slot for this I was thinking about an extension to the COMMENT ON
statement:
COMMENT ON
On Sat, Feb 28, 2004 at 10:39:40AM -0500, Tom Lane wrote:
Have you tried diffing pg_dump output? It's not the greatest tool but
it's helpful.
Yes, I did. It was quite cumbersome. Especially since the OIDs and
TOC entry numbers didn't matchup; and, since those didn't always match,
Bruce Momjian [EMAIL PROTECTED] writes:
Marc G. Fournier wrote:
I'm looking at doing the bundle up on Sunday night, and announce on Monday
... any outstanding back-patches that need to get in? Tom/Bruce, on
scheduale for doing the docs changes?
I can package up this week, but not this
On Sun, Feb 29, 2004 at 02:35:59AM +0100, Kaare Rasmussen wrote:
Why GForge?
GForge seems to be technically OK. But what about the future outlook. The home
page lists 5 projects, whereof the 4 are tests. Are you sure they will not
fold in a month or two, will they be reliable, responsive
Hello
Are there any Gentoo users here?
Yes, there are some :)
Do you wish the PostgreSQL ebuild made use of SLOTS?
- to allow installing of major versions together (eg. 7.3 and 7.4 on the
same host)
- to ease migration of databases to new major versions (where a
dump/reload is
I dont see a real need for slots, but I do question why the 7.4 branch
isnt marked as stable yet. :)
Gavin
Jyry Kuukkanen wrote:
Hello
Are there any Gentoo users here?
Yes, there are some :)
Do you wish the PostgreSQL ebuild made use of SLOTS?
- to allow installing of major
George A.J wrote:
Hi all,
We are providing database solutions in postgreSQL...
Now using PostgreSQL 7.3. It is performing well.
But Now we have some enterprice level requirements.
One of Our requirement is to provide a distributed solution in PostgreSQL.
The questions are...
1. Is it
Andrew Dunstan wrote:
Nice. Only two comments --- does this mean we should remove log_pid?
Seems it is now duplicate functionality. Is that the only duplication?
Also, I don't see any documention changes in the patch, but I assume you
will work on that before final.
I will do docs. We
Bruce Momjian wrote:
Andrew Dunstan wrote:
Nice. Only two comments --- does this mean we should remove log_pid?
Seems it is now duplicate functionality. Is that the only duplication?
Also, I don't see any documention changes in the patch, but I assume you
will work on that before final.
43 matches
Mail list logo