Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 77B999FB720; Mon, 18 Jun 2007 12:03:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 82379-03; Mon, 18 Jun 2007 12:03:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sab-fillmore.sab.uiuc.edu (swan16.admin.uiuc.edu [128.174.254.16]) by postgresql.org (Postfix) with ESMTP id 343529FB4EF; Mon, 18 Jun 2007 12:03:15 -0300 (ADT) Received: from SAB-DC1.sab.uiuc.edu ([128.174.254.32]) by sab-fillmore.sab.uiuc.edu with Microsoft SMTPSVC(6.0.3790.3959); Mon, 18 Jun 2007 10:04:17 -0500 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7B1B9.EFC34E2E" X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Volunteer to build a configuration tool Date: Mon, 18 Jun 2007 10:04:15 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Volunteer to build a configuration tool thread-index: AcexuckOGFkWo0WmTXCTGl9gKqWNRw== From: "Campbell, Lance" To: , X-OriginalArrivalTime: 18 Jun 2007 15:04:17.0534 (UTC) FILETIME=[F118A9E0:01C7B1B9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL=0.023, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200706/11 X-Sequence-Number: 4300 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7B1B9.EFC34E2E Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am a Java Software architect, DBA, and project manager for the University of Illinois, Department of Web Services. We use PostgreSQL to serve about 2 million pages of dynamic content a month; everything from calendars, surveys, forms, discussion boards, RSS feeds, etc. I am really impressed with this tool. =20 The only major problem area I have found where PostgreSQL is really lacking is in "what should my initial configuration settings be?" I realize that there are many elements that can impact a DBA's specific database settings but it would be nice to have a "configuration tool" that would get someone up and running better in the beginning. =20 =20 This is my idea: =20 A JavaScript HTML page that would have some basic questions at the top: 1) How much memory do you have? 2) How many connections will be made to the database? 3) What operating system do you use? 4) Etc... =20 Next the person would press a button, "generate", found below the questions. The JavaScript HTML page would then generate content for two Iframes at the bottom on the page. One Iframe would contain the contents of the postgresql.conf file. The postgresql.conf settings would be tailored more to the individuals needs than the standard default file. The second Iframe would contain the default settings one should consider using with their operating system. =20 My web team would be very happy to develop this for the PostgreSQL project. It would have saved us a lot of time by having a configuration tool in the beginning. I am willing to make this a very high priority for my team. =20 Thanks, =20 Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu =20 ------_=_NextPart_001_01C7B1B9.EFC34E2E Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am a Java Software architect, DBA, and project = manager for the University of Illinois, = Department of Web Services.  We use PostgreSQL to serve about 2 million pages of = dynamic content a month; everything from calendars, surveys, forms, discussion = boards, RSS feeds, etc.  I am really impressed with this = tool.

 

The only major problem area I have found where = PostgreSQL is really lacking is in “what should my initial configuration = settings be?”  I realize that there are many elements that can impact a DBA’s = specific database settings but it would be nice to have a “configuration = tool” that would get someone up and running better in the beginning.  =

 

This is my idea:

 

A JavaScript HTML page that would have some basic = questions at the top:

1) How much memory do you = have?

2) How many connections will be made to the = database?

3) What operating system do you = use?

4) Etc…

 

Next the person would press a button, = “generate”, found below the questions.  The JavaScript HTML page would then = generate content for two Iframes at the bottom on the page.  One Iframe = would contain the contents of the postgresql.conf file.  The = postgresql.conf settings would be tailored more to the individuals needs than the = standard default file.  The second Iframe would contain the default settings = one should consider using with their operating = system.

 

My web team would be very happy to develop this for = the PostgreSQL project.   It would have saved us a lot of time by = having a configuration tool in the beginning.  I am willing to make this a = very high priority for my team.

 

Thanks,

 

Lance Campbell

Project Manager/Software = Architect

Web Services at Public = Affairs

University of Illinois=

217.333.0382

http://webservices.uiuc.edu

 

------_=_NextPart_001_01C7B1B9.EFC34E2E--