Re: [GENERAL] Mail server load

2003-08-20 Thread The Hermit Hacker
be requests ... all of which would have been Passed thorugh amavisd ... > > > > > > > The Hermit Hacker wrote: > > > > > 16:00 ... > > > > > > neptune# awk '{print $7}' /var/log/amavisd | sort | uniq -c > > > 285 BAD > > > 1807 BANNED

Re: [GENERAL] Changed mailing list functionality?

2003-08-20 Thread The Hermit Hacker
we haven't changed any of the list configs in months ... On Wed, 20 Aug 2003, Ron Johnson wrote: > Hi, > > Up until a few days ago, when I did a "Reply to List" in my MUA > (Evolution 1.4.4), only [EMAIL PROTECTED] would show > up in the "To:" list. Now, "Reply to List" acts like like "Reply >

Re: [GENERAL] Mail server load

2003-08-20 Thread The Hermit Hacker
On Wed, 20 Aug 2003, Paul Thomas wrote: > There's a few come thru the list to me and I had a few more yesterday as > part of the daily spam. Like most people from the non-M$ world, this sort > of thing just passes me by :) I'm looking into how to add a 'taboo subject' filter onto the mj2 lists th

Re: [GENERAL] Mail server load

2003-08-20 Thread The Hermit Hacker
On Wed, 20 Aug 2003, Francois Suter wrote: > > So far today: > > > > neptune# awk '{print $7}' /var/log/amavisd | sort | uniq -c > > 137 BAD > > 1732 BANNED > > 4435 INFECTED > > 6029 Passed, > > And still some make it through given some of the messages that are > reaching the list today ("That m

Re: [GENERAL] move to usenet?

2003-08-20 Thread The Hermit Hacker
On Wed, 20 Aug 2003, Jules Alberts wrote: > Op 19 Aug 2003 (15:35), schreef The Hermit Hacker <[EMAIL PROTECTED]>: > > On Tue, 19 Aug 2003, Jules Alberts wrote: > > > > > Hello everyone, > > > > > > This is not a troll and I certainly don't wan

Re: [GENERAL] Mail server load

2003-08-20 Thread The Hermit Hacker
So far today: neptune# awk '{print $7}' /var/log/amavisd | sort | uniq -c 137 BAD 1732 BANNED 4435 INFECTED 6029 Passed, On Wed, 20 Aug 2003, Nigel J. Andrews wrote: > > > Marc, I'd be interested in seeing the updated stats for this bought of virus > transmission we're going through. > > Yest

Re: [GENERAL] Why the duplicate messages to pgsql-general?

2003-08-16 Thread The Hermit Hacker
On Sat, 16 Aug 2003, Shridhar Daithankar wrote: > On 15 Aug 2003 at 10:36, Ron Johnson wrote: > > > In Evolution, I am able to do "Actions->Reply to List" Outlook 97 > > doesn't have such a feature, but I'm sure that MozMail, Pine and Mutt > > do. > > On the same topic, quite a few other lists I

Mail Hubs (Was: Re: [GENERAL] Why the duplicate messages ... )

2003-08-15 Thread The Hermit Hacker
. If you do contact me, please let me also know what TLDs you are willing to hub for ... On Fri, 15 Aug 2003, Dennis Gearon wrote: > I saw 14 hours between yesterday and today. Was the site down? > > The Hermit Hacker wrote: > > > On Thu, 14 Aug 2003, expect wrote: > >

Re: [GENERAL] Why the duplicate messages to pgsql-general?

2003-08-15 Thread The Hermit Hacker
On Thu, 14 Aug 2003, expect wrote: > On Thu, 14 Aug 2003 00:23:34 -0400 (EDT) > Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > > Uh, we do that so folks get the replies quicker. > > Uh, why not get a better mail server? Seriously it seems that it really is > very slow. Is it under powered? Th

Re: [GENERAL] Continued mail server problems for all PGSQL mailing

2003-08-14 Thread The Hermit Hacker
On Sat, 9 Aug 2003, Phil Howard wrote: > | %nslookup 207.173.200.143 > | Server: neptune.hub.org > | Address: 64.117.224.130 > | > | Name:hosting.commandprompt.com > | Address: 207.173.200.143 > | > | Joshua, are there multiple IPs on that box that he might be seeing? > > Then is 207.173.20

Re: [GENERAL] plPHP -- sort of an announcement.. but not commercial

2003-08-06 Thread The Hermit Hacker
On Wed, 6 Aug 2003, Peter Eisentraut wrote: > scott.marlowe writes: > > > Do we need official permission to call the language plPHP by the way? > > Can someone explain to me why language handler modules for PostgreSQL are > always called "PL/Language"? Consider if someone wrote a language binding

