Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 72BC564FD36 for ; Thu, 25 Dec 2008 04:57:57 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24421-04 for ; Thu, 25 Dec 2008 04:57:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f19.google.com (mail-bw0-f19.google.com [209.85.218.19]) by mail.postgresql.org (Postfix) with ESMTP id AA12264FD22 for ; Thu, 25 Dec 2008 04:57:53 -0400 (AST) Received: by bwz12 with SMTP id 12so9397125bwz.19 for ; Thu, 25 Dec 2008 00:57:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=xCtZB2xJBRHDNlmM2pg/NDYE+Krx3Qwtd3DFl2hThKo=; b=hMBR4K/ZaRYQggYC7a8D2DxNUeDe67PXowgk4HwEHFUQA3pFSwFiAggYSy8uP1p7fJ PfrW0zGk7DPQlCTaGnM5zfHuxicBMuZa7OyQfVK3J+LHPz7pHDoQ+aqSpX6zrZhSs4OF 4fwKc5wEIMDGwZ1PnZtQcqQ/n81vYiTbdIT0U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=l+0Sw2vivHU7LpaurgjD0XiU9QxDTw0iwJRjKa5NhrX0TkvcEMiRLrtv2YVbvoTCBZ sJlZzBJ9BG5McIJJ0pwECPdCHCHQ+dBxCGZzQ2jDfXYkT1kFHg4beUJD9Z8Xezg2d8JX fQffCH3mX4Gmvhl8jkPnz75JGWRkZVFaF1fJ8= Received: by 10.223.106.71 with SMTP id w7mr7526092fao.22.1230195471745; Thu, 25 Dec 2008 00:57:51 -0800 (PST) Received: by 10.223.113.134 with HTTP; Thu, 25 Dec 2008 00:57:51 -0800 (PST) Message-ID: Date: Thu, 25 Dec 2008 10:57:51 +0200 From: "Nikolay Samokhvalov" To: PostgreSQL-documentation Subject: Current docs are too comlicated for new Postgre users; thoughts on improvement MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/28 X-Sequence-Number: 5035 Currently, Part III (Server Administration) starts with three chapters: 15. Installation Instructions 16. Installation on Windows 17. Operating System Environment Here in Russia we have a situation, when the number of Win32 users of Postgres is constantly increasing, so more and more questions like "I've tried to install Postgres, clicked next/next/ok/ok/finish in installation wizard, but it doesn't work / service cannot start / I cannot connect" appear. The problem is that we cannot just say "RTFM" them, because it's really hard to find (and in some cases even impossible) to find the proper part of docs. Why? The chapters 15 and 16 of the main docs are not about installation -- they are about building Postgres from sources. Currently, even for *nix DBA installation most frequently means really installation from RPM/.deb/bsd ports/etc, including creation of system user and running initdb. As for Windows users, I haven't meet at least one who needs to know how to build Postgres from sources under Windows! And really often I see that Windows users cannot continue after some silly errors with initdb process. Docs cannot help them -- they open Chapter 16, got stuck and go away. And only really experienced DBAs know, that initdb (one of the most important processes for newbies) is described in "17.2. Creating a Database Cluster", which is located under "17. Operating System Environment" in the main contents listing. I think that docs really need to be clarified, at least titles should be corrected. I'd rename chapter 15 to smth like 'Building from source code on *nix platforms", and 16th one to 'Building from source code on Windows' and chapter 17 (most important) to 'Creation and Initial configuration of database cluster' (maybe with some corrections of contents). Going further, I'd remove detailed building instructions from the beginning of Server Administration part (either to separate but single chapter or even to appendix) and describe in details how to install Postgres in different ways on different platforms, including: - installation from RPM/deb/other packages; - special attention to Windows users (how to install? what are common problems?) /* btw, I won't wonder if win32 version of Postgres is being downloaded more often than others */ - short version of installation from sources; - initdb process; - initial configuration on different platforms. I believe that this question is one of the most important when we are thinking how to grow user base. Thoughts? -- Sincerely yours, Nikolay Samokhvalov Postgresmen LLC, http://postgresmen.ru