We are following the steps for upgrade from 6.1.0 to 7.1.0 using this link:
As per the command:
pg_dump --username=postgres jasperserver > js-db-dump.sql
We received an error message:
pg_dump: [archiver (db)] connection to database "jasperserver" failed: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
To get rid of ths error tried the following command for backup:
pg_dump jasperserver -U jasperdb -h localhost > js-db-dump-13FEB2020.sql
Although when jasperserver started using ctlscript.sh and showed that postgresql started on port 5433, I'm getting the following error message for the backup comand shown above:
connection to database "jasperserver" failed: could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
How to resolve this?
Thanks in advance for your help.
The error represents a connection problem to the postgres database.
So it is essential to firstly know whether the postgres is running and on what port number (default port is 5432).
Once you know this information, you can use this to force the connection with extra parameters passed with the pg_dump command :
You can use this postgres command line reference as a guide:
If it is still an issue and the error that you are getting remains EXACTLY the same then probably there is an incorrect path to socket. Backup tried to connect to /var/run/postgresql/.s.PGSQL.5432 but it does not exist. You can check this article:
to check for the location of the socket file and verify the config files pg_hba.conf and postgresql.conf accordingly.
There are a few comments that mentions to check for unix_socket_directories parameter setting.
I also recommend to check the for this setting as well:
listen_addresses = '*'