From owner-freebsd-database Thu Apr 12 0:39: 9 2001 Delivered-To: freebsd-database@freebsd.org Received: from speedbuggy.telerama.com (speedbuggy.telerama.com [205.201.1.216]) by hub.freebsd.org (Postfix) with SMTP id 6201937B507 for ; Thu, 12 Apr 2001 00:39:03 -0700 (PDT) (envelope-from rhodespc@telerama.com) Received: (qmail 529 invoked from network); 12 Apr 2001 07:39:02 -0000 Received: from rhodespc.dsl.telerama.com (HELO home1.telerama.com) (205.201.10.60) by speedbuggy.telerama.com with SMTP; 12 Apr 2001 07:39:02 -0000 Message-Id: <5.0.2.1.0.20010412033249.00a8b490@dns1.rhoderunner.com> X-Sender: rhodespc@mail.telerama.com X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Thu, 12 Apr 2001 03:34:12 -0400 To: freebsd-database@FreeBSD.ORG From: Phillip Rhodes Subject: help - can't build mysql Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I am on 3.4-RELEASE FreeBSD 3.4-RELEASE If I try to build mysql , I get the following: hostname.o: In function `ip_to_hostname(in_addr *, unsigned int *)': hostname.o(.text+0x52b): undefined reference to `my_gethostbyname_r' *** Error code 1 Stop. *** Error code 1 Thanks. Been trying a long time;( To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Apr 12 0:50:20 2001 Delivered-To: freebsd-database@freebsd.org Received: from maila.telia.com (maila.telia.com [194.22.194.231]) by hub.freebsd.org (Postfix) with ESMTP id 25A7237B506 for ; Thu, 12 Apr 2001 00:50:09 -0700 (PDT) (envelope-from martin@svenskabutiker.se) Received: from svenskabutiker.se (t4o79p77.telia.com [62.20.201.197]) by maila.telia.com (8.9.3/8.9.3) with ESMTP id JAA13430; Thu, 12 Apr 2001 09:50:05 +0200 (CEST) Message-ID: <3AD55E4C.F91693E8@svenskabutiker.se> Date: Thu, 12 Apr 2001 09:50:36 +0200 From: Martin Nilsson X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Phillip Rhodes Cc: freebsd-database@FreeBSD.ORG Subject: Re: help - can't build mysql References: <5.0.2.1.0.20010412033249.00a8b490@dns1.rhoderunner.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Phillip Rhodes wrote: > > I am on 3.4-RELEASE FreeBSD 3.4-RELEASE > > If I try to build mysql , I get the following: > hostname.o: In function `ip_to_hostname(in_addr *, unsigned int *)': > hostname.o(.text+0x52b): undefined reference to `my_gethostbyname_r' > *** Error code 1 > > Stop. > *** Error code 1 > > Thanks. Been trying a long time;( > Mee too... The port for mysql-3.23 doesn't work on 3.x anymore you have to build manually or upgrade to FreeBSD 4.3 I recomend upgrading FreeBSD instead of wasting time with this. There are a lot of security holes in 3.4 that have been fixed in 4.3 New ports is no longer supported on the 3.x branch so upgrading your applications will need more and more work. I'm about to upgrade my last 3.5 boxen to 4.3 anyday now. /Martin --- Martin Nilsson, Civilingenjör M.Sc. CS&E Svenska Butiker AB, S:t Larsväg 44, 222 70 Lund Sweden martin@svenskabutiker.se Tel: 046-304130 www.svenskabutiker.se To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Apr 12 7:30:14 2001 Delivered-To: freebsd-database@freebsd.org Received: from ww2.bravekids.org (bravekids.org [64.84.20.116]) by hub.freebsd.org (Postfix) with ESMTP id ED0B137B423 for ; Thu, 12 Apr 2001 07:30:12 -0700 (PDT) (envelope-from phil@glatz.com) Received: from PHILG.glatz.com (dnai-216-15-98-38.cust.dnai.com [216.15.98.38]) by ww2.bravekids.org (8.11.0/8.11.0) with ESMTP id f3CESeT14700 for ; Thu, 12 Apr 2001 07:28:41 -0700 Message-Id: <5.1.0.12.2.20010412072200.031d8038@flawless.net> X-Sender: phil@flawless.net X-Mailer: QUALCOMM Windows Eudora Version 5.1.0.12 (Beta) Date: Thu, 12 Apr 2001 07:24:32 -0700 To: freebsd-database@FreeBSD.ORG From: Phil Glatz Subject: Re: help - can't build mysql In-Reply-To: <3AD55E4C.F91693E8@svenskabutiker.se> References: <5.0.2.1.0.20010412033249.00a8b490@dns1.rhoderunner.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG >I recomend upgrading FreeBSD instead of wasting time with this. Better yet, consider postgres --- I finally got the religion, and realize what an improvement it is. In addition to be much closer to Oracle and "true" SQL, you'll find it outperforms mysql in many ways. I've done many projects over the years with mysql and still find it appropriate for some, but it's worse problem is that it just doesn't scale well. This can be death for a popular web site. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Apr 12 12: 6:28 2001 Delivered-To: freebsd-database@freebsd.org Received: from fmdb.c3.hu (dial-038.digitel2002.hu [213.163.2.38]) by hub.freebsd.org (Postfix) with SMTP id 01B9137B423 for ; Thu, 12 Apr 2001 12:06:19 -0700 (PDT) (envelope-from mico@bsd.hu) Received: (qmail 4053 invoked by uid 1003); 12 Apr 2001 16:36:35 -0000 Date: Thu, 12 Apr 2001 18:36:35 +0200 From: Miklos Niedermayer To: Phil Glatz Cc: freebsd-database@freebsd.org Subject: Re: help - can't build mysql Message-ID: <20010412183635.B3938@fmdb.c3.hu> References: <5.0.2.1.0.20010412033249.00a8b490@dns1.rhoderunner.com> <3AD55E4C.F91693E8@svenskabutiker.se> <5.1.0.12.2.20010412072200.031d8038@flawless.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <5.1.0.12.2.20010412072200.031d8038@flawless.net>; from phil@glatz.com on Thu, Apr 12, 2001 at 07:24:32AM -0700 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi Phil! On Thu, Apr 12, 2001 at 07:24:32AM -0700, Phil Glatz wrote: > >I recomend upgrading FreeBSD instead of wasting time with this. > > Better yet, consider postgres --- I finally got the religion, and realize > what an improvement it is. In addition to be much closer to Oracle and > "true" SQL, To be much closer to "true" SQL? AFAIK it lacks many types and functions from ANSI SQL (MySQL lacks some too, but they aren't so important for 90% of people). > you'll find it outperforms mysql in many ways. I've done many > projects over the years with mysql and still find it appropriate for some, > but it's worse problem is that it just doesn't scale well. This can be > death for a popular web site. PostgreSQL *is* much slower than MySQL. I can't understand how it can outperform MySQL. Some people say that it handles concurrent queries better, but: a) tune your mysqld b) tune your queries c) tune your indices d) if you have *really* lots of queries, replicate across multiple servers and you'll be there. (I have several friends who do have problems with the performance of PostgreSQL anyway.) PostgreSQL only has transaction-safe tables, while with MySQL, you can choose from different table types. It's true that PostgreSQL has some features that MySQL doesn't, but the opposite is also true. And i think those features of MySQL are better for most people than Postgres'. http://www.mysql.com/information/crash-me.php Have a nice day Miklos To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Apr 13 22:31:22 2001 Delivered-To: freebsd-database@freebsd.org Received: from mobile.hub.org (SHW39-29.accesscable.net [24.138.39.29]) by hub.freebsd.org (Postfix) with ESMTP id 3488137B424; Fri, 13 Apr 2001 22:31:14 -0700 (PDT) (envelope-from scrappy@postgresql.org) Received: from localhost (scrappy@localhost) by mobile.hub.org (8.11.1/8.11.1) with ESMTP id f3E5UtP68788; Sat, 14 Apr 2001 02:30:55 -0300 (ADT) (envelope-from scrappy@postgresql.org) X-Authentication-Warning: mobile.hub.org: scrappy owned process doing -bs Date: Sat, 14 Apr 2001 02:30:55 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: To: Subject: FOR IMMEDIATE RELEASE: PostgreSQL v7.1 Release Announcement Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Date: Saturday, April 14, 2001 Subject: PostgreSQL v7.1 Release Announcement The PostgreSQL Global Development Group is pleased to announce the release of PostgreSQL v7.1, now available for download from http://www.postgresql.org and our mirror sites. After a long and arduous development cycle, v7.1 adds several improvements to the award winning [Linux World 1999, Linux Journal 2000] PostgreSQL open source Object-based Relational Database application. As with all past releases, PostgreSQL v7.1 is the result of collaberative and cooperative efforts of a worldwide network of independent developers and companies committed to advancing PostgreSQL as the best open source database solution. The Global Development Group wants to thank the hundreds of individual contributors who have added, tested, and improved PostgreSQL throughout the development lifecycle of this release. Key New Features and Capabilities of Version 7.1 Include: Write-ahead Log (WAL) increases data integrity and processing speed. To maintain database consistency in case of an operating system crash, previous releases of PostgreSQL have forced all all data modifications to disk before each transaction commit. With WAL, only one log file must be flushed to disk, greatly improving performance. (Tech note: can eliminate use of -F in to disable disk flushes) TOAST (The Oversized-Attribute Storage Technique) Past releases had compiled-in row length limit typically between 8Kb & 32Kb. This restriction made storage of long text fields difficult, cumbersome and slow. TOAST enables rows of any length while maintaing the high performance PostgreSQL users have come to expect. SQL92 Outer Joins are now supported. (Tech note: eliminates the UNION/NOT IN workaround) 64-bit C Language Function Manager support The previous C function manager did not handle support 64-bit CPU's (e.g. Alpha, Sun, Itanium). (Tech note: This change should not impact existing custom functions developed for past versions, but performance will be improved through rewriting to use the new call interface.) Complex Queries that are better, stronger and faster Many complex queries were unsupported in previous releases. With v7.1 combinations of views, aggregates, UNION, LIMIT, cursors, subqueries, and inherited tables are enabled. Inherited tables are now accessed by default, and subqueries in FROM are now supported. Marc G. Fournier for the PostgreSQL Global Development Group ================= For a more complete list of New Features and Bugs Fixed, please refer to the HISTORY segment available at: ftp://ftp.postgresql.org/pub/README.v7_1 Source code is available at ftp://ftp.postgresql.org/pub/v7.1 For more information please contact: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message