1 Topic by g40

  • g40
  • Member
  • Offline
  • Registered: 2017-01-05
  • Posts: 17

Topic: PostgreSQL access

==== Required information ====
- iRedMail version v0.9.6
- Linux/BSD Ubuntu 16.04.2 LTS
- PGSQL
- Apache
- No
====

Am trying to access vmail database to add some forwarding rules. psql  is refusing to let me connect claiming 'password authentication failed for user "postgres"'.

Any thoughts on the best way to proceed? Will the recovery procedure outlined here (https://stackoverflow.com/questions/174 … r-user-dev) mess up the rest of the working perfectly installation?

TAIA

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,163

Re: PostgreSQL access

If you're root user, switch to 'postgres' user, then run 'psql -d vmail' directly:

su - postgres
psql -d vmail

3 Reply by g40

  • g40
  • Member
  • Offline
  • Registered: 2017-01-05
  • Posts: 17

Re: PostgreSQL access

Thanks but I get the same:

~$ su - postgres
Password:
su: Authentication failure

I can only think that the password is not what I believe it to be?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,163

Re: PostgreSQL access

Switch to "root" user first, then "postgres".

5 Reply by g40

  • g40
  • Member
  • Offline
  • Registered: 2017-01-05
  • Posts: 17

Re: PostgreSQL access

ZhangHuangbin wrote:

Switch to "root" user first, then "postgres".

Excellent. Thank you for the help. Enjoy coffee.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,163

Re: PostgreSQL access

Thank you for the coffee. smile