[GENERAL] v7.4 Beta 1 Bundle Available for Testing ...

2003-08-05 Thread The Hermit Hacker
Just a quick note to everyone that v7.4 is now official in Beta Freeze, with the first Bundle available for download, testing and bug reports ... The Bundle is available on all FTP mirrors (in both .gz and .bz2 format) under: /pub/source/v7.4 We encourage everyone that is able to downlo

Re: [GENERAL] Diff between contrib/dbmirror and rserv

2003-07-30 Thread The Hermit Hacker
On Wed, 30 Jul 2003, Andrew Sullivan wrote: > A version of replication that descended from rserv is going to appear on > gborg someday soon. I'm not sure when. Got hit by a death in the family this past weekend ... will dive into moving this forward more over the next few days :( Sorry for the

[GENERAL] v7.3.4 Bug Fix Release

2003-07-26 Thread The Hermit Hacker
In order to address a potentially serious (although rare) server startup failure that was recently reported, we have just bundled up and put onto the ftp sites v7.3.4 of PostgreSQL ... It is a recommended upgrade, and does not require a dump/restore of your existing databases to put into place.

Re: [GENERAL] New Poll @ Codewalkers

2003-07-22 Thread The Hermit Hacker
16% On Tue, 22 Jul 2003, Gavin M. Roy wrote: > Sorry if this is a repost, but codewalkers have a poll up for php > developers for their database of choice. I'm not affiliated with the > site in any way, I just want to see PgSQL at more than 8% :( It's right > on the homepage. > > http://code

Re: [GENERAL] What about a comp.databases.postgresql usenet newsgroup

2003-07-18 Thread The Hermit Hacker
On Sat, 12 Jul 2003, Daniel Seichter wrote: > Hello, > > see news.us.postgresql.org for now, while we deal with some issues locally > > ... if anyone else wishes to open up a similar mirror, please let us know > > and we'll help get it setup ... > > > > all the lists are gatewayed to a comp.databa

Re: [GENERAL] What about a comp.databases.postgresql usenet newsgroup

2003-07-12 Thread The Hermit Hacker
see news.us.postgresql.org for now, while we deal with some issues locally ... if anyone else wishes to open up a similar mirror, please let us know and we'll help get it setup ... all the lists are gatewayed to a comp.databases.postgresql.* newsgroup ... On Thu, 10 Jul 2003, Bruno BAGUETTE wr

[GENERAL] PostgreSQL Advocacy Fund and New Banner Ads

2003-07-08 Thread The Hermit Hacker
POSTGRESQL ADVOCACY FUND Robert Treat has been selected by the Core Team as Treasurer for our new PostgreSQL Advocacy Fund. Robert will soon be setting up an account in the U.S. for receiving donations for the promotion of PostgreSQL. This fund will be used primarily to print promotional materi

Re: [GENERAL] Website (DNS) is hosed!!!

2003-07-08 Thread The Hermit Hacker
On Tue, 8 Jul 2003, Andrew Sullivan wrote: > On Mon, Jul 07, 2003 at 08:39:13PM -0500, Daniel Armbrust wrote: > > Do you realize your entire website is hosed? NONE of the download sites > > will resolve, and NONE of the mirror sites work (or will resolve). > > > What is up? > > Maybe you have a b

Re: [GENERAL] Gborg is down

2003-07-07 Thread The Hermit Hacker
Should already be fixed ... tested from my location ... runaway postmaster process doign a SELECT on the gborg database ... been running since Friday *roll eyes* killed it off and things drop'd back down to normal ... On Mon, 7 Jul 2003, Aaron Dummer wrote: > Hello list, > > I'm unable to load h

Re: [GENERAL] archives.postgresql.org weirdness

2003-07-02 Thread The Hermit Hacker
Odd, I've never noticed that before ... will look into it though, I must have something in the wrong place in the .resource file ... On Wed, 2 Jul 2003, Alvaro Herrera wrote: > Guys, > > Is anyone else annoyed by the fact that the "thread view" for the lists > in archives.postgresql.org is incom

Re: [GENERAL] postgresql.org is unreliable

2003-07-01 Thread The Hermit Hacker
On Tue, 1 Jul 2003, Reuben D. Budiardja wrote: > I just upgrade to the last stable mozilla, and it seems fine, at least for now > with initial try. Still don't know what's wrong. I'd be curious as to whether or not you are getting any packet loss between your machine and www.postgresql.org, speci

Re: [GENERAL] Is news.postgresql.org still alive?

2003-07-01 Thread The Hermit Hacker
Its setup and ppl have been using it to read news ... can you confirm the IP/hostname you are trying to connect from? So that I can check the logs for any specific problems? Is anyone else noticing problems? On Wed, 25 Jun 2003, Dave Bodenstab wrote: > > I used to read the news postings on new

