Hello
hackers,
User can pass session-level settings as a parameter in the connection string like:
psql "host=localhost user=postgres options='-c synchronous_commit=off'"
Which sets the synchronous_commit off for the session.
However, URI spec is not allowing it,
psql postgresql://postgres@localhost:5432/postgres?options="-c synchronous_commit=off"
psql: error: could not connect to server: extra key/value separator "=" in URI query parameter: "options"
psql postgresql://postgres@localhost:5432/postgres?options="-c synchronous_commit off"
psql: error: could not connect to server: FATAL: -c synchronous_commit requires a value
Moreover session just hangs forever:
psql postgresql://postgres@localhost:5432/postgres?application_name=hello&options='-c synchronous_commit=off'
provided that the connection works without the 'options' parameter specification
Thanks and regards,
Jobin.