postgresql:8.2:debian
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
postgresql:8.2:debian [2010/10/20 12:28] – rsoulliere | postgresql: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, | ||
- | |||
- | NOTE: These release notes are also available in the Evergreen documentation at [[http:// | ||
- | |||
- | |||
- | - If you have not yet installed '' | ||
- | aptitude install stow</ | ||
- | - Download, compile, and install the latest bugfix release for PostgreSQL 8.2 (8.2.12 at the time this was written):< | ||
- | wget http:// | ||
- | tar xjf postgresql-8.2.12.tar.bz2 | ||
- | cd postgresql-8.2.12 | ||
- | ./configure --with-perl --enable-integer-datetimes --with-openssl --prefix=/ | ||
- | make install | ||
- | cd contrib && make | ||
- | make install | ||
- | cd xml2 && make | ||
- | make install | ||
- | cd / | ||
- | stow pgsql | ||
- | # if there was a conflict, you can move the offending directory out of the way: | ||
- | mv / | ||
- | # then try again | ||
- | stow pgsql</ | ||
- | - Create a new user, '' | ||
- | adduser postgres</ | ||
- | - Initialize the database directory and start up PostgreSQL:< | ||
- | mkdir -p / | ||
- | chown postgres / | ||
- | su - postgres | ||
- | initdb -D / | ||
- | pg_ctl -D / | ||
- | </ | ||
- | |||
- | |||
- | ====== Config stuff to change ====== | ||
- | FIXME | ||
- | |||
- | echo 7000000000 > / | ||
- | |||
- | |||
- | 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: | ||
- | (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)