how to start server -> docker / docker-compose

[TheFern2]

I installed postgres and created a stories db. User fernandob has superuser privileges.
I created github OAuth and placed those inside .env

   Name    |   Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+-----------+----------+-------------+-------------+-----------------------
 fernandob | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres  | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 stories   | fernandob | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |           |          |             |             | postgres=CTc/postgres
 template1 | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |           |          |             |             | postgres=CTc/postgres

stories=# \conninfo
You are connected to database "stories" as user "fernandob" via socket in "/var/run/postgresql" at port "5432".

Running dev, I've changed db creds on .env, but I am not so sure if those are needed as it does the same thing. I had fernandob as a default user without password, and then I set a password too, but same outcome.

[INFO] 19:32:16 ts-node-dev ver. 1.0.0 (using ts-node ver. 9.0.0, typescript ver. 4.0.5)
about to connect to db, host:  ignore
(node:1212232) UnhandledPromiseRejectionWarning: error: password authentication failed for user "fernandob"

Is there any other info I need to put on .env to connect to stories db?

[benawad]

If you have a different user/password than postgres postgres then you'll need to pass it in here: https://github.com/benawad/vscode-stories-api/blob/master/src/index.ts#L39

[TheFern2]

Thanks, I should have read typeorm docs, but yeah that worked!

I had a default postgres install on Linux, and initially I had created stories db with postgres role, but when trying to run the server it looks like it always wants to connect with the user you're logged in. Unless there's a way to make another user default when you're logged in.

Would it make sense to change prodCredentials to just credentials? And just read db variables from .env at all times? Or is that too much hassle? That way I don't have to change index.ts and use my .env.

[benawad]

Yeah that's probably better

[resparzasoto]

@TheFern2 that's make sense, sounds better. You also can run a docker container with pgsql, is the most easy way, for this reason i added the port to connection.

[TheFern2]

@resparzasoto I should probably try to setup docker for this. Good suggestion!