Manually Setting Up PostgreSQL

  1. When installing, I'd suggest some place outside program files to make editing of the configs easier. I use C:\Postgresql\10\.
  2. Make sure you save the password you choose when installing it. Don't use a secure password since it may be seen by other developers. Also keep in mind that this is a development machine which won't be storing sensitive data. I often use 123456 for development machines.
  3. When asked for the default locale choose C.
  4. After installation, start PgAdmin 4, connect to your server instance and run this sql statement CREATE ROLE candleapi WITH CREATEDB LOGIN PASSWORD 'candleadmin';