Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- export PATH=/usr/pgsql-9.3/bin:$PATH
- export PGDATA=/dev/shm/pg_data
- export PGUSER=postgres
- export PGPORT=5433
- mkdir $PGDATA
- initdb -U postgres -D $PGDATA
- sed -i -e 's/#port = 5432/port = '"$PGPORT"'/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#fsync = on/fsync = off/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#synchronous_commit = on/synchronous_commit = off/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#full_page_writes = on/full_page_writes = off/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#random_page_cost = 4.0/random_page_cost = 1.0/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#wal_level = minimal/wal_level = archive/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#archive_mode = off/archive_mode = on/g' "$PGDATA"/postgresql.conf
- sed -i -e 's/#archive_command = '"''"'/archive_command = '"'true'"'/g' "$PGDATA"/postgresql.conf
- cd "$PGDATA"
- nohup postgres -D "$PGDATA" </dev/null >> "$PGDATA"/server.log 2>&1 </dev/null &
- sleep 4
- echo 'CREATE EXTENSION adminpack;' | psql postgres >> "$PGDATA"/serversetup.log 2>&1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement