How to access indico data

Administrators
1

I want to acces postgresql database which was created during process of configuration of indico . I have tried following command

root@personalPC:/opt/indico/etc# psql -h localhost -U indico -W -d indico -p 5432
Password:
psql: error: connection to server at “localhost” (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user “indico”
connection to server at “localhost” (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user “indico”

My objective is to write a crontab to take database backup on regular interval.

Please help

2

Just psql indico. Don’t try specifying a hostname, password, etc. Postgres uses a unix socket by default where the server knows the system user from which the connection comes. Obviously that does not work if you use a TCP/IP connection (for that you’d need to assign a password to the user).

Also, don’t do it as root but as the indico user!

3

Thank you this is working

4

I am able to login and use and see the details.but how to take backup. Can you help me with command

5

pg_dump is your friend. When you search for it here in the forum, you’ll find e.g. this thread with a complete command.

6

Thank you and I am able to take backup