1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
3
<!--Converted with LaTeX2HTML 2002-2-1 (1.70)
4
original version by: Nikos Drakos, CBLU, University of Leeds
5
* revised and updated by: Marcus Hennecke, Ross Moore, Herb Swan
6
* with significant contributions from:
7
Jens Lippmann, Marek Rouchal, Martin Wilck and others -->
10
<TITLE>PostgreSQL</TITLE>
11
<META NAME="description" CONTENT="PostgreSQL">
12
<META NAME="keywords" CONTENT="install">
13
<META NAME="resource-type" CONTENT="document">
14
<META NAME="distribution" CONTENT="global">
16
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
17
<META NAME="Generator" CONTENT="LaTeX2HTML v2002-2-1">
18
<META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css">
20
<LINK REL="STYLESHEET" HREF="install.css">
22
<LINK REL="next" HREF="node5.html">
23
<LINK REL="previous" HREF="node3.html">
24
<LINK REL="up" HREF="install.html">
25
<LINK REL="next" HREF="node5.html">
29
<!--Navigation Panel-->
32
<IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A>
35
<IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A>
38
<IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A>
41
<IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A>
43
<B> Next:</B> <A NAME="tex2html99"
44
HREF="node5.html">GEOS</A>
45
<B> Up:</B> <A NAME="tex2html95"
46
HREF="install.html">Building and Installing QGIS</A>
47
<B> Previous:</B> <A NAME="tex2html89"
48
HREF="node3.html">Getting QGIS</A>
49
<B> <A NAME="tex2html97"
50
HREF="node1.html">Contents</A></B>
53
<!--End of Navigation Panel-->
55
<H1><A NAME="SECTION00040000000000000000">
58
QGIS uses the latest features of PostgreSQL. For this reason, version 7.4.x or higher is recommended with QGIS version 0.5. If you choose to add PostgreSQL, you must also install PostGIS and the GEOS library (see below).
61
<LI>Download PostgreSQL source from www.postgresql.org
63
<LI>Extract the source
65
tar -xzf postgresql-7.4.1.tar.gz
70
<LI>Change to the source directory
77
<LI>Configure PostgreSQL:
79
./configure --prefix=/usr/local/pgsql
98
<LI>As root, create the postgres user and setup the database (following taken from PostgreSQL INSTALL file with modification)
101
<LI>Create the postgres user
108
<LI>Create the directory for the PostgreSQL database
110
mkdir /usr/local/pgsql/data
115
<LI>Change ownership of the data directory to the postgres user
117
chown postgres /usr/local/pgsql/data
122
<LI>su to the postgres user (or login as postgres)
129
<LI>Change to the PostgreSQL install directory
136
<LI>Initialize the database
138
./bin/initdb -D /usr/local/pgsql/data
143
<LI>Start the PostgreSQL daemon
144
<FONT SIZE="-1"> </FONT><PRE>
145
./bin/pg_ctl start -o "-i" -D /usr/local/pgsql/data -l /home/postgres/serverlog
146
</PRE><FONT SIZE="-1">
151
<LI>Create the test database
156
</PRE><FONT SIZE="-1">
161
<LI>PostgreSQL should now be running. Logon as the postgres user (or use su - postgres). You should be able to connect to the test database and execute a test query with the following commands:
168
-------------------------------------------------------------------------------------
169
PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (SuSE Linux)
177
<LI>PostgreSQL install is done
184
<!--Navigation Panel-->
187
<IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A>
190
<IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A>
193
<IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A>
196
<IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A>
198
<B> Next:</B> <A NAME="tex2html99"
199
HREF="node5.html">GEOS</A>
200
<B> Up:</B> <A NAME="tex2html95"
201
HREF="install.html">Building and Installing QGIS</A>
202
<B> Previous:</B> <A NAME="tex2html89"
203
HREF="node3.html">Getting QGIS</A>
204
<B> <A NAME="tex2html97"
205
HREF="node1.html">Contents</A></B>
206
<!--End of Navigation Panel-->