zivanovicb

# auto detects a good number of processes to run
worker_processes auto;

#Provides the configuration file context in which the directives that affect connection processing are specified.
events {
    # Sets the maximum number of simultaneous connections that can be opened by a worker process.
    worker_connections 8000;
    # Tells the worker to accept multiple connections at a time
    multi_accept on;
}

zivanovicb

sudo chown -R postgres:postgres /var/lib/postgres/

sudo mkdir /run/postgresql
sudo chown postgres:postgres /run/postgresql

sudo -iu postgres
pg_ctl -D /var/lib/postgres/data -l logfile start

zivanovicb

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

1. brew doctor
2. brew update

zivanovicb

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

zivanovicb

const mapStateToProps = (state, { data }) => {
  return {
    data: IpqsSelectors.selectLastEntry(state),
    isRequestingOne: !!RequestSelectors.selectInProgress(state, [IpqsAction.GET_ONE.REQUEST])
  }
}

const mapDispatchToProps = (dispatch) => ({
  requestOne: async (email) => dispatch(IpqsAction.requestOne(email))
})