Re: [GENERAL] postgresql.org is unreliable

2003-07-01 Thread The Hermit Hacker
On Tue, 1 Jul 2003, Reuben D. Budiardja wrote: > > Hi > Does anyone else find the site postgresql.org kinda unreliable? Many times > it's stalled for a while. And it's not just today, but very often. It's > really frustrating especially when I regularly use it to look up > documentation. Is it sp

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

2003-06-22 Thread The Hermit Hacker
On Sun, 22 Jun 2003, Eric Frazier wrote: > constantly making major improvements. I have asked this before, where is > Replication with PostgreSQL? Replication for PostgreSQL has been available, and in production use, for at least two years now ... the .ORG registry is using eRServer ... there w

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

2003-06-22 Thread The Hermit Hacker
On Sun, 22 Jun 2003 [EMAIL PROTECTED] wrote: > > On Sun, 22 Jun 2003 [EMAIL PROTECTED] wrote: > > > > > MySQL also does case independent text comparisions, and apparently ONLY > > > case-insensitive comparisons. > > > > Is this a good thing? Doesn't sound like it to me, but figured I'd ask :) > >

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

2003-06-22 Thread The Hermit Hacker
On Sun, 22 Jun 2003 [EMAIL PROTECTED] wrote: > MySQL also does case independent text comparisions, and apparently ONLY > case-insensitive comparisons. Is this a good thing? Doesn't sound like it to me, but figured I'd ask :) ---(end of broadcast)

Re: [pgsql-advocacy] [GENERAL] MySQL gets $19.5 MM

2003-06-21 Thread The Hermit Hacker
On Fri, 20 Jun 2003, Tom Lane wrote: > The core committee has spent a fair amount of time worrying about > exactly this issue, as first Great Bridge and later Red Hat threatened > to become the 800-pound gorilla. As a former employee of the former and > a current employee of the latter, I may not

Re: [pgsql-advocacy] [GENERAL] MySQL gets $19.5 MM

2003-06-20 Thread The Hermit Hacker
On Fri, 20 Jun 2003, Michael Meskes wrote: > There are some, but I still disagree. The biggest advantage of > PostgreSQL in my opinion has always been that it's a community project > and not driven by some commercial interests. I also do not agree that > IBM is so important for Linux. IBM helps ye

Re: [GENERAL] news server access down?

2001-07-13 Thread The Hermit Hacker
nope, that was fixed ... On Thu, 12 Jul 2001, Joseph Shraibman wrote: > The Hermit Hacker wrote: > > > > Service is still offered, we've having a problem with hardware locking up > > solid for no apparent reason ... its being looked into ... > > > > Is th

Re: [GENERAL] 7.1.2

2001-05-29 Thread The Hermit Hacker
sorry, my fault, just fixed all the links in teh ftp ... On Tue, 29 May 2001, Alexey Borzov wrote: > Greetings, Martín! > > At 29.05.2001, 17:28, you wrote: > > MM> Where can I get 7.1.2? The primary ftp server refuses me to enter, and the > MM> mirror sites are not updated. > In fact they

[GENERAL] PostgreSQL v7.1.2 Now Available ...

2001-05-25 Thread The Hermit Hacker
Just a quick announcement that v7.1.2 is now available for download ... primarily a bug fix release, the following changes have been made: Changes --- Fix PL/PgSQL SELECTs when returning no rows Fix for psql backslash core dump Referential integrity permission fix Optimizer fixes pg_dump cle

Re: [GENERAL] v7.1.1 Branched, Packaged and Released ...

2001-05-07 Thread The Hermit Hacker
takes Vince a day or two to catch up ... yes, we are officially released, and Tom just dump'd some major stats changes into HEAD ... On Mon, 7 May 2001, Tatsuo Ishii wrote: > Does this mean that we have officially released 7.1.1? I could not > find any statements regarding 7.1.1 on the web pag

[GENERAL] Web-based Problem/Project tracking system ...

