@@ -2,7 +2,7 @@ POSTGRESQL INSTALLATION INSTRUCTIONS
22Copyright (c) 1996 Regents of the University of California
33
44This directory contains the source and documentation for PostgreSQL
5- (version1.09 ) PostgreSQL is a derivative of POSTGRES 4.2 (the last
5+ (version6.0 ) PostgreSQL is a derivative of POSTGRES 4.2 (the last
66release of the UC Berkeley research project). For copyright terms for
77PostgreSQL, please see the file named COPYRIGHT. This version was
88developed by a team of developers on the postgres developers mailing
@@ -15,23 +15,21 @@ REQUIREMENTS TO RUN POSTGRESQL
1515
1616PostgreSQL has been tested on the following platforms:
1717
18- alpha-DEC Alpha AXP on OSF/1 2.0
19- hpux-HP PA-RISC on HP-UX 9.0
20- i386_solaris-i386 Solaris
21- sparc_solaris-SUN SPARC on Solaris 2.4
22- sparc-SUN SPARC on SunOS 4.1.3
23- ultrix4-DEC MIPS on Ultrix 4.4
24- linux-Intel x86 on Linux 1.2 (or above) ELF or a.out
25- BSD44_derived-OSs derived from 4.4-lite BSD (NetBSD, FreeBSD)
26- bsdi - BSD/OS 2.0 and 2.01
27- bsdi_2_1 - BSD/OS 2.1
28- aix-IBM on AIX 3.2.5
29- irix5-SGI MIPS on IRIX 5.3
30- dgux - DG/UX 5.4R3.10
31- Some hooks are provided for
32- svr4-Intel x86 on Intel SVR4
33- next-Motorola MC68K or Intel x86 on NeXTSTEP 3.2
34- but these are guaranteed not to work as of yet.
18+ aix IBM on AIX 3.2.5
19+ alpha DEC Alpha AXP on OSF/1 2.0
20+ BSD44_derived OSs derived from 4.4-lite BSD (NetBSD, FreeBSD)
21+ bsdi BSD/OS 2.0, 2.01, 2.1
22+ dgux DG/UX 5.4R3.10
23+ hpux HP PA-RISC on HP-UX 9.0
24+ i386_solaris i386 Solaris
25+ irix5 SGI MIPS on IRIX 5.3
26+ linux Intel x86 on Linux 1.2 and Linux ELF
27+ (For non-ELF Linux, see LINUX_ELF below).
28+ next Motorola MC68K or Intel x86 on NeXTSTEP 3.2
29+ sparc_solaris SUN SPARC on Solaris 2.4
30+ sunos4 SUN SPARC on SunOS 4.1.3
31+ svr4 Intel x86 on Intel SVR4
32+ ultrix4 DEC MIPS on Ultrix 4.4
3533
3634PostgreSQL is also known to work on a number of other platforms that the
3735authors have not personally tested.
@@ -40,18 +38,13 @@ You should have at least 8 MB of memory and at least 30 MB of disk space to
4038hold the source, binaries, and user databases.
4139
4240
43- MIGRATING FROM POSTGRES VERSION 1.0
41+ MIGRATING FROM POSTGRES VERSION 1.*
4442-----------------------------------
4543
46- Version 1.01 and 1.02 (and above) are mostly backward compatible with Version
47- 1.0, but the database format is incompatible, so if you have databases that
48- you use with Version 1, you need to convert them before you can use them with
49- Version 1.02. Once you do that, you won't be able to use them with Version 1
50- anymore.
51-
52- For details on how to do this conversion, see the files doc/MIGRATION_1.0_to_1.01
53- and MIGRATION_to_1.02.1
54-
44+ People migrating data from earlier releases must dump the data under
45+ 1.09 and reload them under 6.0. The pg_dump utility is designed to do
46+ this. It is important you use 1.09 because earlier releases may not
47+ have the proper copy format to load into the 6.0 database.
5548
5649INSTALLING POSTGRESQL
5750---------------------
@@ -64,11 +57,11 @@ system to use it.
6457To install PostgreSQL on UNIX platforms:
6558
66591. Unpack the source distribution into a source directory. We'll assume
67- "/usr/src/postgres95 " in this discussion. This should be a new directory.
60+ "/usr/src/pgsql " in this discussion. This should be a new directory.
6861
69622. Set your current directory to the source directory:
7063
71- cd /usr/src/postgres95
64+ cd /usr/src/pgsql
7265
73663. Build PostgreSQL:
7467
@@ -102,12 +95,6 @@ To install PostgreSQL on UNIX platforms:
10295 - POSTGRESDIR specifies the top-level directory where PostgreSQL
10396 binaries, header files, libraries, and databases are installed.
10497
105- - NAMEDATALEN and OIDNAMELEN allows you to set the maximum length of
106- system identifiers (table names, function names, etc.) It
107- defaults to 32. You may alter this if you like, but be aware that
108- databases created with different NAMEDATALEN's do not
109- interoperate.
110-
11198 - USE_READLINE specifies whether you want to use the GNU readline and
11299 history libraries for the psql interactive frontend program. GNU
113100 readline is not supplied with PostgreSQL and can be found in the
@@ -123,7 +110,7 @@ To install PostgreSQL on UNIX platforms:
123110 % cd src
124111 % gmake
125112
126- The gmake ultimately issues the message "All ofPostgres95 is
113+ The gmake ultimately issues the message "All ofPostgreSQL is
127114 successfully made. Ready to install." If you don't get that, the make
128115 failed, and there should be error messages at the end detailing why.
129116
@@ -164,7 +151,7 @@ The program initdb (part of Postgres) is what initializes (creates) a
164151database system. Initdb uses the defaults specified in Makefile.global.
165152See the man page for initdb for more information.
166153
167- % initdb
154+ % initdb --pgdata=/usr/local/pgsql/data --pglib=/usr/local/pgsql/lib
168155
169156By default, the user issuing the initdb command becomes the Postgres
170157superuser, and only the unix superuser can specify any other user as the
@@ -189,12 +176,10 @@ Postgres superuser. See the postgres man page.
189176So, for example, you can login as the Postgres superuser and issue the
190177command:
191178
192- % postmaster -S - D/usr/lib/postgres/postgres_data -p5432
179+ $ nohup postmaster -D/usr/local/pgsql/data >server.log 2>&1 &
193180
194- This says to run the postmaster against the database system created above,
195- to accept connections from users on the conventional TCP port 5432, and
196- (-S) to run in the background without issuing messages about normal
197- execution.
181+ This says to run the postmaster against the database system created
182+ above.
198183
199184This is a good daemon to start via system startup scripts, using su (be
200185careful NOT to run the postmaster as the unix superuser by mistake).
@@ -208,20 +193,16 @@ installed successfully and works as designed in your environment. The
208193regression tests can be found in src/test/regress. (see
209194src/test/regress/README for more details)
210195
211- % cd /usr/src/postgres95/src /test/regress
196+ % cd /usr/src/pgsql /test/regress
212197 % gmake all runtest
213198
214- This will run a whole slew of regression tests and might takea long time
199+ This will run a whole slew of regression tests and might takean hour
215200to run. When it's done, the output is in the file obj/regress.out. You
216201can compare this to a sample run that we supply in the file
217202sample.regress.out. (You should get roughly the same output except for
218203some pathnames.)
219204
220- % diff obj/regress.out sample.regress.out
221-
222- The regression test takes about half an hour to run on a Sparc 10. You
223- may want to use 'grep -v' to remove unsignificant differences.
224-
205+ % diff expected.out regress.out
225206
226207PLAYING WITH POSTGRESQL
227208-----------------------
@@ -231,15 +212,12 @@ daemon is running, and the regression tests have passed, you'll want to
231212see PostgreSQL do something. That's easy. Invoke the interactive interface
232213to PostgreSQL, psql, and start typing SQL:
233214
234- % psql -p 5432 template1
215+ $ psql template1
235216
236217(psql has to open a particular database, but at this point the only one
237218that exists is the template1 database, which always exists. We will connect
238219to it only long enough to create another one and switch to it).
239220
240- Note that we have told psql to connect to Port 5432, which is what we told
241- the postmaster to listen on when we started it above.
242-
243221The response from psql is:
244222
245223 type \? for help on slash commands
@@ -280,11 +258,11 @@ QUESTIONS? BUGS? FEEDBACK?
280258First, please read the Frequently Asked Questions and answers in the file
281259called FAQ.
282260
283- If you still have questions, please send them to
284- postgres95@postgres95.vnet.net.
261+ If you still have questions, please send them to:
262+ questions@postgreSQL.org
285263
286264If you have a bug report to make, please send a filled out version of
287- the file named "bug.template" topg95-dev@ki.net .
265+ the file named "bug.template" tohackers@postgreSQL.org .
288266
289267If you would like to help out with the development and maintenance of
290268PostgreSQL, send subscribe to the developers mailing list. See