search

canonical / postgresql-operator

A Charmed Operator for running PostgreSQL on machines
https://charmhub.io/postgresql
Apache License 2.0
8 stars 19 forks source link

psql cannot write to .psql_history #595

Open jakobilobi opened 3 months ago

jakobilobi commented 3 months ago

Hi there, Thanks for building a great charm, this is the first time I ever had any issue and it's even a quite minor thing at that. Cheers

Steps to reproduce

  1. juju ssh <postgres machine>
  2. Access database via psql
  3. run some queries or something
  4. Exit psql
  5. Message appears in console: could not save history to file "/home/ubuntu/.psql_history": Permission denied

Expected behavior

psql saves the command history so that it can be accessed in subsequent sessions.

Actual behavior

The message appears, no history is saved.

Versions

Operating system: Ubuntu 22.04.4 LTS

Juju CLI: 3.5.3-genericlinux-amd64

Juju agent: 3.3.5

Charm revision: 363 (channel 14/stable)

LXD: 6.1

Log output

Juju debug log: no relevant Juju debug log messages

Additional context

There is of course a possibility that this issue is due to something other than the charm itself, though we haven't really made any post-deploy configurations or installs on the machine/app.

syncronize-issues-to-jira[bot] commented 3 months ago

Thank you for reporting us your feedback!

The internal ticket has been created: https://warthogs.atlassian.net/browse/DPE-5263.

This message was autogenerated

marceloneppel commented 2 months ago

Hi, @jakobilobi! Thanks for the feedback and the bug report.

I'm working on a fix for that through https://github.com/canonical/charmed-postgresql-snap/pull/50.