Aleksey Kazakov Dezinger

Dezinger / search-poccess.shell

Created November 6, 2013 18:58

search poccess

ps -ax | grep post

Dezinger / postgres-server.bash

Last active May 17, 2020 18:35

Manage postgres server

	# Fast server stop
	sudo -u postgres /usr/pgsql-9.1/bin/pg_ctl -D /var/lib/pgsql/9.1/data stop -m fast

	# To create a database instance, after install do
	sudo mkdir -p /opt/local/var/db/postgresql93/defaultdb
	sudo chown postgres:postgres /opt/local/var/db/postgresql93/defaultdb
	sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb -D /opt/local/var/db/postgresql93/defaultdb'
	#или
	sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb --locale=ru_RU.UTF-8 --lc-collate=ru_RU.UTF-8 --lc-ctype=ru_RU.UTF-8 --encoding=UTF8 -D /opt/local/var/db/postgresql93/localdb'