2001-05-05 Thread The Hermit Hacker
Keystone not withstanding (we didn't like it much), can anyone recommend a good tracking system that runs with a PgSQL backend, and, at minimum, would provide the ability for a client to have a login id/pass that they can login to add/comment on/close and view their own tickets, while our help de

Re: [GENERAL] are there plans for a threaded alternative to multipledaemons?

2001-04-28 Thread The Hermit Hacker
On Fri, 27 Apr 2001, Clayton Vernon wrote: > I was wondering what the plans were for PostgreSQL to convert to the > one process multithreaded approach, as Apache, Interbase and others > are doing? there has been talk about doing some threads actions inside of a process, but, if I recall my read

Re: [GENERAL] Re: erServer beta

2001-04-15 Thread The Hermit Hacker
, Robert L Mathews wrote: > At 4/15/01 3:20 PM, The Hermit Hacker <[EMAIL PROTECTED]> wrote: > > >everything that is currently available is actually in contrib right now > >... Thomas is currently working on tools for it, but nothing ready for > >even beta te

Re: [GENERAL] Where do I get the v7.1 beta?

2001-04-05 Thread The Hermit Hacker
ftp.postgresql.org:/pub/dev ... On Thu, 5 Apr 2001, Paul A. Lender wrote: > Hi folks > > If I want to experiment with SSL, it sounds like I need the 7.1 > beta. Where do I get it? > > -- Paul Lender > > Paul A. Lender > University of Minnesota Departme

Re: [GENERAL] News gateway down?

2001-04-03 Thread The Hermit Hacker
the main server had problems with a corrupted index ... somehow, an article goes through that had bad headers ... finally got a fix from the developers late last night, and we're back up and running as of early this morning On Tue, 3 Apr 2001, Alessio Bragadini wrote: > Hi, > usually I tra

Re: [GENERAL] Postgresql.org website search

2001-03-12 Thread The Hermit Hacker
On Fri, 9 Mar 2001, Tim Frank wrote: > I apologise if this has been posted/asked already, but since it has been > about a week and it hasn't been "fixed" I needed to ask. Every time I > issue a search at http://www.postgresql.org/search.mpl even on the > easiest of search items, such as "p

Re: [GENERAL] System V IPC semaphore configuration.

2001-03-05 Thread The Hermit Hacker
On Mon, 5 Mar 2001, Ted Gervais wrote: > I am new to this list and ran into a problem when trying to install the > latest postgresql, version 7.0.3. > Here is what I see when I try and bring postgresql up: > > postgres@ve1drg:~$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data > IpcMemory

Re: [GENERAL] 7.1 stable

2001-03-01 Thread The Hermit Hacker
yOn Thu, 1 Mar 2001, Peter Gubis wrote: > hi all, > > i have some questions about new postgres version: > - how many weeks or month will be 7.1 release in beta testing? 7.1 release should be out by march 15th (+/- a couple of days) > - have 7.1 implemented database replication? and can we use i

[GENERAL] Re: Fwd: Stalled post to pgsql-general

2001-02-15 Thread The Hermit Hacker
than Forte > for Java > > Thanx > Kapil > > P.S. : Where am I reqd. to post my queries related to > Postgres, Java , Interbase... > > > --- The Hermit Hacker <[EMAIL PROTECTED]> wrote: > > > could you resend the original? I tried to read > > throu

Re: [GENERAL] News server not working?

2001-02-14 Thread The Hermit Hacker
had so software instability on the news server the past couple of days, the developers exorcised the demons and all appears to be well right now *cross fingers* On Tue, 13 Feb 2001, PM wrote: > I haven't been able to connect to news.postgresql.org for a few days now. I > can ping the address..

Re: [GENERAL] 7.1 release date?

2001-02-06 Thread The Hermit Hacker
As soon as its ready? :) Seriously, we did a beta4 just before Linuxworld, and should be doing a beta5 relatively shortly as things have starrted to quiet down ... Thomas has his "two weeks grace" for docs, which will most likely start on the 15th of Feb, so we're looking at March 1st for a rele

Re: [GENERAL] postgres limitation

2001-01-26 Thread The Hermit Hacker
On Fri, 26 Jan 2001, a wrote: > Hi, > > Is there any document about the limitation of postgres > like the total size of one table none that we are aware of ... > the max row number of a table 2^32 ... limitation is the OID size, which is currently a 32bit int ... move to 64bit int's, and then

RE: [GENERAL] MySQL has transactions

2001-01-24 Thread The Hermit Hacker
On Wed, 24 Jan 2001, Willis, Ian (Ento, Canberra) wrote: > speed with tranactions on > row level locking > I though that postgresql had more data type no, MySQL has 'type of the week' contests to see how many non-compliant types they can think of, and add them ...

Re: [GENERAL] Why does the JDBC driver not support prepareCall?

2001-01-22 Thread The Hermit Hacker
message resent to [EMAIL PROTECTED] On Fri, 19 Jan 2001, Joel Bernstein wrote: > > I have not tried prepareCall with postgreSQL but it makes sense > that it would not be implemented. > > prepareCall is a JDBC method used to call stored procedures in a database. > > postgreSQL implements stored

Re: [GENERAL] Does PostgreSQL support Dynamic SQL?

2001-01-14 Thread The Hermit Hacker
Stupid question, but what is Dynamic SQL? :) On Sun, 14 Jan 2001, Lark wrote: > Hi all! > 2 questions: > Does PostgreSQL support dynamic SQL, if so, when can i see any documents on > it at PostgreSQL.org? > thank's :) > > > Marc G. Fournier ICQ#7615664 IRC Nick

