Confluence backup issue

bfang711

hi,

I am using confluence server 6.1 w/ PostgreSQL as database. Now here is my config file related to the SQL db.

<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.connection.isolation">2</property>
<property name="hibernate.connection.password">Pa33word</property>
<property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/confluence</property>
<property name="hibernate.connection.username">postgres</property>

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?

 

thank you.

bfang711

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?

thank you.