[Docs: Install from Package Guide] Not working Postgresql statements in Backend.AI Manager Part

[studioego]

[Docs: Install from Package Guide] Not working Postgresql statements in Backend.AI Manager Part

[studioego]

Hmm, I checked backend.ai mgr dbshell command options.

bai@dhsung:~/manager$ backend.ai mgr dbshell --help
Usage: backend.ai mgr dbshell [OPTIONS] [PSQL_ARGS]...

  Run the database shell.

  All additional arguments and options except `--psql-container` and `--psql-
  help` are transparently forwarded to the psql command. For instance, you can
  use `-c` to execute a psql/SQL statement on the command line.

  Note that you do not have to specify connection-related options because the
  dbshell command fills out them from the manager configuration.

Options:
  --psql-container ID_OR_NAME  Open a postgres client shell using the psql
                               executable shipped with the given postgres
                               container. If not set or set as an empty string
                               "", it will auto-detect the psql container from
                               the halfstack. If set "-", it will use the
                               host-provided psql executable. You may append
                               additional arguments passed to the psql cli
                               command. [default: auto-detect from halfstack]
  --psql-help                  Show the help text of the psql command instead
                               of this dbshell command.
  -h, --help                   Show this message and exit.
bai@dhsung:~/manager$ backend.ai mgr dbshell --psql-container postgres-cluster-default-backendai-pg-active-1
2024-04-24 15:59:58.990 INFO ai.backend.manager.cli [2551136] using the db container postgres-cluster-default-backendai-pg-active-1 ...
psql (15.1)
Type "help" for help.

backend=#

I think that after checking docker's postgres container name, I have to enter backend.ai mgr dbshell command with --psql-container ID_OR_NAME option.

As a result, I'll have to revise the install from package guide.