Hello guys,
I am user whm with a cpanel account for my system.
is done in php and uses the postgresql database 9.4
My question is how many backups of postgresql ... there are several databases, 1 for each client.
However when I run pg_dump I get the psql error: 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"?
I've tried several mutes but it did not work.
Question 1) I saw that there is a tool called Backup Configuration, with settings for Mysql.
The question is: using the WHM backup tool will you also make backups of the postresql databases?
Question 2) How do I use pg_dump?
In the other hosting I simply ran the .sh cron below
cd ~ / BACKUPS_BANCOS /
PGPASSWORD = "pass" pg_dump -i - column-inserts database_datas> database_dates "` date '+% d% m% Y% H% M'` ".sql -U systempizzar --no-owner
Anyway, I would like to have automated postgresql backups.
At first I thought a pg_dump would not give as much headache;
Thank you all
I am user whm with a cpanel account for my system.
is done in php and uses the postgresql database 9.4
My question is how many backups of postgresql ... there are several databases, 1 for each client.
However when I run pg_dump I get the psql error: 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"?
I've tried several mutes but it did not work.
Question 1) I saw that there is a tool called Backup Configuration, with settings for Mysql.
The question is: using the WHM backup tool will you also make backups of the postresql databases?
Question 2) How do I use pg_dump?
In the other hosting I simply ran the .sh cron below
cd ~ / BACKUPS_BANCOS /
PGPASSWORD = "pass" pg_dump -i - column-inserts database_datas> database_dates "` date '+% d% m% Y% H% M'` ".sql -U systempizzar --no-owner
Anyway, I would like to have automated postgresql backups.
At first I thought a pg_dump would not give as much headache;
Thank you all