Postgresql password lost

[details=“Postgresql user password lost”]

Hello Everybody,

I am running a Nextcloud 17 VM using Postgresql database.
Database username is postgres,
I lost the password generated for user postgres at install time.
Now I need it to set up a backup script so I need to know the related password.
is it safe to change the password for user postgres (e.g. by the related webmin module)?
If yes, should I modify some other config file?

Best regards

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face: is for home/non-enterprise users. If you’re running a business, paid support can be accessed via where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:


Or for longer, use three backticks above and below the code snippet:


Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 12.0.2):
Operating system and version (eg, Ubuntu 17.04):
Apache or nginx version (eg, Apache 2.4.25):
PHP version (eg, 7.1):

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N):

Steps to replicate it:

The output of your Nextcloud log in Admin > Logging:


The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):


The output of your Apache/nginx/system log in /var/log/____:


if nextcloud is still working you’ll find the db credentials in .../nextcloud/config/config.php

Yes, problem solved, thank you!