1
- PostgreSQL Installation Instructions
2
-
3
- Table of Contents
4
- Short Version
5
- Requirements
6
- If You Are Upgrading
7
- Installation Procedure
8
- Post-Installation Setup
9
- Getting Started
10
- What Now?
11
- Supported Platforms
1
+ PostgreSQL Installation Instructions
12
2
13
3
Short Version
14
4
@@ -22,6 +12,7 @@ su - postgres
22
12
/usr/local/pgsql/bin/createdb test
23
13
/usr/local/pgsql/bin/psql test
24
14
15
+
25
16
The long version is the rest of this document.
26
17
27
18
------------------------------------------------------------------------
@@ -53,7 +44,9 @@ The following prerequisites exist for building PostgreSQL:
53
44
54
45
* The GNU Readline library for comfortable line editing and command
55
46
history retrieval will automatically be used if found. You might wish
56
- to install it before proceeding, but it is not required.
47
+ to install it before proceeding, but it is not required. (On NetBSD,
48
+ the libedit library is readline-compatible and is used if libreadline
49
+ is not found.)
57
50
58
51
* Flex and Bison are not required when building from a released source
59
52
package because the output files are pre-generated. You will need these
@@ -99,10 +92,12 @@ here. These instructions assume that your existing installation is under the
99
92
pg_dumpall > outputfile
100
93
101
94
If you need to preserve the OIDs (such as when using them as foreign
102
- keys), then use the -o option when running pg_dumpall.
95
+ keys), then use the -o option when running pg_dumpall. pg_dumpall does
96
+ not save large objects. Check the Administrator's Guide if you need to
97
+ do this.
103
98
104
99
Make sure that you use the pg_dumpall command from the version you are
105
- currently running. 7.1devel 's pg_dumpall should not be used on older
100
+ currently running. 7.1 's pg_dumpall should not be used on older
106
101
databases.
107
102
108
103
3. If you are installing the new version at the same location as the old
@@ -116,9 +111,9 @@ here. These instructions assume that your existing installation is under the
116
111
yourself, for example by typing ps ax | grep postmaster, and supply it
117
112
to the kill command.
118
113
119
- On systems which have PostgreSQL started at boot time, there is
120
- probably a start-up file that will accomplish the same thing. For
121
- example, on a Red Hat Linux system one might find that
114
+ On systems that have PostgreSQL started at boot time, there is probably
115
+ a start-up file that will accomplish the same thing. For example, on a
116
+ Red Hat Linux system one might find that
122
117
123
118
/etc/rc.d/init.d/postgresql stop
124
119
@@ -130,10 +125,10 @@ here. These instructions assume that your existing installation is under the
130
125
131
126
mv /usr/local/pgsql /usr/local/pgsql.old
132
127
133
- After you have installed PostgreSQL 7.1devel , create a new database
134
- directory and start the new server. Remember that you must execute these
135
- commands while logged in to the special database user account (which you
136
- already have if you are upgrading).
128
+ After you have installed PostgreSQL 7.1 , create a new database directory and
129
+ start the new server. Remember that you must execute these commands while
130
+ logged in to the special database user account (which you already have if
131
+ you are upgrading).
137
132
138
133
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
139
134
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
@@ -369,6 +364,13 @@ Installation Procedure
369
364
to make sure that your OpenSSL installation is sufficient before
370
365
proceeding.
371
366
367
+ --with-java
368
+
369
+ Build the JDBC driver and associated Java packages. This option
370
+ requires Ant to be installed (as well as a JDK, of course). Refer
371
+ to the JDBC driver documentation in the Programmer's Guide for
372
+ more information.
373
+
372
374
--enable-syslog
373
375
374
376
Enables the PostgreSQL server to use the syslog logging facility.
@@ -380,7 +382,26 @@ Installation Procedure
380
382
381
383
Compiles all programs and libraries with debugging symbols. This
382
384
means that you can run the programs through a debugger to analyze
383
- problems. This option is not recommended for production use.
385
+ problems. This enlarges the size of the installed executables
386
+ considerably, and on non-gcc compilers it usually also disables
387
+ compiler optimization, causing slowdowns. However, having the
388
+ symbols available is extremely helpful for dealing with any
389
+ problems that may arise. Currently, this option is considered of
390
+ marginal value for production installations, but you should have
391
+ it on if you are doing development work or running a beta version.
392
+
393
+ --enable-cassert
394
+
395
+ Enables assertion checks in the server, which test for many "can't
396
+ happen" conditions. This is invaluable for code development
397
+ purposes, but the tests slow things down a little. Also, having
398
+ the tests turned on won't necessarily enhance the stability of
399
+ your server! The assertion checks are not categorized for
400
+ severity, and so what might be a relatively harmless bug will
401
+ still lead to postmaster restarts if it triggers an assertion
402
+ failure. Currently, this option is not recommended for production
403
+ use, but you should have it on for development work or when
404
+ running a beta version.
384
405
385
406
If you prefer a C or C++ compiler different from the one configure
386
407
picks then you can set the environment variables CC and CXX,
@@ -449,8 +470,21 @@ Installation Procedure
449
470
other directories where Perl or Python can find them, but how to do
450
471
that is left as an exercise.
451
472
473
+ The standard install installs only the header files needed for client
474
+ application development. If you plan to do any server-side program
475
+ development (such as custom functions or datatypes written in C), then
476
+ you may want to install the entire PostgreSQL include tree into your
477
+ target include directory. To do that, enter
478
+
479
+ gmake install-all-headers
480
+
481
+ This adds a megabyte or two to the install footprint, and is only
482
+ useful if you don't plan to keep the whole source tree around for
483
+ reference. (If you do, you can just use the source's include directory
484
+ when building server-side software.)
485
+
452
486
Client-only installation. If you want to install only the client
453
- applications and interfaces , then you can use these commands:
487
+ applications and interface libraries , then you can use these commands:
454
488
455
489
gmake -C src/bin install
456
490
gmake -C src/interfaces install
@@ -600,13 +634,13 @@ What Now?
600
634
601
635
* The Tutorial should be your first reading if you are completely new to
602
636
SQL databases. It should have been installed at
603
- /usr/local/pgsql/doc/html/tutorial.htm unless you changed the
637
+ /usr/local/pgsql/doc/html/tutorial.html unless you changed the
604
638
installation directories.
605
639
606
640
* If you are familiar with database concepts then you want to proceed
607
641
with the Administrator's Guide, which contains information about how to
608
642
set up the database server, database users, and authentication. It can
609
- be found at /usr/local/pgsql/doc/html/admin.htm .
643
+ be found at /usr/local/pgsql/doc/html/admin.html .
610
644
611
645
* Usually, you will want to modify your computer so that it will
612
646
automatically start the database server whenever it boots. Some
@@ -630,87 +664,113 @@ tests pass.
630
664
supported platform, please write to <pgsql-bugs@postgresql.org> or
631
665
<pgsql-ports@postgresql.org>, not to the people listed here.
632
666
633
- OS Processor Version Reported Remarks
634
- AIX 4.3.2 RS6000 7.0 2000-04-05, Andread Zeugswetter See also
635
- (<Andreas.Zeugswetter@telecom.at>) doc/FAQ_AIX
636
- BSDI 4.01 x86 7.0 2000-04-04, Bruce Momjian
637
- (<pgman@candle.pha.pa.us>)
638
- Compaq Tru64 Alpha 7.0 2000-04-11, Andrew McMurry
639
- 5.0 (<andrew.mcmurry@astro.uio.no>)
640
- FreeBSD 4.0 x86 7.0 2000-04-04, Marc Fournier
641
- (<scrappy@hub.org>)
642
- HPUX 9.0x andPA-RISC 7.0 2000-04-12, Tom Lane See also
643
- 10.20 (<tgl@sss.pgh.pa.us>) doc/FAQ_HPUX
644
- IRIX 6.5.6f MIPS 6.5.3 2000-02-18, Kevin Wheatley MIPSPro
645
- (<hxpro@cinesite.co.uk>) 7.3.1.1m N32
646
- build
647
- Linux 2.0.x Alpha 7.0 2000-04-05, Ryan Kirkpatrick with published
648
- (<pgsql@rkirkpat.net>) patches
649
- Linux 2.2.x armv4l 7.0 2000-04-17, Mark Knox Regression
650
- (<segfault@hardline.org>) test needs
651
- work.
652
- Linux 2.2.x x86 7.0 2000-03-26, Lamar Owen
653
- (<lamar.owen@wgcr.org>)
654
- Linux 2.0.x MIPS 7.0 2000-04-13, Tatsuo Ishii Cobalt Qube
655
- (<t-ishii@sra.co.jp>)
656
- Linux 2.2.5 Sparc 7.0 2000-04-02, Tom Szybist
657
- (<szybist@boxhill.com>)
658
- LinuxPPC R4 PPC603e 7.0 2000-04-13, Tatsuo Ishii
659
- (<t-ishii@sra.co.jp>)
660
- mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii
661
- (<t-ishii@sra.co.jp>)
662
- NetBSD 1.4 arm32 7.0 2000-04-08, Patrick Welche
663
- (<prlw1@newn.cam.ac.uk>)
664
- NetBSD 1.4U x86 7.0 2000-03-26, Patrick Welche
665
- (<prlw1@newn.cam.ac.uk>)
666
- NetBSD m68k 7.0 2000-04-10, Henry B. Hotz Mac 8xx
667
- (<hotz@jpl.nasa.gov>)
668
- NetBSD Sparc 7.0 2000-04-13, Tom I. Helbekkmo
669
- (<tih@kpnQwest.no>)
670
- QNX 4.25 x86 7.0 2000-04-01, Dr. Andreas Kardos See also
671
- (<kardos@repas-aeg.de>) doc/FAQ_QNX4
672
- SCO x86 6.5 1999-05-25, Andrew Merrill See also
673
- OpenServer 5 (<andrew@compclass.com>) doc/FAQ_SCO
674
- SCO UnixWare x86 7.0 2000-04-18, Billy G. Allie See also
675
- 7 (<Bill.Allie@mug.org>) doc/FAQ_SCO
676
- Solaris x86 7.0 2000-04-12, Marc Fournier
677
- (<scrappy@hub.org>)
678
- Solaris Sparc 7.0 2000-04-12, Peter Eisentraut
679
- 2.5.1-2.7 (<peter_e@gmx.net>), Marc Fournier
680
- (<scrappy@hub.org>)
681
- SunOS 4.1.4 Sparc 7.0 2000-04-13, Tatsuo Ishii
682
- (<t-ishii@sra.co.jp>)
683
- Windows/Win32x86 7.0 2000-04-02, Magnus Hagander Client-side
684
- (<mha@sollentuna.net>) libraries or
685
- ODBC/JDBC, no
686
- server-side
687
- WinNT/Cygwin x86 7.0 2000-03-30, Daniel Horak with
688
- (<horak@sit.plzen-city.cz>) RedHat/Cygnus
689
- Cygwin toolset
667
+ OS Processor Version Reported Remarks
668
+ AIX 4.3.3RS6000 7.1 2001-03-21, Gilles Darold see also
669
+ (<gilles@darold.net>) doc/FAQ_AIX
670
+ BeOS x86 7.1 2001-02-26, Cyril Velter requires new
671
+ 5.0.4 (<cyril.velter@libertysurf.fr>) BONE networking
672
+ stack
673
+ BSD/OS x86 7.1 2001-03-20, Bruce Momjian
674
+ 4.01 (<pgman@candle.pha.pa.us>)
675
+ Compaq Alpha 7.1 2001-03-26, Adriaan Joubert 4.0-5.0, cc and
676
+ Tru64 (<a.joubert@albourne.com>) gcc
677
+ UNIX
678
+ FreeBSD x86 7.1 2001-03-19, Vince Vielhaber
679
+ 4.3 (<vev@hub.org>)
680
+ HP/UX PA-RISC 7.1 2001-03-19, 10.20 Tom Lane 32- and 64-bit
681
+ (<tgl@sss.pgh.pa.us>), 2001-03-22, on 11.00; see
682
+ 11.00, 11i Giles Lean also
683
+ (<giles@nemeton.com.au>) doc/FAQ_HPUX
684
+ IRIX MIPS 7.1 2001-03-22, Robert Bruccoleri 32-bit
685
+ 6.5.11 (<bruc@acm.org>) compilation
686
+ model
687
+ Linux Alpha 7.1 2001-01-23, Ryan Kirkpatrick
688
+ 2.2.x (<pgsql@rkirkpat.net>)
689
+ Linux armv4l 7.1 2001-02-22, Mark Knox
690
+ 2.2.x (<segfault@hardline.org>)
691
+ Linux MIPS 7.1 2001-03-30, Dominic Eidson Cobalt Qube
692
+ 2.0.x (<sauron@the-infinite.org>)
693
+ Linux PPC74xx 7.1 2001-03-19, Tom Lane Apple G3
694
+ 2.2.18 (<tgl@sss.pgh.pa.us>)
695
+ Linux S/390 7.1 2000-11-17, Neale Ferguson
696
+ (<Neale.Ferguson@softwareAG-usa.com>)
697
+ Linux Sparc 7.1 2001-01-30, Ryan Kirkpatrick
698
+ 2.2.15 (<pgsql@rkirkpat.net>)
699
+ Linux x86 7.1 2001-03-19, Thomas Lockhart 2.0.x, 2.2.x,
700
+ (<thomas@fourpalms.org>) 2.4.2
701
+ MacOS X PPC 7.1 2000-12-11, Peter Bierman Darwin (only)
702
+ (<bierman@apple.com>), 2000-12-11, Beta-2 or higher
703
+ Daniel Luke (<dluke@geeklair.net>)
704
+ NetBSD Alpha 7.1 2001-03-22, Giles Lean
705
+ 1.5 (<giles@nemeton.com.au>)
706
+ NetBSD arm32 7.1 2001-03-21, Patrick Welche
707
+ 1.5E (<prlw1@cam.ac.uk>)
708
+ NetBSD m68k 7.0 2000-04-10, Henry B. Hotz Mac 8xx
709
+ (<hotz@jpl.nasa.gov>)
710
+ NetBSD PPC 7.1 2001-04-05, Henry B. Hotz Mac G4
711
+ (<hotz@jpl.nasa.gov>)
712
+ NetBSD Sparc 7.1 2000-04-05, Matthew Green 32- and 64-bit
713
+ (<mrg@eterna.com.au>) builds
714
+ NetBSD VAX 7.1 2001-03-30, Tom I. Helbekkmo
715
+ 1.5 (<tih@kpnQwest.no>)
716
+ NetBSD x86 7.1 2001-03-23, Giles Lean
717
+ 1.5 (<giles@nemeton.com.au>)
718
+ OpenBSD Sparc 7.1 2001-03-23, Brandon Palmer
719
+ 2.8 (<bpalmer@crimelabs.net>)
720
+ OpenBSD x86 7.1 2001-03-21, Brandon Palmer
721
+ 2.8 (<bpalmer@crimelabs.net>)
722
+ SCO x86 7.1 2001-03-19, Larry Rosenman UDK FS compiler;
723
+ UnixWare (<ler@lerctr.org>) see also
724
+ 7.1.1 doc/FAQ_SCO
725
+ Solaris Sparc 7.1 2001-03-22, Marc Fournier see also
726
+ 2.7-8 (<scrappy@hub.org>), 2001-03-25, doc/FAQ_Solaris
727
+ Justin Clift (<justin@postgresql.org>)
728
+ Solaris x86 7.1 2001-03-27, Mathijs Brands see also
729
+ 2.8 (<mathijs@ilse.nl>) doc/FAQ_Solaris
730
+ SunOS Sparc 7.1 2001-03-23, Tatsuo Ishii
731
+ 4.1.4 (<t-ishii@sra.co.jp>)
732
+ Windows x86 7.1 2001-03-16, Jason Tishler with Cygwin
733
+ NT/2000 (<Jason.Tishler@dothill.com>) toolset, see
734
+ with doc/FAQ_MSWIN
735
+ Cygwin
690
736
691
737
Unsupported Platforms. The following platforms have not been verified to
692
738
work. Platforms listed for version 6.3.x and later should also work with
693
- 7.1devel , but we did not receive explicit confirmation of such at the time
694
- this list was compiled. We include these here to let you know that these
739
+ 7.1 , but we did not receive explicit confirmation of such at the time this
740
+ list was compiled. We include these here to let you know that these
695
741
platforms could be supported if given some attention.
696
742
697
- OS Processor Version Reported Remarks
698
- BeOS x86 7.0 2000-05-01, Adam Haberlach Client-side
699
- (<adam@newsnipple.com>) coming soon?
700
- DGUX m88k 6.3 1998-03-01, Brian E Gallew 6.4 probably
701
- 5.4R4.11 (<geek+@cmu.edu>) OK. Needs new
702
- maintainer.
703
- NetBSD 1.3VAX 6.3 1998-03-01, Tom I Helbekkmo 7.0 should
704
- (<tih@kpnQwest.no>) work.
705
- System V m88k 6.2.1 1998-03-01, Doug Winterburn Needs new TAS
706
- R4 4.4 (<dlw@seavme.xroads.com>) spinlock code
707
- System V MIPS 6.4 1998-10-28, Frank Ridderbusch No 64-bit
708
- R4 (<ridderbusch.pad@sni.de>) integer
709
- Ultrix MIPS, VAX 6.x 1998-03-01 No recent
710
- reports.
711
- Obsolete?
712
- MacOS all 6.x 1998-03-01 Not library
713
- compatible;
714
- use ODBC/JDBC.
715
- NextStep x86 6.x 1998-03-01, David Wetzel Client-only
716
- (<dave@turbocat.de>) support
743
+ OS Processor VersionReported Remarks
744
+ DGUX m88k 6.3 1998-03-01, Brian E Gallew 6.4 probably OK
745
+ 5.4R4.11 (<geek+@cmu.edu>)
746
+ MkLinux DR1 PPC750 7.0 2001-04-03, Tatsuo Ishii 7.1 needs OS
747
+ (<t-ishii@sra.co.jp>) update?
748
+ NextStep x86 6.x 1998-03-01, David Wetzel bit rot
749
+ (<dave@turbocat.de>) suspected
750
+ QNX 4.25 x86 7.0 2000-04-01, Dr. Andreas Spinlock code
751
+ Kardos needs work. See
752
+ (<kardos@repas-aeg.de>) also
753
+ doc/FAQ_QNX4.
754
+ SCO x86 6.5 1999-05-25, Andrew Merrill 7.1 should work,
755
+ OpenServer (<andrew@compclass.com>) but no reports;
756
+ 5 see also
757
+ doc/FAQ_SCO
758
+ System V R4 m88k 6.2.1 1998-03-01, Doug Winterburn needs new TAS
759
+ (<dlw@seavme.xroads.com>) spinlock code
760
+ System V R4 MIPS 6.4 1998-10-28, Frank no 64-bit
761
+ Ridderbusch integer
762
+ (<ridderbusch.pad@sni.de>)
763
+ Ultrix MIPS 7.1 2001-03-26 TAS spinlock
764
+ code not
765
+ detected
766
+ Ultrix VAX 6.x 1998-03-01 No recent
767
+ reports.
768
+ Obsolete?
769
+ Windows 9x, x86 7.1 2001-03-26, Magnus Hagander client-side
770
+ ME, NT, (<mha@sollentuna.net>) libraries (libpq
771
+ 2000 and psql) or
772
+ (native) ODBC/JDBC, no
773
+ server-side; see
774
+ Administrator's
775
+ Guide for
776
+ instructions
0 commit comments