[SOLVED] Wapt 1.5 backup

[guigeek]

Hi,
I'm having trouble backing up my WAPT server (version 1.5), specifically with the database dump:

postgres@waptsrv:~$ pg_dumpall > sauvegarde_wapt.sql
pg_dumpall: could not connect to database "template1": could not connect to server: No such file or directory.
Is the server running locally and accepting
connections on the Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Any ideas?
Thanks.

[dcardon]

Hello guigeek,

Hi,
I'm having trouble backing up my Wapt server (version 1.5), specifically with the database dump:

postgres@waptsrv:~$ pg_dumpall > sauvegarde_wapt.sql
pg_dumpall: could not connect to database "template1": 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"?

The dump must be done as a postgres file. That should work.

Is the PostgreSQL database properly started?

The message is usually either a permissions problem, but here it is indeed the postgres user who is launching the command, or a problem that the process is not running.

You haven't made any particular changes to the /etc/postgresql/9.6/main/postgresql.conf file?

Code: Select all

ps -edf | grep postgres
systemctl restart postgresql
sudo -u postgres pg_dumpall > /tmp/pgdump_20180226.sql

Denis

[guigeek]

Hi,
Thanks for the reply. I don't know if I misunderstood or if it's poorly explained, but in the documentation:
https://www.wapt.fr/wapt-1.5/waptserver_backup.html
I understand that I need to stop the PostgreSQL database and then dump it...?

Hello guigeek,

Hi,
I'm having trouble backing up my Wapt server (version 1.5), specifically with the database dump:

postgres@waptsrv:~$ pg_dumpall > sauvegarde_wapt.sql
pg_dumpall: could not connect to database "template1": 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"?

You need to perform the dump as the postgres user. That should work. Is the PostgreSQL database running correctly? The message usually indicates either a permissions issue, but in this case, the postgres user is running the command, or a problem with the process not running. Have you made any specific changes to the /etc/postgresql/9.6/main/postgresql.conf file?
ps -edf | grep postgres
systemctl restart postgresql
sudo -u postgres pg_dumpall > /tmp/pgdump_20180226.sql

Denis

[dcardon]

Hello guigeek,

Thanks for the reply. I don't know if I misunderstood or if it's poorly explained, but in the documentation:
https://www.wapt.fr/wapt-1.5/waptserver_backup.html
I understand that I need to stop the PostgreSQL database and then dump it...?

Yes, there was a typo in the documentation. I've made some corrections. Could you please try again? Thank you

Denis

[guigeek]

Yes, yes, I corrected my script, it works fine.
Thank you.