cant connect to pg locally

Question

so im trying to connect to my postgres server locally from a python script using `asyncpg.create_pool`
this has always worked for me in the past but its not working this time for some reason.
```py
    async with asyncpg.create_pool(database=os.environ.get('PGDATABASE'),
                                   host=os.environ.get('PGHOST'),
                                   user=os.environ.get('PGUSER'),
                                   password=os.environ.get('PGPASSWORD'),
                                   port=os.environ.get('PGPORT')) as psql:```
the env variables are all present.
i get `socket.gaierror: [Errno 11001] getaddrinfo failed`. if you want me to send full traceback i can do that ig.
it works fine on railway idk it just doesnt work on *my* computer.
the env variables for the project on railway are variable references, and ive copied *those* to the local env file
`project id: 1dfc4bb8-37ce-4e09-9723-387fa3324724`