[xwiki-users] Postgresql Dump
I am attempting to follow the backup instructions but no matter what I do all connections to the database fail with the following error, or similar: pg_dump: [archiver (db)] connection to database "xwiki" failed: FATAL: Peer authentication failed for user “xwiki" I have double checked the username and password in provided in the hibernate.cfg.xml file. Is there a connection permission issue I am missing? Reagards, Jesse
So I found a workaround to this issue by switching to the Postgres user. I am not sure if this normal or appropriate but just preface all postgresql commands with: sudo -u postgres <command> Regards, Jesse
On Feb 8, 2017, at 8:58 AM, "[email protected]" <[email protected]> wrote:
I am attempting to follow the backup instructions but no matter what I do all connections to the database fail with the following error, or similar:
pg_dump: [archiver (db)] connection to database "xwiki" failed: FATAL: Peer authentication failed for user “xwiki"
I have double checked the username and password in provided in the hibernate.cfg.xml file. Is there a connection permission issue I am missing?
Reagards,
Jesse
participants (2)
-
Jesse Bright -
jesse@abrightfamily.com