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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.