Re: [PATCHES] FAQ refresh

2006-12-06 Thread Bruce Momjian
Tom Lane wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > Refresh of the Port FAQ pages, as discussed.
> 
> Please do not duplicate information from the installation.sgml
> "supported platforms" list into the FAQs.  It's hard enough
> to maintain that info in one place.
> 

Supported platforms removed.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/FAQ_AIX
===
RCS file: /cvsroot/pgsql/doc/FAQ_AIX,v
retrieving revision 1.20
diff -c -c -r1.20 FAQ_AIX
*** doc/FAQ_AIX	5 Dec 2006 14:47:33 -	1.20
--- doc/FAQ_AIX	6 Dec 2006 15:44:36 -
***
*** 7,13 
  
  Topics
  
- - Known Working Ports
  - AIX 4.3.2 Port Report
  - AIX 5.3 Additional Information
  - AIX, readline, and postgres 8.1.x:
--- 7,12 
***
*** 16,35 
  
  -
  
- Working Ports
- -
- Consult http://buildfarm.postgresql.org/ for latest information.
- 
- At time of writing the following builds work on 8.0, 8.1 and 8.2
- 
- AIX 5.3 using gcc 4.0.1 on PowerPC
- AIX 5.2 using gcc 3.3.2 on PowerPC
- AIX 5.2 using cc 6.0 on PowerPC
- 
- plus port report below for AIX 4.3.2
- 
- -
- 
  From: Zeugswetter Andreas <[EMAIL PROTECTED]>
  $Date: 2006/12/05 14:47:33 $
  
--- 15,20 
Index: doc/FAQ_HPUX
===
RCS file: /cvsroot/pgsql/doc/FAQ_HPUX,v
retrieving revision 1.15
diff -c -c -r1.15 FAQ_HPUX
*** doc/FAQ_HPUX	5 Dec 2006 14:47:34 -	1.15
--- doc/FAQ_HPUX	6 Dec 2006 15:44:36 -
***
*** 26,36 
  tools.  At least one developer routinely tests on HPUX 10.20 and we
  have reports of successful installations on HPUX 11.00 and 11.11.
  
