n31k

After migration: FATAL: role "postgres" does not exist

Recommended Posts

Hey,

 

I had some troubles with my array so I did some manual assembly using mdadm.

After that diskstation needed to migrate (keeping all my data and settings) so I did that.

Now everything is quite alright but I noticed that apps that need postgres do not work (mediaserver, downloadstation...).

After some digging I found that /var/log/postgres.log is spammed with 'FATAL:  role "postgres" does not exist '.

Trying to find out what exactly is wrong since "psql -U postgres" gives me the same error.

I tried all the usual logins (root, admin, mediaserver) and all ends with same message.

User postgres is correctly defined in /etc/passwd...

 

Seems to me that "postgres" user is simply not there and and I can't even create it.

Any ideas what to do? I will post in postgres forum - just thought I try this one first.

 

Thanks for any pointers!

 

Share this post


Link to post
Share on other sites

You could try deleting/uninstalling packages that use it and see if reinstalling resets the database/user accounts.

I wonder if its possible that when you were recovering your array some of the commands from that process might have changed accounts or folder ownership etc

 

Lots of internet threads about this error message, maybe this one may help

https://github.com/PostgresApp/PostgresApp/issues/313

 

Share this post


Link to post
Share on other sites

I already tried reinstalling packages and it didn't help :(

Same with googling around...

 

The link mentioned either uses user "postgres" that I am missing or

suggest to delete some files which I would like to avoid in order not to 

cause any more damage.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now