Re: [GENERAL] mnogosearch -- pgsql seem so slow, please help me findout why

2001-01-14 Thread The Hermit Hacker
On Thu, 11 Jan 2001, Thomas T. Thai wrote: > pgsql 7.1-current, mnogosearch-3.1.8, netbsd/alpha-1.5.1-current, dec > alpha 500, 1G ram, uw-scsi > > i'm trying to find out why postgres is the bottle neck in my searches with > mnogosearch. i've tried both the search.c and php version of search and

Re: [GENERAL] pgsql & mnogosearch

2001-01-08 Thread The Hermit Hacker
mnogosearch only does inserts into the database, it doesn't check for a previous occurance of the record first, so you are getting what is expected ... I think they work under teh guise that better return an error then do two queries ... On Mon, 8 Jan 2001, Thomas T. Thai wrote: > i'm starting

Re: [GENERAL] mysql data to pgsql

2001-01-05 Thread The Hermit Hacker
On Fri, 5 Jan 2001, Thomas T. Thai wrote: > i'm in the process of dumping out my db from mysql and importing them into > pgsql. i would appreciate some suggestions and warnings about > pitfalls. most of my mysql tables have an autoincremment field. check out http://www.pgsql.com -> Download, whe

Re: [GENERAL] replication followup

2001-01-05 Thread The Hermit Hacker
On Fri, 5 Jan 2001, Sandeep Joshi wrote: > How do we get it? > I want to test the product. downloadable as a tar file from http://www.pgsql.com -> Download ... > > Sandeep > > > On Fri, 5 Jan 2001, Justin Banks wrote: > > > > > Hello - > > > As a followup to my mail about replication yest

Re: [GENERAL] replication followup

2001-01-05 Thread The Hermit Hacker
On Fri, 5 Jan 2001, Justin Banks wrote: > Hello - > As a followup to my mail about replication yesterday, I've > realized that I can make replication bi-directional, with each > (non-replicant master initiated) connection to a backend it's own > master with respect to that connection and al

Re: [GENERAL] running pgsql 7 under Jail'ed virtual machine onFreeBSD 4.2

2001-01-04 Thread The Hermit Hacker
read the jail man page: jail.sysvipc_allowed This MIB entry determines whether or not processes within a jail have access to System V IPC primitives. In the current jail imple- mentation, System V primitives share a single namespace across the host a

Re: [GENERAL] How passwords can be crypted in postgres?

2000-12-29 Thread The Hermit Hacker
I usually just run 'crypt()' on the clear text before storing it to the backend ... On Fri, 22 Dec 2000 [EMAIL PROTECTED] wrote: > Hello, > > I order to escape from .htaccess, I want to save user passwords in my > database. > However, passwords appear clear in the database. > How passwords ca

Re: [GENERAL] MySQL to PostgreSQL

2000-12-29 Thread The Hermit Hacker
http://www.pgsql.com/ -> Download On Tue, 26 Dec 2000, Nelio Alves Pereira Filho wrote: > Hi there. > > I am looking for a mysql to postgresql converter but the only I got > didn't work fine (I found this one at freshmeat). > > Does anyone knows a stable converter? > > Thanks > >

[GENERAL] Your RDBMS Survey ...

2000-12-03 Thread The Hermit Hacker
A couple of days ago, one of our brethren noticed and pointed us to your survey asking which RDBMS we prefered/were using ... pride in our choice prompted alot of us to pop over to your site and register our vote ... when I put mine in, the results were at something like 1461 for PgSQL and now th

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread The Hermit Hacker
we could all email them asking why they keep resetting it in favor of MySQL? :) On Sun, 3 Dec 2000, GH wrote: > On Mon, Dec 04, 2000 at 02:19:36PM +1100, some SMTP stream spewed forth: > > On Sun, Dec 03, 2000 at 09:20:51PM -0400, The Hermit Hacker wrote: > > > > &g

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread The Hermit Hacker
just re-submit'd my vote ... maybe mycgiserver already has mysql installed and is only doing the vote to satisfy some ppl, but don't really want to install PgSQL? *raised eyebrow* On Sun, 3 Dec 2000, GH wrote: > On Sun, Dec 03, 2000 at 04:14:48PM -0600, some SMTP stream spewed forth: > > looks

Re: [GENERAL] Can PostGreSQL handle 100 user database?

2000-11-30 Thread The Hermit Hacker
Note that this is a Linux limitation ... and even then, I'm not quite sure how accurate that is anymore ... the *BSDs have supported >2gb file systems for ages now, and, since IBM supports Linux, I'd be shocked if there was a 2GB limit on memory, considering alot of IBMs servers support up to 4 o