- Recent port reports for PostgreSQL 8.2.0 are
-   - on IA64,HP-UX 11.23,   gcc and cc
-   - on PA-RISC, HP-UX 10.20 and 11.23, gcc and cc
- Tested on 2006-10-23
- 
  Aside from the PostgreSQL source distribution, you will need GNU make
  (HP's make will not do), and either GNU gcc or HP's full ANSI C compiler.
  If you intend to build from CVS sources rather than a distribution tarball,
--- 26,31 
Index: doc/FAQ_IRIX
===
RCS file: /cvsroot/pgsql/doc/FAQ_IRIX,v
retrieving revision 1.4
diff -c -c -r1.4 FAQ_IRIX
*** doc/FAQ_IRIX	5 Dec 2006 14:47:34 -	1.4
--- doc/FAQ_IRIX	6 Dec 2006 15:44:36 -
***
*** 25,33 
  and r12000(ip35) processors, running IRIX 6.5.5m, 6.5.12 and 6.5.13 with
  MIPSPro compilers version 7.30, 7.3.1.2m and 7.3. 
  
- PostgreSQL 8.1.0 has been reported as compiling successfully on IRIX 6.5
- on MIPS using cc by Kenneth Marshall (<[EMAIL PROTECTED]>), 2005-11-04
- 
  Aside from the PostgreSQL source distribution, you will need GNU make
  (SGI's make will not do), and the MIPSPro full ANSI C compiler.
  
--- 25,30 

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [PATCHES] FAQ refresh

2006-12-05 Thread Tom Lane
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> Refresh of the Port FAQ pages, as discussed.

Please do not duplicate information from the installation.sgml
"supported platforms" list into the FAQs.  It's hard enough
to maintain that info in one place.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [PATCHES] FAQ refresh

2006-12-05 Thread Bruce Momjian
Simon Riggs wrote:
> On Tue, 2006-12-05 at 09:47 -0500, Bruce Momjian wrote:
> > Patch applied, HEAD only.  Thanks.
> 
> What about the web site?

I believe the web site pulls from CVS HEAD, so the web contents should
update shortly.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [PATCHES] FAQ refresh

2006-12-05 Thread Simon Riggs
On Tue, 2006-12-05 at 09:47 -0500, Bruce Momjian wrote:
> Patch applied, HEAD only.  Thanks.

What about the web site?

-- 
  Simon Riggs 
  EnterpriseDB   http://www.enterprisedb.com



---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [PATCHES] FAQ refresh

2006-12-05 Thread Bruce Momjian

Patch applied, HEAD only.  Thanks.

---

Simon Riggs wrote:
> Refresh of the Port FAQ pages, as discussed.
> 
> -- 
>   Simon Riggs 
>   EnterpriseDB   http://www.enterprisedb.com
> 

[ Attachment, skipping... ]

> 
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
> 
>http://www.postgresql.org/docs/faq

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 6: explain analyze is your friend


[PATCHES] FAQ refresh

2006-12-05 Thread Simon Riggs
Refresh of the Port FAQ pages, as discussed.

-- 
  Simon Riggs 
  EnterpriseDB   http://www.enterprisedb.com

Index: doc/FAQ_AIX
===
RCS file: /projects/cvsroot/pgsql/doc/FAQ_AIX,v
retrieving revision 1.19
diff -c -r1.19 FAQ_AIX
*** doc/FAQ_AIX	20 Sep 2006 02:10:11 -	1.19
--- doc/FAQ_AIX	5 Dec 2006 12:57:59 -
***
*** 1,3 
--- 1,35 
+ ===
+ Frequently Asked Questions (FAQ) for PostgreSQL
+ AIX Specific
+ TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
+ ===
+ Last updated:$Date: 2006/12/05 12:46:00 $
+ 
+ Topics
+ 
+ - Known Working Ports
+ - AIX 4.3.2 Port Report
+ - AIX 5.3 Additional Information
+ - AIX, readline, and postgres 8.1.x:
+ - AIX Memory Management: An Overview
+ - Statistics Collector Fun on AIX
+ 
+ -
+ 
+ Working Ports
+ -
+ Consult http://buildfarm.postgresql.org/ for latest information.
+ 
+ At time of writing the following builds work on 8.0, 8.1 and 8.2
+ 
+ AIX 5.3 using gcc 4.0.1 on PowerPC
+ AIX 5.2 using gcc 3.3.2 on PowerPC
+ AIX 5.2 using cc 6.0 on PowerPC
+ 
+ plus port report below for AIX 4.3.2
+ 
+ -
+ 
  From: Zeugswetter Andreas <[EMAIL PROTECTED]>
  $Date: 2006/09/20 02:10:11 $
  
Index: doc/FAQ_HPUX
===
RCS file: /projects/cvsroot/pgsql/doc/FAQ_HPUX,v
retrieving revision 1.14
diff -c -r1.14 FAQ_HPUX
*** doc/FAQ_HPUX	19 Jul 2006 02:37:00 -	1.14
--- doc/FAQ_HPUX	5 Dec 2006 12:57:59 -
***
*** 1,5 
  ===
! Frequently Asked Questions (FAQ) for PostgreSQL 7.3
  HP-UX Specific
  TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
  ===
--- 1,5 
  ===
! Frequently Asked Questions (FAQ) for PostgreSQL
  HP-UX Specific
  TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
  ===
***
*** 21,31 
  
  1.1)	What do I need to install PostgreSQL on HP-UX?
  
! PostgreSQL 7.3 should work on Series 700/800 PA-RISC machines running
  HP-UX 10.X or 11.X, given appropriate system patch levels and build
  tools.  At least one developer routinely tests on HPUX 10.20 and we
  have reports of successful installations on HPUX 11.00 and 11.11.
  
  Aside from the PostgreSQL source distribution, you will need GNU make
  (HP's make will not do), and either GNU gcc or HP's full ANSI C compiler.
  If you intend to build from CVS sources rather than a distribution tarball,
--- 21,36 
  
  1.1)	What do I need to install PostgreSQL on HP-UX?
  
! PostgreSQL 7.3+ should work on Series 700/800 PA-RISC machines running
  HP-UX 10.X or 11.X, given appropriate system patch levels and build
  tools.  At least one developer routinely tests on HPUX 10.20 and we
  have reports of successful installations on HPUX 11.00 and 11.11.
  
+ Recent port reports for PostgreSQL 8.2.0 are
+   - on IA64,HP-UX 11.23,   gcc and cc
+   - on PA-RISC, HP-UX 10.20 and 11.23, gcc and cc
+ Tested on 2006-10-23
+ 
  Aside from the PostgreSQL source distribution, you will need GNU make
  (HP's make will not do), and either GNU gcc or HP's full ANSI C compiler.
  If you intend to build from CVS sources rather than a distribution tarball,
Index: doc/FAQ_IRIX
===
RCS file: /projects/cvsroot/pgsql/doc/FAQ_IRIX,v
retrieving revision 1.3
diff -c -r1.3 FAQ_IRIX
*** doc/FAQ_IRIX	11 Nov 2002 20:04:05 -	1.3
--- doc/FAQ_IRIX	5 Dec 2006 12:57:59 -
***
*** 25,30 
--- 25,33 
  and r12000(ip35) processors, running IRIX 6.5.5m, 6.5.12 and 6.5.13 with
  MIPSPro compilers version 7.30, 7.3.1.2m and 7.3. 
  
+ PostgreSQL 8.1.0 has been reported as compiling successfully on IRIX 6.5
+ on MIPS using cc by Kenneth Marshall (<[EMAIL PROTECTED]>), 2005-11-04
+ 
  Aside from the PostgreSQL source distribution, you will need GNU make
  (SGI's make will not do), and the MIPSPro full ANSI C compiler.
  
Index: doc/FAQ_MINGW
===
RCS file: /projects/cvsroot/pgsql/doc/FAQ_MINGW,v
retrieving revision 1.5
diff -c -r1.5 FAQ_MINGW
*** doc/FAQ_MINGW	20 Nov 2006 19:31:27 -	1.5
--- doc/FAQ_MINGW	5 Dec 2006 12:57:59 -
***
*** 8,21 
 The most recent version of this document can be viewed at
 http://www.postgresql.org/docs/faqs.FAQ_MINGW.html.
 
!The FAQ for running PostgreSQL on native Win32 is at
!http://pginstaller.projects.postgresql.org/FAQ_windows.html.
 
 The native Win32 port is built from source using MinGW tools.  There
 is also a precompiled binary installer called pginstaller which you
 can find at