Do you have any backup files in /store/backups/postgresql?
Code: Select all
ls -l /store/backups/postgresql/*/*Code: Select all
ls -l /store/backups/postgresql/*/*Code: Select all
[root@iganagios ~]# ls -l /store/backups/postgresql/*/*
/store/backups/postgresql/daily/nagiosxi:
total 2020
-rw-r--r-- 1 root root 345309 Mar 2 07:00 nagiosxi_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 338199 Mar 3 07:00 nagiosxi_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 340648 Mar 5 07:00 nagiosxi_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 347035 Mar 6 07:00 nagiosxi_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 342085 Mar 7 07:00 nagiosxi_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 343241 Mar 8 07:00 nagiosxi_2017-03-08.Wednesday.sql.gz
/store/backups/postgresql/daily/postgres:
total 24
-rw-r--r-- 1 root root 416 Mar 2 07:00 postgres_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 414 Mar 3 07:00 postgres_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 414 Mar 5 07:00 postgres_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 414 Mar 6 07:00 postgres_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 415 Mar 7 07:00 postgres_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 417 Mar 8 07:00 postgres_2017-03-08.Wednesday.sql.gz
/store/backups/postgresql/daily/template1:
total 24
-rw-r--r-- 1 root root 452 Mar 2 07:00 template1_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 450 Mar 3 07:00 template1_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 450 Mar 5 07:00 template1_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 450 Mar 6 07:00 template1_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 451 Mar 7 07:00 template1_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 453 Mar 8 07:00 template1_2017-03-08.Wednesday.sql.gz
/store/backups/postgresql/monthly/nagiosxi:
total 7800
-rw-r--r-- 1 root root 18711 Nov 1 2014 nagiosxi_2014-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 44075 Dec 1 2014 nagiosxi_2014-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 94691 Jan 1 2015 nagiosxi_2015-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 191096 Feb 1 2015 nagiosxi_2015-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 176023 Mar 1 2015 nagiosxi_2015-03-01.March.nagiosxi.sql.gz
-rw-r--r-- 1 root root 291345 Apr 1 2015 nagiosxi_2015-04-01.April.nagiosxi.sql.gz
-rw-r--r-- 1 root root 265528 May 1 2015 nagiosxi_2015-05-01.May.nagiosxi.sql.gz
-rw-r--r-- 1 root root 239582 Jun 1 2015 nagiosxi_2015-06-01.June.nagiosxi.sql.gz
-rw-r--r-- 1 root root 240302 Jul 1 2015 nagiosxi_2015-07-01.July.nagiosxi.sql.gz
-rw-r--r-- 1 root root 234476 Aug 1 2015 nagiosxi_2015-08-01.August.nagiosxi.sql.gz
-rw-r--r-- 1 root root 374674 Sep 1 2015 nagiosxi_2015-09-01.September.nagiosxi.sql.gz
-rw-r--r-- 1 root root 214758 Oct 1 2015 nagiosxi_2015-10-01.October.nagiosxi.sql.gz
-rw-r--r-- 1 root root 266042 Nov 1 2015 nagiosxi_2015-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 234322 Dec 1 2015 nagiosxi_2015-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 328028 Jan 1 2016 nagiosxi_2016-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 296472 Feb 1 2016 nagiosxi_2016-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 339168 Mar 1 2016 nagiosxi_2016-03-01.March.nagiosxi.sql.gz
-rw-r--r-- 1 root root 312985 Apr 1 2016 nagiosxi_2016-04-01.April.nagiosxi.sql.gz
-rw-r--r-- 1 root root 330087 May 1 2016 nagiosxi_2016-05-01.May.nagiosxi.sql.gz
-rw-r--r-- 1 root root 421085 Jun 1 2016 nagiosxi_2016-06-01.June.nagiosxi.sql.gz
-rw-r--r-- 1 root root 321984 Jul 1 2016 nagiosxi_2016-07-01.July.nagiosxi.sql.gz
-rw-r--r-- 1 root root 311840 Aug 1 2016 nagiosxi_2016-08-01.August.nagiosxi.sql.gz
-rw-r--r-- 1 root root 325296 Sep 1 2016 nagiosxi_2016-09-01.September.nagiosxi.sql.gz
-rw-r--r-- 1 root root 320140 Oct 1 08:00 nagiosxi_2016-10-01.October.nagiosxi.sql.gz
-rw-r--r-- 1 root root 337783 Nov 1 08:00 nagiosxi_2016-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 344945 Dec 1 08:00 nagiosxi_2016-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 331124 Jan 1 07:00 nagiosxi_2017-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 356839 Feb 1 07:00 nagiosxi_2017-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 360610 Mar 1 07:00 nagiosxi_2017-03-01.March.nagiosxi.sql.gz
/store/backups/postgresql/monthly/postgres:
total 116
-rw-r--r-- 1 root root 425 Nov 1 2014 postgres_2014-11-01.November.postgres.sql.gz
-rw-r--r-- 1 root root 425 Dec 1 2014 postgres_2014-12-01.December.postgres.sql.gz
-rw-r--r-- 1 root root 424 Jan 1 2015 postgres_2015-01-01.January.postgres.sql.gz
-rw-r--r-- 1 root root 425 Feb 1 2015 postgres_2015-02-01.February.postgres.sql.gz
-rw-r--r-- 1 root root 422 Mar 1 2015 postgres_2015-03-01.March.postgres.sql.gz
-rw-r--r-- 1 root root 422 Apr 1 2015 postgres_2015-04-01.April.postgres.sql.gz
-rw-r--r-- 1 root root 420 May 1 2015 postgres_2015-05-01.May.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jun 1 2015 postgres_2015-06-01.June.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jul 1 2015 postgres_2015-07-01.July.postgres.sql.gz
-rw-r--r-- 1 root root 423 Aug 1 2015 postgres_2015-08-01.August.postgres.sql.gz
-rw-r--r-- 1 root root 426 Sep 1 2015 postgres_2015-09-01.September.postgres.sql.gz
-rw-r--r-- 1 root root 424 Oct 1 2015 postgres_2015-10-01.October.postgres.sql.gz
-rw-r--r-- 1 root root 425 Nov 1 2015 postgres_2015-11-01.November.postgres.sql.gz
-rw-r--r-- 1 root root 425 Dec 1 2015 postgres_2015-12-01.December.postgres.sql.gz
-rw-r--r-- 1 root root 424 Jan 1 2016 postgres_2016-01-01.January.postgres.sql.gz
-rw-r--r-- 1 root root 425 Feb 1 2016 postgres_2016-02-01.February.postgres.sql.gz
-rw-r--r-- 1 root root 422 Mar 1 2016 postgres_2016-03-01.March.postgres.sql.gz
-rw-r--r-- 1 root root 422 Apr 1 2016 postgres_2016-04-01.April.postgres.sql.gz
-rw-r--r-- 1 root root 420 May 1 2016 postgres_2016-05-01.May.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jun 1 2016 postgres_2016-06-01.June.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jul 1 2016 postgres_2016-07-01.July.postgres.sql.gz
-rw-r--r-- 1 root root 423 Aug 1 2016 postgres_2016-08-01.August.postgres.sql.gz
-rw-r--r-- 1 root root 426 Sep 1 2016 postgres_2016-09-01.September.postgres.sql.gz
-rw-r--r-- 1 root root 424 Oct 1 08:00 postgres_2016-10-01.October.postgres.sql.gz
-rw-r--r-- 1 root root 425 Nov 1 08:00 postgres_2016-11-01.November.postgres.sql.gz
-rw-r--r-- 1 root root 425 Dec 1 08:00 postgres_2016-12-01.December.postgres.sql.gz
-rw-r--r-- 1 root root 424 Jan 1 07:00 postgres_2017-01-01.January.postgres.sql.gz
-rw-r--r-- 1 root root 425 Feb 1 07:00 postgres_2017-02-01.February.postgres.sql.gz
-rw-r--r-- 1 root root 422 Mar 1 07:00 postgres_2017-03-01.March.postgres.sql.gz
/store/backups/postgresql/monthly/template1:
total 116
-rw-r--r-- 1 root root 462 Nov 1 2014 template1_2014-11-01.November.template1.sql.gz
-rw-r--r-- 1 root root 462 Dec 1 2014 template1_2014-12-01.December.template1.sql.gz
-rw-r--r-- 1 root root 461 Jan 1 2015 template1_2015-01-01.January.template1.sql.gz
-rw-r--r-- 1 root root 462 Feb 1 2015 template1_2015-02-01.February.template1.sql.gz
-rw-r--r-- 1 root root 459 Mar 1 2015 template1_2015-03-01.March.template1.sql.gz
-rw-r--r-- 1 root root 459 Apr 1 2015 template1_2015-04-01.April.template1.sql.gz
-rw-r--r-- 1 root root 457 May 1 2015 template1_2015-05-01.May.template1.sql.gz
-rw-r--r-- 1 root root 458 Jun 1 2015 template1_2015-06-01.June.template1.sql.gz
-rw-r--r-- 1 root root 458 Jul 1 2015 template1_2015-07-01.July.template1.sql.gz
-rw-r--r-- 1 root root 460 Aug 1 2015 template1_2015-08-01.August.template1.sql.gz
-rw-r--r-- 1 root root 463 Sep 1 2015 template1_2015-09-01.September.template1.sql.gz
-rw-r--r-- 1 root root 461 Oct 1 2015 template1_2015-10-01.October.template1.sql.gz
-rw-r--r-- 1 root root 462 Nov 1 2015 template1_2015-11-01.November.template1.sql.gz
-rw-r--r-- 1 root root 462 Dec 1 2015 template1_2015-12-01.December.template1.sql.gz
-rw-r--r-- 1 root root 461 Jan 1 2016 template1_2016-01-01.January.template1.sql.gz
-rw-r--r-- 1 root root 462 Feb 1 2016 template1_2016-02-01.February.template1.sql.gz
-rw-r--r-- 1 root root 459 Mar 1 2016 template1_2016-03-01.March.template1.sql.gz
-rw-r--r-- 1 root root 459 Apr 1 2016 template1_2016-04-01.April.template1.sql.gz
-rw-r--r-- 1 root root 457 May 1 2016 template1_2016-05-01.May.template1.sql.gz
-rw-r--r-- 1 root root 458 Jun 1 2016 template1_2016-06-01.June.template1.sql.gz
-rw-r--r-- 1 root root 458 Jul 1 2016 template1_2016-07-01.July.template1.sql.gz
-rw-r--r-- 1 root root 460 Aug 1 2016 template1_2016-08-01.August.template1.sql.gz
-rw-r--r-- 1 root root 463 Sep 1 2016 template1_2016-09-01.September.template1.sql.gz
-rw-r--r-- 1 root root 461 Oct 1 08:00 template1_2016-10-01.October.template1.sql.gz
-rw-r--r-- 1 root root 462 Nov 1 08:00 template1_2016-11-01.November.template1.sql.gz
-rw-r--r-- 1 root root 462 Dec 1 08:00 template1_2016-12-01.December.template1.sql.gz
-rw-r--r-- 1 root root 461 Jan 1 07:00 template1_2017-01-01.January.template1.sql.gz
-rw-r--r-- 1 root root 462 Feb 1 07:00 template1_2017-02-01.February.template1.sql.gz
-rw-r--r-- 1 root root 459 Mar 1 07:00 template1_2017-03-01.March.template1.sql.gz
/store/backups/postgresql/weekly/nagiosxi:
total 3344
-rw-r--r-- 1 root root 1369132 Feb 4 07:00 nagiosxi_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root 341763 Feb 11 07:00 nagiosxi_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root 351638 Feb 18 07:00 nagiosxi_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root 338345 Feb 25 07:00 nagiosxi_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root 368425 Mar 4 07:00 nagiosxi_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root 312094 Sep 3 2016 nagiosxi_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root 330365 Dec 3 08:00 nagiosxi_week.48.2016-12-03.sql.gz
/store/backups/postgresql/weekly/postgres:
total 28
-rw-r--r-- 1 root root 415 Feb 4 07:00 postgres_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root 415 Feb 11 07:00 postgres_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root 415 Feb 18 07:00 postgres_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root 415 Feb 25 07:00 postgres_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root 415 Mar 4 07:00 postgres_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root 415 Sep 3 2016 postgres_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root 415 Dec 3 08:00 postgres_week.48.2016-12-03.sql.gz
/store/backups/postgresql/weekly/template1:
total 28
-rw-r--r-- 1 root root 451 Feb 4 07:00 template1_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root 451 Feb 11 07:00 template1_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root 451 Feb 18 07:00 template1_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root 451 Feb 25 07:00 template1_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root 451 Mar 4 07:00 template1_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root 451 Sep 3 2016 template1_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root 451 Dec 3 08:00 template1_week.48.2016-12-03.sql.gzCode: Select all
/store/backups/postgresql/daily/nagiosxi:
total 2020
-rw-r--r-- 1 root root 345309 Mar 2 07:00 nagiosxi_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 338199 Mar 3 07:00 nagiosxi_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 340648 Mar 5 07:00 nagiosxi_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 347035 Mar 6 07:00 nagiosxi_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 342085 Mar 7 07:00 nagiosxi_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 343241 Mar 8 07:00 nagiosxi_2017-03-08.Wednesday.sql.gz
/store/backups/postgresql/monthly/nagiosxi:
total 7800
-rw-r--r-- 1 root root 18711 Nov 1 2014 nagiosxi_2014-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 44075 Dec 1 2014 nagiosxi_2014-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 94691 Jan 1 2015 nagiosxi_2015-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 191096 Feb 1 2015 nagiosxi_2015-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 176023 Mar 1 2015 nagiosxi_2015-03-01.March.nagiosxi.sql.gz
-rw-r--r-- 1 root root 291345 Apr 1 2015 nagiosxi_2015-04-01.April.nagiosxi.sql.gz
-rw-r--r-- 1 root root 265528 May 1 2015 nagiosxi_2015-05-01.May.nagiosxi.sql.gz
-rw-r--r-- 1 root root 239582 Jun 1 2015 nagiosxi_2015-06-01.June.nagiosxi.sql.gz
-rw-r--r-- 1 root root 240302 Jul 1 2015 nagiosxi_2015-07-01.July.nagiosxi.sql.gz
-rw-r--r-- 1 root root 234476 Aug 1 2015 nagiosxi_2015-08-01.August.nagiosxi.sql.gz
-rw-r--r-- 1 root root 374674 Sep 1 2015 nagiosxi_2015-09-01.September.nagiosxi.sql.gz
-rw-r--r-- 1 root root 214758 Oct 1 2015 nagiosxi_2015-10-01.October.nagiosxi.sql.gz
-rw-r--r-- 1 root root 266042 Nov 1 2015 nagiosxi_2015-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 234322 Dec 1 2015 nagiosxi_2015-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 328028 Jan 1 2016 nagiosxi_2016-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 296472 Feb 1 2016 nagiosxi_2016-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 339168 Mar 1 2016 nagiosxi_2016-03-01.March.nagiosxi.sql.gz
-rw-r--r-- 1 root root 312985 Apr 1 2016 nagiosxi_2016-04-01.April.nagiosxi.sql.gz
-rw-r--r-- 1 root root 330087 May 1 2016 nagiosxi_2016-05-01.May.nagiosxi.sql.gz
-rw-r--r-- 1 root root 421085 Jun 1 2016 nagiosxi_2016-06-01.June.nagiosxi.sql.gz
-rw-r--r-- 1 root root 321984 Jul 1 2016 nagiosxi_2016-07-01.July.nagiosxi.sql.gz
-rw-r--r-- 1 root root 311840 Aug 1 2016 nagiosxi_2016-08-01.August.nagiosxi.sql.gz
-rw-r--r-- 1 root root 325296 Sep 1 2016 nagiosxi_2016-09-01.September.nagiosxi.sql.gz
-rw-r--r-- 1 root root 320140 Oct 1 08:00 nagiosxi_2016-10-01.October.nagiosxi.sql.gz
-rw-r--r-- 1 root root 337783 Nov 1 08:00 nagiosxi_2016-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 344945 Dec 1 08:00 nagiosxi_2016-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 331124 Jan 1 07:00 nagiosxi_2017-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 356839 Feb 1 07:00 nagiosxi_2017-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 360610 Mar 1 07:00 nagiosxi_2017-03-01.March.nagiosxi.sql.gz
/store/backups/postgresql/weekly/nagiosxi:
total 3344
-rw-r--r-- 1 root root 1369132 Feb 4 07:00 nagiosxi_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root 341763 Feb 11 07:00 nagiosxi_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root 351638 Feb 18 07:00 nagiosxi_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root 338345 Feb 25 07:00 nagiosxi_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root 368425 Mar 4 07:00 nagiosxi_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root 312094 Sep 3 2016 nagiosxi_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root 330365 Dec 3 08:00 nagiosxi_week.48.2016-12-03.sql.gzCode: Select all
psql -U postgres -d nagiosxi -a -f /path/to/42742_recover_dash.sql