Manually Setting Up PostgreSQL
- When installing, I'd suggest some place outside program files to make editing of the configs easier. I use C:\Postgresql\10\.
- 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.
- When asked for the default locale choose C.
- After installation, start PgAdmin 4, connect to your server instance and run this sql statement CREATE ROLE candleapi WITH CREATEDB LOGIN PASSWORD 'candleadmin';