Page 1 of 1
[SOLVED] Wapt 1.5 backup
Published: February 19, 2018 - 10:48 AM
by 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.
Re: backup wapt 1.5
Published: February 26, 2018 - 10:42 PM
by dcardon
Hello guigeek,
guigeek wrote: ↑Feb 19, 2018 - 10:48 AM
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
Re: backup wapt 1.5
Published: February 27, 2018 - 9:31 PM
by 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...?
dcardon wrote: ↑Feb 26, 2018 - 10:42 PM
Hello guigeek,
guigeek wrote: ↑Feb 19, 2018 - 10:48 AM
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
Re: backup wapt 1.5
Published: March 1, 2018 - 12:31
by dcardon
Hello guigeek,
Yes, there was a typo in the documentation. I've made some corrections. Could you please try again? Thank you
Denis
[SOLVED] Wapt 1.5 backup
Published: March 2, 2018 - 12:44 PM
by guigeek
Yes, yes, I corrected my script, it works fine.
Thank you.