Cannot create warehouse

[JosueLugaro]

I'm using WSL2 with Ubuntu 20.04.6 and have installed all prerequisites.

I followed the README up to the just restart command under the "Create virtual environment and start postgres docker". When I ran the just restart command I got this error (1). I took a look at the justfile in an attempt to debug and tried to run just up to see if that would remedy the issue since this would create the postgres container that wasn't found when running just restart. Although after running just up the postgres container was created but I ran into this error (2). I tried running just restart after just up to see what would happen and ran into this error (3) which has the same cause as the second error I mentioned. Postgres is running locally on port 5432 but there is no database or user named "dbt". I'm not sure if I'm supposed to create them or if a step in the instructions is meant to?

1:

rm -rf /raw_data/*
rm -rf ./sde_dbt_tutorial/target
just down
docker stop postgres && docker rm postgres
Error response from daemon: No such container: postgres
error: Recipe `down` failed on line 147 with exit code 1
error: Recipe `restart` failed on line 152 with exit code 1

2:

just start-db
docker run -d --name postgres -e POSTGRES_USER=dbt -e POSTGRES_PASSWORD=password1234 -e POSTGRES_DB=dbt -v $(pwd)/raw_data:/input_data -v $(pwd)/warehouse_setup:/docker-entrypoint-initdb.d -p 5432:5432 postgres:16
59c54ebecfa88a6e83109a36038164095e9795c6d53bbde22e206d2ba8c9917e
just deps
dbt deps
/home/josue/simple_dbt_project/.venv/lib/python3.12/site-packages/dateutil/tz/tz.py:37: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC).
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.MessageMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.ScalarMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
00:46:52  Running with dbt=1.7.4
00:48:53  Installing elementary-data/elementary
00:48:53  Installed from version 0.13.2
00:48:53  Updated version available: 0.14.1
00:48:53  Installing dbt-labs/dbt_utils
00:48:54  Installed from version 1.1.1
00:48:54  Up to date!
00:48:54  Installing calogica/dbt_expectations
00:48:55  Installed from version 0.9.0
00:48:55  Updated version available: 0.10.3
00:48:55  Installing calogica/dbt_date
00:48:55  Installed from version 0.8.1
00:48:55  Updated version available: 0.10.0
00:48:55
00:48:55  Updates available for packages: ['elementary-data/elementary', 'calogica/dbt_expectations', 'calogica/dbt_date']
Update your versions in packages.yml, then run dbt deps
just elem-tables
dbt run --select elementary
/home/josue/simple_dbt_project/.venv/lib/python3.12/site-packages/dateutil/tz/tz.py:37: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC).
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.MessageMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.ScalarMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
00:48:57  Running with dbt=1.7.4
00:48:58  Registered adapter: postgres=1.7.4
00:48:58  Found 37 models, 1 snapshot, 14 tests, 2 operations, 3 sources, 1 exposure, 0 metrics, 1369 macros, 0 groups, 0 semantic models
00:48:58
00:48:58
00:48:58  Finished running  in 0 hours 0 minutes and 0.04 seconds (0.04s).
00:48:58  Encountered an error:
Database Error
  connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "dbt"
  connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "dbt"

error: Recipe `elem-tables` failed on line 65 with exit code 2
error: Recipe `up` failed on line 137 with exit code 2

3:

just start-db
docker run -d --name postgres -e POSTGRES_USER=dbt -e POSTGRES_PASSWORD=password1234 -e POSTGRES_DB=dbt -v $(pwd)/raw_data:/input_data -v $(pwd)/warehouse_setup:/docker-entrypoint-initdb.d -p 5432:5432 postgres:16
f6a505eef6c7c9c0e89f173b5eb4f126a46d866cfcca2a18b0eaba65af5f1e1b
just deps
dbt deps
/home/josue/simple_dbt_project/.venv/lib/python3.12/site-packages/dateutil/tz/tz.py:37: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC).
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.MessageMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.ScalarMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
01:04:16  Running with dbt=1.7.4
01:04:17  Installing elementary-data/elementary
01:04:17  Installed from version 0.13.2
01:04:17  Updated version available: 0.14.1
01:04:17  Installing dbt-labs/dbt_utils
01:04:18  Installed from version 1.1.1
01:04:18  Up to date!
01:04:18  Installing calogica/dbt_expectations
01:04:20  Installed from version 0.9.0
01:04:20  Updated version available: 0.10.3
01:04:20  Installing calogica/dbt_date
01:04:20  Installed from version 0.8.1
01:04:20  Updated version available: 0.10.0
01:04:20
01:04:20  Updates available for packages: ['elementary-data/elementary', 'calogica/dbt_expectations', 'calogica/dbt_date']
Update your versions in packages.yml, then run dbt deps
just elem-tables
dbt run --select elementary
/home/josue/simple_dbt_project/.venv/lib/python3.12/site-packages/dateutil/tz/tz.py:37: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC).
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.MessageMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
<frozen importlib._bootstrap>:488: DeprecationWarning: Type google._upb._message.ScalarMapContainer uses PyType_Spec with a metaclass that has custom tp_new. This is deprecated and will no longer be allowed in Python 3.14.
01:04:22  Running with dbt=1.7.4
01:04:22  Registered adapter: postgres=1.7.4
01:04:22  Unable to do partial parsing because saved manifest not found. Starting full parse.
01:04:26  [WARNING]: Did not find matching node for patch with name 'non_existent_table' in the 'models' section of file 'models/marts/marketing/marketing.yml'
01:04:27  [WARNING]: Test 'test.sde_dbt_tutorial.unique_non_existent_table_non_existent.1fe469feba' (models/marts/marketing/marketing.yml) depends on a node named 'non_existent_table' in package '' which was not found
01:04:27  Found 37 models, 1 snapshot, 14 tests, 2 operations, 3 sources, 1 exposure, 0 metrics, 1369 macros, 0 groups, 0 semantic models
01:04:27
01:04:27
01:04:27  Finished running  in 0 hours 0 minutes and 0.05 seconds (0.05s).
01:04:27  Encountered an error:
Database Error
  connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "dbt"
  connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "dbt"

error: Recipe `elem-tables` failed on line 65 with exit code 2
error: Recipe `up` failed on line 137 with exit code 2