[GENERAL] Search engine on http://www.postgresql.org ...

2000-11-23 Thread The Hermit Hacker
After cursing over this for I don't know how long, its was recently brought to my attention that the C search.cgi that comes with UDMsearch just might not be up to snuff, compared to some of the other interfaces ... After some investigation, we've installed a mod_perl front-end to the database t

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-16 Thread The Hermit Hacker
On Wed, 15 Nov 2000, Charles Tassell wrote: > Just a note, I've been using Postgres 7.02 and PHP 4.02 or 4.03 for about a > month in a couple sites, and haven't experienced any problems with > persistent connections. Problem might have been fixed in one of the point > releases, or maybe I jus

[GENERAL] pgsql-general should be live again ...

2000-10-29 Thread The Hermit Hacker
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

[GENERAL] making sure ...

2000-10-29 Thread The Hermit Hacker
... this one works as expected too ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

[GENERAL] READ THIS: changes in mailing list ...

2000-10-29 Thread The Hermit Hacker
Morning all ... Today, we are moving the mailing lists over to the new mail server. There *might* be a brief period where any mail sent to the lists will be returned with a 'user unknown' error, as there will be a brief period where the aliases will be disabled on the old server and the

Re: [GENERAL] 7.1 release date ?

2000-10-27 Thread The Hermit Hacker
On Fri, 27 Oct 2000, Dmitriy Agafonov wrote: > What's the release date for 7.1 ? January 1st, or there abouts ... > Is it going to have support for the outer joins ? yes > Are there going to be any performance improvements made (I'm > particularly interested in data selection speed) ? of cou

Re: [GENERAL] three things

2000-10-24 Thread The Hermit Hacker
what was the third thing? *raised eyebrow* On Tue, 24 Oct 2000, Vince Vielhaber wrote: > On Tue, 24 Oct 2000, Robert Kernell wrote: > > > Hi. > > > > 1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s > > book)? > > http://www.postgresql.org/users-lounge > > >

RE: [GENERAL] Matlab Mex Interface

