Advertisement
Guest User

PostgreSQL In Memory Database Script

a guest
Jul 30th, 2014
242
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. export PATH=/usr/pgsql-9.3/bin:$PATH
  2. export PGDATA=/dev/shm/pg_data
  3. export PGUSER=postgres
  4. export PGPORT=5433
  5. mkdir $PGDATA
  6. initdb -U postgres -D $PGDATA
  7.  
  8. sed -i -e 's/#port = 5432/port = '"$PGPORT"'/g' "$PGDATA"/postgresql.conf
  9.  
  10. sed -i -e 's/#fsync = on/fsync = off/g' "$PGDATA"/postgresql.conf
  11. sed -i -e 's/#synchronous_commit = on/synchronous_commit = off/g' "$PGDATA"/postgresql.conf
  12. sed -i -e 's/#full_page_writes = on/full_page_writes = off/g' "$PGDATA"/postgresql.conf
  13. sed -i -e 's/#random_page_cost = 4.0/random_page_cost = 1.0/g' "$PGDATA"/postgresql.conf
  14.  
  15. sed -i -e 's/#wal_level = minimal/wal_level = archive/g' "$PGDATA"/postgresql.conf
  16. sed -i -e 's/#archive_mode = off/archive_mode = on/g' "$PGDATA"/postgresql.conf
  17. sed -i -e 's/#archive_command = '"''"'/archive_command = '"'true'"'/g' "$PGDATA"/postgresql.conf
  18.  
  19. cd "$PGDATA"
  20. nohup postgres -D "$PGDATA" </dev/null >> "$PGDATA"/server.log 2>&1 </dev/null &
  21. sleep 4
  22. echo 'CREATE EXTENSION adminpack;' | psql postgres >> "$PGDATA"/serversetup.log 2>&1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement