I am using confluence server 6.1 w/ PostgreSQL as database. Now here is my config file related to the SQL db.
Now I would like to use my own username to do pq_dump or any other psql command.
<myownusername>@localhost ~$ psql --username=postgres -W "pg_dump confluence > ~/conf.back"
Password for user postgres: (I typed in "Pa33word" as above config shown)
psql: FATAL: Peer authentication failed for user "postgres"
Can you please let me know why I got this error and how should I resolve this?
I actually figured this out myself, need to change "peer" to "md5" in pg_hda.conf file for PostgreSQL.
However, one more question, when I run
psql --username=postgres -W "pg_dump confluence > conf.back" and typed in the password for postgres, it gives me
psql: FATAL: database "pg_dump confluence > conf.back" does not exist
Can you tell me how to write all pg_dump command line into one line with psql command? also how to put password inline so that I can run all this from a bash automatically?
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork? We've compiled a list here, along with...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG