From 61c91fd2d22c97fd942ca67f458af5dc364f5fab Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 10 Oct 2006 00:29:15 +0000 Subject: Backpatch FAQs to 8.1.X. --- doc/src/FAQ/FAQ.html | 63 +++++++++++++++++++++++++++++----------------------- 1 file changed, 35 insertions(+), 28 deletions(-) (limited to 'doc/src/FAQ/FAQ.html') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 6ba6dea2d8c..c22dc7ef668 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,10 +10,10 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Thu May 18 23:52:32 EDT 2006

+

Last updated: Mon Oct 9 20:28:14 EDT 2006

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) + "mailto:bruce@momjian.us">bruce@momjian.us)

The most recent version of this document can be viewed at 1.3) What is the copyright of PostgreSQL?
1.4) What platforms does PostgreSQL support?
1.5) Where can I get PostgreSQL?
- 1.6) What is the latest release?
+ 1.6) What is the most recent release?
1.7) Where can I get support?
1.8) How do I submit a bug report?
1.9) How do I find out about known bugs or @@ -63,8 +63,7 @@ 3.4) What debugging features are available?
3.5) Why do I get "Sorry, too many clients" when trying to connect?
- 3.6) Why do I need to do a dump and restore - to upgrade PostgreSQL releases?
+ 3.6 What is the upgrade process for PostgreSQL?
3.7) What computer hardware should I use?
@@ -200,7 +199,7 @@ instructions.

PostgreSQL also runs natively on Microsoft Windows NT-based operating - systems like Win2000, WinXP, and Win2003. A prepackaged installer is + systems like Win2000 SP4, WinXP, and Win2003. A prepackaged installer is available at http://pgfoundry.org/projects/pginstaller. MSDOS-based versions of Windows (Win95, Win98, WinMe) can run PostgreSQL using Cygwin.

@@ -218,7 +217,7 @@ ftp://ftp.PostgreSQL.org/pub/.

-

1.6) What is the latest release?

+

1.6) What is the most recent release?

The latest release of PostgreSQL is version 8.1.5.

@@ -241,8 +240,8 @@ (#postgresqlfr). There is also a PostgreSQL channel on EFNet.

A list of commercial support companies is available at - http://techdocs.postgresql.org/companies.php.

+ "http://www.postgresql.org/support/professional_support"> + http://www.postgresql.org/support/professional_support.

1.8) How do I submit a bug report?

@@ -472,9 +471,10 @@

2.3) Does PostgreSQL have a graphical user interface?

-

Yes, see - http://techdocs.postgresql.org/guides/GUITools for a - detailed list.

+

There are a large number of GUI Tools that are available for PostgreSQL + from both commercial and open source developers. A detailed list can be + found in the + PostgreSQL Community Documentation

@@ -544,11 +544,11 @@
Hardware Selection
-
The effect of hardware on performance is detailed in - http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html and +
The effect of hardware on performance is detailed in - http://www.powerpostgresql.com/PerfList/. + http://www.powerpostgresql.com/PerfList/ and + http://momjian.us/main/writings/pgsql/hw_performance/index.html.

@@ -570,16 +570,23 @@ max_connections value in postgresql.conf and restarting the postmaster.

-

3.6) Why do I need to do a dump and restore - to upgrade between major PostgreSQL releases?

+

3.6) What is the upgrade process for PostgreSQL?

-

The PostgreSQL team makes only small changes between minor releases, - so upgrading from 7.4.0 to 7.4.1 does not require a dump and restore. - However, major releases (e.g. from 7.3 to 7.4) often change the internal +

The PostgreSQL team makes only bug fixes in minor releases, + so, for example, upgrading from 7.4.8 to 7.4.9 does not require + a dump and restore; merely stop the database server, install + the updated binaries, and restart the server.

+ +

All users should upgrade to the most recent minor release as + soon as it is available. While every upgrade has some risk, + PostgreSQL minor releases are designed to fix only common bugs + with the least risk. The community considers not upgrading + more risky that upgrading.

+ +

Major releases (e.g. from 7.3 to 7.4) often change the internal format of system tables and data files. These changes are often complex, - so we don't maintain backward compatibility for data files. A dump outputs - data in a generic format that can then be loaded in using the new internal - format.

+ so we don't maintain backward compatibility for data files. A dump/reload + of the database is required for major upgrades.

3.7) What computer hardware should I use?

@@ -687,7 +694,7 @@ table?unlimited

One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are - rarely needed. Uniqueness is best guaranteed by a funtion index + rarely needed. Uniqueness is best guaranteed by a function index of an MD5 hash of the long column, and full text indexing allows for searching of words within the column.

@@ -805,8 +812,8 @@ table?unlimited FROM tab WHERE lower(col) = 'abc'; - This will not use an standard index. However, if you create a - expresssion index, it will be used: + This will not use an standard index. However, if you create an + expression index, it will be used: 
     CREATE INDEX tabindex ON tab (lower(col));
@@ -950,7 +957,7 @@ length

Every row that is created in PostgreSQL gets a unique OID unless created WITHOUT OIDS. - OIDs are autotomatically assigned unique 4-byte + OIDs are automatically assigned unique 4-byte integers that are unique across the entire installation. However, they overflow at 4 billion, and then the OIDs start being duplicated. PostgreSQL uses OIDs to link its -- cgit v1.2.3