Установка PostgreSQL в Debian 8/9

----------install in debian 8:-----------
sudo apt-get update
sudo apt-get install postgresql-9.4 postgresql-client-9.4 postgresql-doc php5-pgsql;
OR for deb 9:
sudo apt-get install postgresql postgresql-client postgresql-doc php-pgsql;
sudo sudo php5enmod pgsql;
OR for deb9:
sudo sudo phpenmod pgsql
#select 'I have one database user: postgres' AS "First Assertion";
sudo passwd postgres
AND add simple-non-admin-user:
sudo useradd -m postgreuser
sudo passwd postgreuser
su - postgreuser psql
#createdb blog:
sudo service postgresql status
sudo update-rc.d postgresql disable
sudo cp /etc/postgresql/9.4/main/start.conf{,.original}
sudo cp /etc/postgresql/9.4/main/pg_hba.conf{,.original}
sudo vim /etc/postgresql/9.4/main/pg_hba.conf
!!!изменяем значения peer и ident (md5, password, etc...) на trust!!!
sudo service postgresql restart
psql -U postgres
!!!Ready run psql for current user!!!
postgres=# ALTER USER postgres WITH PASSWORD 'pass_to_postgresql';/*change password for user postgres!!!*/
sudo service --status-all | grep postgresql
sudo tail -f /var/log/postgresql/postgresql-9.4-main.log
sudo /usr/sbin/update-rc.d postgresql disable
root# mkdir /usr/local/pgsql
root# chown postgreuser /usr/local/pgsql
root# su -l postgres
postgres$ psql
#
READY!!!
----------Setup 9.6 version:--------------------------
sudo -s
> /etc/apt/sources.list.d/postgresql.list
echo 'deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main' >> /etc/apt/sources.list.d/postgresql.list
wget --no-check-certificate -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O- | apt-key add -
apt-get update && apt-get install postgresql-9.6
su - postgres
psql
Либо:
sudo -u postgres psql
ALTER USER postgres WITH PASSWORD 'pass_to_postgres';/*!!!need change password for user postgres!!!*/
CREATE USER myuser WITH PASSWORD 'StorngPasswordHere';
CREATE DATABASE recipe WITH OWNER recipe;
GRANT ALL PRIVILEGES ON DATABASE recipe to myuser;
\q
exit
psql -h localhost -U myuser -W -d mybase
------------Postgres-10 in Debian9.5(x64) from root:------------------------------
> /etc/apt/sources.list.d/pgdg.list
vim /etc/apt/sources.list.d/pgdg.list
>>>>>>>>>>>>file:>>>>>>>>>>>
# for strech:
deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main
<<<<<<<<<