apache2 python wsgi install compile

1)  wget https://github.com/GrahamDumpleton/mod_wsgi/archive/4.7.1.tar.gz
2) apt update
3) apt install  apache2-dev
4)  ./configure --with-apxs=/usr/bin/apxs   --with-python=/usr/bin/python3.5
5) make
6) make install
7) ls /etc/apache2/mods-enabled/wsgi.conf
ls /etc/apache2/mods-enabled/wsgi.load
ls -al /usr/lib/apache2/modules/mod_wsgi.so

8) service apache2 start

POSTGRES manipulation

простые манипуляции Postgres
\l  - просмотр баз
\c - connect to database
\db - посмотреть таблицы

CREATE DATABASE name;
CREATE DATABASE dbname OWNER rolename;DROP DATABASE name;

Создать таблицу
CREATE TABLE <table-name> ( <column name> <data type>[(<size>)], <column name> <data type>[(<size>)] ... );
например
create table table1 ( name char(10), age integer);

CREATE INDEX <index name> ON <table name> (<column name> [,<column name>]...);
CREATE INDEX Clientgroup ON Customers (snum);
DROP INDEX <Index name>;
Вставить данные
INSERT INTO products VALUES (1, 'Cheese', 9.99);

Задачи: пример1

 таб1

 name       | age
------------+-----
 vasya      | 18
 kolya      | 20
 ivan       | 23

таб2

name        | surname
------------+------------
 vasya      | pupkin
 kolya      | morozov
 ivan       | grozniy

select * from table2 inner join table1 on (table1.name=table2.name) where age=(select min(age) from table1);

 аналогично

select * from table1,table2 where (table1.name=table2.name) and age=(select min(age) from table1);

Выполнение внешней комманды


su - postgres -c psql << __EOF__
CREATE DATABASE noc WITH OWNER=noc ENCODING='SQL_ASCII';
__EOF__