@@ -2,7 +2,7 @@ POSTGRESQL INSTALLATION INSTRUCTIONS
2
2
Copyright (c) 1996 Regents of the University of California
3
3
4
4
This directory contains the source and documentation for PostgreSQL
5
- (version 1.09 ) PostgreSQL is a derivative of POSTGRES 4.2 (the last
5
+ (version 6.0 ) PostgreSQL is a derivative of POSTGRES 4.2 (the last
6
6
release of the UC Berkeley research project). For copyright terms for
7
7
PostgreSQL, please see the file named COPYRIGHT. This version was
8
8
developed by a team of developers on the postgres developers mailing
@@ -15,23 +15,21 @@ REQUIREMENTS TO RUN POSTGRESQL
15
15
16
16
PostgreSQL has been tested on the following platforms:
17
17
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
35
33
36
34
PostgreSQL is also known to work on a number of other platforms that the
37
35
authors 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
40
38
hold the source, binaries, and user databases.
41
39
42
40
43
- MIGRATING FROM POSTGRES VERSION 1.0
41
+ MIGRATING FROM POSTGRES VERSION 1.*
44
42
-----------------------------------
45
43
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.
55
48
56
49
INSTALLING POSTGRESQL
57
50
---------------------
@@ -64,11 +57,11 @@ system to use it.
64
57
To install PostgreSQL on UNIX platforms:
65
58
66
59
1. 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.
68
61
69
62
2. Set your current directory to the source directory:
70
63
71
- cd /usr/src/postgres95
64
+ cd /usr/src/pgsql
72
65
73
66
3. Build PostgreSQL:
74
67
@@ -102,12 +95,6 @@ To install PostgreSQL on UNIX platforms:
102
95
- POSTGRESDIR specifies the top-level directory where PostgreSQL
103
96
binaries, header files, libraries, and databases are installed.
104
97
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
-
111
98
- USE_READLINE specifies whether you want to use the GNU readline and
112
99
history libraries for the psql interactive frontend program. GNU
113
100
readline is not supplied with PostgreSQL and can be found in the
@@ -123,7 +110,7 @@ To install PostgreSQL on UNIX platforms:
123
110
% cd src
124
111
% gmake
125
112
126
- The gmake ultimately issues the message "All of Postgres95 is
113
+ The gmake ultimately issues the message "All of PostgreSQL is
127
114
successfully made. Ready to install." If you don't get that, the make
128
115
failed, and there should be error messages at the end detailing why.
129
116
@@ -164,7 +151,7 @@ The program initdb (part of Postgres) is what initializes (creates) a
164
151
database system. Initdb uses the defaults specified in Makefile.global.
165
152
See the man page for initdb for more information.
166
153
167
- % initdb
154
+ % initdb --pgdata=/usr/local/pgsql/data --pglib=/usr/local/pgsql/lib
168
155
169
156
By default, the user issuing the initdb command becomes the Postgres
170
157
superuser, and only the unix superuser can specify any other user as the
@@ -189,12 +176,10 @@ Postgres superuser. See the postgres man page.
189
176
So, for example, you can login as the Postgres superuser and issue the
190
177
command:
191
178
192
- % postmaster -S - D/usr/lib/postgres/postgres_data -p5432
179
+ $ nohup postmaster -D/usr/local/pgsql/data >server.log 2>&1 &
193
180
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.
198
183
199
184
This is a good daemon to start via system startup scripts, using su (be
200
185
careful 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
208
193
regression tests can be found in src/test/regress. (see
209
194
src/test/regress/README for more details)
210
195
211
- % cd /usr/src/postgres95/src /test/regress
196
+ % cd /usr/src/pgsql /test/regress
212
197
% gmake all runtest
213
198
214
- This will run a whole slew of regression tests and might take a long time
199
+ This will run a whole slew of regression tests and might take an hour
215
200
to run. When it's done, the output is in the file obj/regress.out. You
216
201
can compare this to a sample run that we supply in the file
217
202
sample.regress.out. (You should get roughly the same output except for
218
203
some pathnames.)
219
204
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
225
206
226
207
PLAYING WITH POSTGRESQL
227
208
-----------------------
@@ -231,15 +212,12 @@ daemon is running, and the regression tests have passed, you'll want to
231
212
see PostgreSQL do something. That's easy. Invoke the interactive interface
232
213
to PostgreSQL, psql, and start typing SQL:
233
214
234
- % psql -p 5432 template1
215
+ $ psql template1
235
216
236
217
(psql has to open a particular database, but at this point the only one
237
218
that exists is the template1 database, which always exists. We will connect
238
219
to it only long enough to create another one and switch to it).
239
220
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
-
243
221
The response from psql is:
244
222
245
223
type \? for help on slash commands
@@ -280,11 +258,11 @@ QUESTIONS? BUGS? FEEDBACK?
280
258
First, please read the Frequently Asked Questions and answers in the file
281
259
called FAQ.
282
260
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
285
263
286
264
If you have a bug report to make, please send a filled out version of
287
- the file named "bug.template" to pg95-dev@ki.net .
265
+ the file named "bug.template" to hackers@postgreSQL.org .
288
266
289
267
If you would like to help out with the development and maintenance of
290
268
PostgreSQL, send subscribe to the developers mailing list. See
0 commit comments