There are two problems:
COPY writes to a file on the database server.
If you want to write to a file on the client machine, use
\copy which runs
COPY ... TO STDOUT under the hood.
You cannot specify a host and user name in the file name in the hope that the file will be transferred to another machine. It has to be a path on the file system (for
COPY, it has to be an absolute path on the server's file system, hence the error message).
psql on the machine where you want the file to end up and use
\copy finance.coa to '/home/kedarisettyakhiles/akki.csv' (FORMAT 'csv', DELIMITER ',', HEADER)