User Tools

Site Tools


postgresql:8.2:debian

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
postgresql:8.2:debian [2010/10/20 12:28] rsoullierepostgresql:8.2:debian [2014/05/21 15:25] (current) – postgresql commonly available from packages now (and also in official DIG docs how-to for 1.6) bshum
Line 1: Line 1:
-====== Installing PostgreSQL 8.2 from source on Debian or Ubuntu ====== 
-Some distributions, such as [[http://www.debian.org/releases/etch/|Debian Etch]], do not offer packages for PostgreSQL 8.2---but Evergreen 1.4 requires PostgreSQL 8.2. Following is a rough set of instructions for installing PostgreSQL 8.2 from source on a Debian or Ubuntu system as a ''stow''-managed application. 
- 
-NOTE: These release notes are also available in the Evergreen documentation at [[http://docs.evergreen-ils.org/1.6/draft/html/InstallingPostgreSQL.html]]. In github: [[http://github.com/rsoulliere/Evergreen-DocBook/blob/master/1.6/admin/AdminMisc.xml]]. 
- 
- 
-  - If you have not yet installed ''stow'' on your system, install it. Issue the following command as the **root** user:<code bash> 
-aptitude install stow</code> 
-  - Download, compile, and install the latest bugfix release for PostgreSQL 8.2 (8.2.12 at the time this was written):<code bash> 
-wget http://wwwmaster.postgresql.org/redir/198/h/source/v8.2.12/postgresql-8.2.12.tar.bz2 
-tar xjf postgresql-8.2.12.tar.bz2 
-cd postgresql-8.2.12 
-./configure --with-perl --enable-integer-datetimes --with-openssl --prefix=/usr/local/stow/pgsql && make 
-make install 
-cd contrib && make 
-make install 
-cd xml2 && make 
-make install 
-cd /usr/local/stow 
-stow pgsql 
-# if there was a conflict, you can move the offending directory out of the way: 
-mv /usr/local/man /usr/local/man.bak 
-# then try again 
-stow pgsql</code> 
-  - Create a new user, ''postgres'', to run the PostgreSQL processes:<code bash> 
-adduser postgres</code> 
-  - Initialize the database directory and start up PostgreSQL:<code bash> 
-mkdir -p /usr/local/pgsql/data 
-chown postgres /usr/local/pgsql/data 
-su - postgres 
-initdb -D /usr/local/pgsql/data -E UNICODE --locale=C 
-pg_ctl -D /usr/local/pgsql/data -l /home/postgres/logfile start 
-</code> 
- 
- 
-====== Config stuff to change ====== 
-FIXME 
- 
-echo 7000000000 > /proc/sys/kernel/shmmax 
- 
- 
-default stats target (from 10 to 100) 
- 
-work mem (from 4m to something higher... 128M?) 
- 
-Shared buffers (to 512M for a 2G machine) 
- 
-Effective cache size 
- 
-(11:41:49 AM) dmcmorris_esi: miker_: stats target , workmem, shared buffers for 32GB Mem 
-(11:42:34 AM) miker_: stats target = 100 (always), work mem = 128M, shared buffers = 4G 
-(11:42:51 AM) miker_: effective cache size = 24G 
- 
-Vaccuum full analyze verbose 
  
postgresql/8.2/debian.1287592082.txt.gz · Last modified: 2022/02/10 13:34 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.