bradkrane

#Roll then connect to VM

passwd                       # always change root
apt update
apt install aptitude
aptitude                     # install security updates
apt install fail2ban firehol unattended-upgrades apt-listchanges sudo
apt install postgres ruby git emacs

adduser brad

bradkrane

Setup psql 12.0 on Windows 10

• No password localhost windows users
• Usefull for on the command line: type <some_file>.psql | psql
• Windows Binary 12.X as of writing https://www.postgresql.org/download/
• Remember the postgress password for the step when opening pgAdmin later

Default install path: C:\Program Files\PostgreSQL\12\

Add pgsql path to command line

bradkrane

#hostname:port:database:username:password
localhost:5432:postgres:postgres:01234567989

bradkrane

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a complete description of this file.  A short
# synopsis follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of these forms:

bradkrane