2000-10-13 Thread The Hermit Hacker
limit its ability to be included, only licensing :) > > Darrin Rothe > [EMAIL PROTECTED] > > > > -Original Message- > > From: The Hermit Hacker [mailto:[EMAIL PROTECTED]] > > Sent: Friday, October 13, 2000 8:58 PM > > To: Darrin Rothe > > Cc: [EMA

Re: [GENERAL] Matlab Mex Interface

2000-10-13 Thread The Hermit Hacker
On Fri, 13 Oct 2000, Darrin Rothe wrote: > We have recently developed an interface to PostgreSQL for Matlab. > > The interface is implemented as 'C' mex wrappers around libpq. Most of the > database connection and query execution functions are implemented, and it > supports default (text) and b

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-13 Thread The Hermit Hacker
On Sat, 14 Oct 2000, Philip Warner wrote: > The fear is that this may distort other priorities - hence why > increased transparency in decision making is important. If Bruce, Tom > & Jan make a design decision, then chances are it's going to be pretty > good. The problem is it will/may be seen as

Re: [GENERAL] ODMG

2000-10-12 Thread The Hermit Hacker
On Thu, 12 Oct 2000, Aristide Aragon wrote: > I was wondering... > Are there any plans to include ODMG support for psotgresql? ... > Or does anybody know of an open source ODMG DBMS? > It'd be cool if besides being object-relational, postgresql were > object oriented too! >From my understanding,

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread The Hermit Hacker
On Thu, 12 Oct 2000, Adam Lang wrote: > May bad... sometimes it is too easy assuming everything open source is GPL. what a narrow view on open source ... most core internet open source software is *not* GPL ... sendmail, INN, bind, isc-dhcp, apache, X11Rn, etc ... > > Adam Lang > Systems Engi

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread The Hermit Hacker
On Wed, 11 Oct 2000, Tim Uckun wrote: > At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote: > >On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote: > > > What;s the new in Postgresql 7.1 ? > > > >TOAST and WAL > > > >I think these are big changes that will make me think about postgresql as a > >

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread The Hermit Hacker
On Wed, 11 Oct 2000, Martin A. Marques wrote: > How far are we from seeing the version 7.1 out? beta starts ~Nov 1st, release in January ...

RE: [GENERAL] Some advanced database features, are they present inPostgreSQL

2000-10-10 Thread The Hermit Hacker
right now, we are working with our partners internally on this, before we release it publicly, but more information can be found at: http://www.erserver.com/ On Tue, 10 Oct 2000, Rob Hutton wrote: > I'm looking for info about the synching and I don't see any. Is there a > more

Re: [GENERAL] snapshot: dot or dash?

2000-10-09 Thread The Hermit Hacker
looking at it now, it appears that the build tree had something stuck in it that it was trying to use byacc vs bison, which was screwing up the build ... doing it manual right now, after cleaning out some cache files, and all looks good so far ... On Sun, 8 Oct 2000, Frank Joerdens wrote: > e

Re: Re[6]: [GENERAL] WTF is going on with PG_VERSION?

2000-09-21 Thread The Hermit Hacker
On Thu, 21 Sep 2000, Alexey Borzov wrote: > Greetings, Tom! > > At 20.09.2000, 10:41, you wrote: > > TL> "Alexey V. Borzov" <[EMAIL PROTECTED]> writes: > >> Nope, that's not the problem. I just checked and every DB has its own > >> PG_VERSION. Besides, _all_ of the databases are accessed on reg

[GENERAL] RE: [PHP-DB] Interbase or MySQL ??? (fwd)

2000-09-19 Thread The Hermit Hacker
Actually, MySQL itself does not support transactions, and, from what I can tell, it never will. Berkeley DB, though, does support transactions ... what MySQL has done is provided an SQL interface over top of Berkeley DB files to give the *appearance* of transactions ... Basically, MySQL remains

Re: [GENERAL] WTF is going on with PG_VERSION?

2000-09-18 Thread The Hermit Hacker
On Mon, 18 Sep 2000, Alexey V. Borzov wrote: > Greetings. > > The problem is: from time to time, PostgreSQL seems to crash. > Inspection of the logs revealed the following: > > óÅÎ 18 15:53:06 arbat logger: FATAL 1: File '/var/lib/pgsql/PG_VERSION' does not >exist or no read permission. > >

Re: [GENERAL] That killer 3rd join...

2000-09-07 Thread The Hermit Hacker
On Thu, 7 Sep 2000, Oliver Smith wrote: > CREATE VIEW silver AS > SELECT * FROM jcombo_query WHERE metal_uid = 1 ; > > CREATE VIEW elec AS > ... > > However, when I did that, postgres went away. I'll give your idea a try, > it looks quite promising. Ya, looked at that ... you were doing a VI

Re: [GENERAL] Unexpected crashes

2000-09-06 Thread The Hermit Hacker
I've used PostgreSQL for pretty much any project I've required an RDBMS in for the past 4+ years now ... VIEWs haven't figured very prominently in that, but I can't really say that I've noticed any major problems with unexpected crashes in the past 2 years or so ... In the below, the user was do

Re: [GENERAL] That killer 3rd join...

2000-09-06 Thread The Hermit Hacker
Just played with this a little bit, and I'm not 100% certain whether I'm getting the "desired results", but why not do something like: SELECT stone_name, st.stone_uid, stone_modifies, stone_difficulty, stone_cost, silver.jtyp_name AS silver_name, (silver.metal_cost + stone_cost) AS Expr1,

Re: [GENERAL] 7.1 Release Date

2000-08-29 Thread The Hermit Hacker
On 29 Aug 2000, Trond Eivind [iso-8859-1] Glomsrød wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > > On 29 Aug 2000, Trond Eivind [iso-8859-1] Glomsr d wrote: > > > > > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > > > > &

Re: [GENERAL] 7.1 Release Date

2000-08-29 Thread The Hermit Hacker
On 29 Aug 2000, Trond Eivind [iso-8859-1] Glomsrød wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > > On 29 Aug 2000, Trond Eivind [iso-8859-1] Glomsr d wrote: > > > > > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > > > &g

Re: [GENERAL] 7.1 Release Date

2000-08-29 Thread The Hermit Hacker
On 29 Aug 2000, Trond Eivind [iso-8859-1] Glomsrød wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > > On Mon, 28 Aug 2000, Miguel Omar Carvajal wrote: > > > > > Hi there, > > >When will Postgresql 7.1 be released? > > > >

Re: [GENERAL] cannot vacuum a database !

2000-08-29 Thread The Hermit Hacker
try 'vacuum verbose;' ... if that doesn't work, try doing a pg_dump/reload ... and, above all ... upgrade to v7.x as soon as possible ... On Tue, 29 Aug 2000, Ange Michel POZZO wrote: > hi all, > > i use [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] on a > linux mandrake 7.0

Re: [GENERAL] 7.1 Release Date

2000-08-28 Thread The Hermit Hacker
On Mon, 28 Aug 2000, Miguel Omar Carvajal wrote: > Hi there, >When will Postgresql 7.1 be released? right now, we're looking at October-ish for going beta, so most likely November-ish for a release ...

Re: [GENERAL] split up tables or one big one?

2000-08-26 Thread The Hermit Hacker
it all depends on what the data is and how you are going to use it ... if its going to result in this major JOIN to get results, or several queries, you are best with teh multi-GB table ... On Sat, 26 Aug 2000, Patrick Goodwill wrote: > Hi! > > I'm writing a system which i could logically se

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

2000-08-14 Thread The Hermit Hacker
On Mon, 14 Aug 2000, Steve Wolfe wrote: > > 1) Using only ODBC drivers. I don't know how much of an impact a driver > can > > make but it would seem that using native drivers would shutdown one source > > of objections. > > Using ODBC is guaranteed to slow down the benchmark. I've seen nativ

