I have Nakama server installed on my mac via docker. I used ‘cockroach sql --insecure’ to handle Nakama’s Database on my system without any issues.
I wanted to have the same set-up on an AWS linux instance.I successfully installed Nakama on AWS instance but when I tried to access the database by typing ‘cockroach sql --insecure’ command as I did on my mac pc I am got the error that
’-bash: /usr/local/bin/cockroach: No such file or directory’
and when I installed cockroach db after that and ran the same command ‘cockroach sql --insecure’ I got the following error
#Welcome to the cockroach SQL interface.
#All statements must be terminated by a semicolon.
#To exit: CTRL + D.
Error: pq: unknown variable: "sql_safe_updates"
Failed running “sql”
How can I solve this issue?