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.
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 d
On Sat, Feb 28, 2004 at 09:23:48PM -0500, Alex J. Avriette wrote:
> 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
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, respon
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. I
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 t
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
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
> 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--Lin
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 sc
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
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 version
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 con
qmis wrote:
> Hi all
>
> How can i read transactions from "write ahead log " pg_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
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 O
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
--
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 r
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
__
Folks,
Tim Perdue sent me this.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
--- Begin Message ---
Josh Berkus wrote:
Tim,
To follow up on the previous question, there are a few features that I'm not
seeing in the GForge demo online. These are all features that our
developers w
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
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, Subve
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 con
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
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
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
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
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 seem
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.
> >
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 us
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
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 l
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 it
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 woul
[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 te
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 needs
-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
> > >
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 p
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]
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
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.
http://go.msnserver.com/IN/
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 ar
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 th
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
strk <[EMAIL PROTECTED]> writes:
> 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
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 produ
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 p
46 matches
Mail list logo