Re: [GENERAL] DBD-Pg vs Pg Perl interface

2000-07-24 Thread The Hermit Hacker
On Mon, 24 Jul 2000, Steve Heaven wrote: > > We currently use the Pg Perl module to interface our CGI scripts to Postgres. > What would be the advantages/disadvantages to changing to the more generic > DBI/DBD-Pg style interface? I find the DBI/DBD-Pg interface to be *much* cleaner to work in .

Re: [GENERAL] Notice of List Changes ...

2000-07-22 Thread The Hermit Hacker
quick note: 'this list' refers to the pgsql-questions list that was split over a year ago ... :) On 22 Jul 2000, Marc G. Fournier wrote: > Few of us ever watch the newsgroups, and I fear that an > announcement might never have reached them ... > > This list is pretty much dead, having been s

Re: [GENERAL] Sorry...

2000-07-12 Thread The Hermit Hacker
fixed On Wed, 12 Jul 2000, root wrote: > Ooops sorry. > Now all options on this machine are now set properly. > > My email address is NOT [EMAIL PROTECTED] . It is [EMAIL PROTECTED] > - > > Andreas Maus. > -- > @-@ > | email: [EMAIL PROTE

Re: [GENERAL] Slashdot discussion

2000-07-11 Thread The Hermit Hacker
On Tue, 11 Jul 2000, Jeff Waugh wrote: > > J.R. Belding wrote: > > > > #mysql has much more activity than does #postgresql, and since I prefer > > this method of communication over mailing-lists, I found this to be very > > much in MySQL's favor. > > > Hmm. So which server do most postgresql p

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread The Hermit Hacker
On Mon, 10 Jul 2000, Robert D. Nelson wrote: > >no they can't ... they can add to the current license, but they can't > >remove it ... > > Okay, well that is what's wanted, correct? Or am I reading the mail wrong? I've contacted the University of California "licensing director" about upgrading

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread The Hermit Hacker
On Mon, 10 Jul 2000, Robert D. Nelson wrote: > >I'll ask, but I think he'll say that the license applies to the source; if > >a commercial fork was made, then they are free to hide the source. But if > >they ever release the source, then it has to go under the BSD again. > > What I was asking wa

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread The Hermit Hacker
On Mon, 10 Jul 2000, Philip Warner wrote: > At 08:24 10/07/00 -0400, Robert D. Nelson wrote: > > > >Stupid question time: BSD allows forking of the code base, perhaps to > >proprietary. If going proprietary, I would imagine you could change the > >license. So why can't we have a "license fork"?

Re: [GENERAL] proposed improvements to PostgreSQL license

2000-07-06 Thread The Hermit Hacker
On Thu, 6 Jul 2000, Ron Peterson wrote: > By the way, I hope I'm not coming across as saying "thanks for all > your hard work, now go eat peanuts." I have great appreciation for > what PostgreSQL has become, and for the developers who have made it > so. That is why I keep at this tired argument

Re: [GENERAL] proposed improvements to PostgreSQL license

2000-07-06 Thread The Hermit Hacker
On Thu, 6 Jul 2000, Ron Peterson wrote: > This has happened in PostgreSQL's own history. How long did it take > for the project to get picked up again? How long did it take for the > people who picked it up to familiarize themselves with the code? How > long did it take before the community at

Re: [HACKERS] Re: [GENERAL] Revised Copyright: is this more palatable?

2000-07-06 Thread The Hermit Hacker
On Thu, 6 Jul 2000, Richard Poole wrote: > On Wed, Jul 05, 2000 at 11:13:45PM -0300, The Hermit Hacker wrote: > > On Wed, 5 Jul 2000, Jim Wise wrote: > > > > > I'd like to point out a couple things that are _not_ wrong with the > > > current license: >

Re: [GENERAL] PostgreSQL & the BSD License

2000-07-06 Thread The Hermit Hacker
On Thu, 6 Jul 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > On Thu, 6 Jul 2000, Tom Lane wrote: > >> The Hermit Hacker <[EMAIL PROTECTED]> writes: > >>>> I would like to plug this in early next week, unless someone can se

  1   2   3   >