sudo apt-get install python3
sudo add-apt-repository ppa:git-core/ppa
sudo apt-get update
sudo apt-get install git
sudo nano /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt/ artful-pgdg main
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6
sudo -u postgres psql
\conninfo
\q
sudo nano /etc/postgresql/9.6/main/pg_hba.conf
sudo nano /etc/postgresql/9.6/main/postgresql.conf
sudo service postgresql restart
sudo su - postgres
psql
\password
p0stgr3s
sudo -u postgres createuser --interactive
imdbsurfer
n
n
n
sudo adduser imdbsurfer
1mdbsurf3r
1mdbsurf3r
IMDb Surfer Database User
[enter]
[enter]
[enter]
[enter]
Y
sudo -u postgres createdb imdbsurfer --owner=imdbsurfer
sudo -u imdbsurfer psql
\conninfo
\q
sudo adduser postgres
sudo passwd postgres
p0stgr3s
sudo adduser imdbsurfer
sudo passwd imdbsurfer
1mdbsurf3r
wget https://bootstrap.pypa.io/get-pip.py
chmod +x get-pip.py
./get-pip.py
git clone https://github.com/viniciusmayer/imdbsurfer.git
virtualenv -p python3 imdbsurfer
cd imdbsurfer
source bin/activate
pip install scrapy
pip install psycopg2-binary
git config --global user.email "[email protected]"
git config --global user.email "Vinicius Mayer"
docker network create --driver bridge postgres-network docker run --name postgres-database -p 5432:5432 --network=postgres-network -e POSTGRES_PASSWORD=p0stgr3s -d postgres docker run --name postgres-admin --network=postgres-network -p 15432:80 -e "PGADMIN_DEFAULT_EMAIL=[email protected]" -e "PGADMIN_DEFAULT_PASSWORD=pg4dm1n" -d dpage/pgadmin4