API tools faq
paste
popovnv

Untitled

popovnv
Jul 7th, 2017
135
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 2.21 KB | None | 0 0
raw download clone embed print report
  1. [root@co7g3 ~]# su - postgres -c "/usr/pgproee-9.6/bin/pg_probackup show -B /tmp/pgproee/9.6/backup/data --instance data_archive"
  2. ===============================================================================================================================
  3.  Instance    ID      Recovery time        Mode    WAL      Current/Parent TLI    Time    Data    Start LSN    Stop LSN   Status
  4. ===============================================================================================================================
  5.  data_archive OSME0A  2017-07-05 16:46:25  FULL    ARCHIVE    1 / 0               501s   321MB   4/93883850   4/97C87108  OK
  6.  
  7. [root@co7g3 ~]# su - postgres -c "/usr/pgproee-9.6/bin/pg_probackup validate -B /tmp/pgproee/9.6/backup/data --instance data_archive"
  8.  
  9. [root@co7g3 ~]# su - postgres -c "PGPASSWORD=super-pass-for-repl /usr/pgproee-9.6/bin/pg_probackup backup -B /tmp/pgproee/9.6/backup/data --instance data_archive -b PTRACK"
  10. ERROR: switched WAL segment 000000010000000400000099 could not be archived in 300 seconds
  11.  
  12. [root@co7g3 ~]# su - postgres -c "PGPASSWORD=super-pass-for-repl /usr/pgproee-9.6/bin/pg_probackup backup -B /tmp/pgproee/9.6/backup/data --instance data_archive -b PTRACK"
  13.  
  14. [root@co7g3 ~]# su - postgres -c "/usr/pgproee-9.6/bin/pg_probackup validate -B /tmp/pgproee/9.6/backup/data --instance data_archive"
  15. [root@co7g3 ~]# su - postgres -c "/usr/pgproee-9.6/bin/pg_probackup show -B /tmp/pgproee/9.6/backup/data --instance data_archive"
  16. ===============================================================================================================================
  17.  Instance    ID      Recovery time        Mode    WAL      Current/Parent TLI    Time    Data    Start LSN    Stop LSN   Status
  18. ===============================================================================================================================
  19.  data_archive OSPML2  2017-07-07 10:39:16  PTRACK  ARCHIVE    1 / 0                16s  3285kB   4/99027390   4/A2B60218  OK
  20.  data_archive OSPMA8  ----                 PTRACK  ARCHIVE    1 / 0               301s      0B   4/99027250   0/0         ERROR
  21.  data_archive OSME0A  2017-07-05 16:46:25  FULL    ARCHIVE    1 / 0               501s   321MB   4/93883850   4/97C87108  OK
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!