-
Notifications
You must be signed in to change notification settings - Fork 6
/
handy_postgresql.txt
29 lines (21 loc) · 1.18 KB
/
handy_postgresql.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#PostgreSQL source code installation instructions.
Or use percona-qa/build_postgresql_debug.sh
1) Download source code.
The source code can be found from following locations;
https://www.postgresql.org/ftp/source/
https://git.postgresql.org/gitweb/?p=postgresql.git;a=summary
2) Steps to build debug binary;
./configure --enable-debug --prefix=/pgsql/base # change prefix to the path where you want to build PostgreSQL to
gmake # or make
gmake install # not an actual install, only a "install" (i.e. copy) into the target directory (i.e. the one specified in prefix)
This will install postgres binary files under /pgsql/base.
3) Steps to start postgresql database server
# Database initialization command
/pgsql/base/bin/initdb -D /pgsql/base/data
# Startup command
/pgsql/base/bin/pg_ctl -D /pgsql/base/data -l /pgsql/base/data/pgsql.log start
** To generate coredump start postgres with `-c` option
4) Detailed steps that need to be executed for Postgre SQL installation from Binaries can be found here:
https://confluence.percona.com/pages/viewpage.action?pageId=42206890
Notes;
** Report PostgeSQL bugs here : https://www.postgresql.org/account/submitbug/