psql cannot write to .psql_history

[jakobilobi]

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]

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]

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

I'm working on a fix for that through canonical/charmed-postgresql-snap#50.