Server can't find config file

Local Setup
,
7

After doing some research and from this post, figured whats actually data path for volume and its corresponding usage. Now our config file is read but still facing issue with path for logger in config file.
my_config.yml is

name: nakama-node-1
data_dir: "./data/"

logger:
    stdout: false
    level: "warn"
    file: "/tmp/path/to/logfile.log"

and console prints
error: /tmp/path/to/logfile.log : no such file or directory

also if we remove this logger section, then we ended up in another issue like
{"level":"fatal","ts":"2021-08-24T09:03:43.438Z","caller":"main.go:262","msg":"Error pinging database","error":"dial tcp 127.0.0.1:26257: connect: connection refused"}