Using wal-e to replicate a primary server

[oger...@gmail.com]

Hi all,

following this gist, I've set up a primary/standby couple (server1 is the primary, server2 is the standby). The goal was to migrate from server1 (actual live server) to server2. All went fine since I tried to switch server2 as primary.

So, my configuration is as in the previous gist, here are steps I followed to set the server2 as primary :

- stop server1 : OK

- switch standby_mode to off on server2 OK

- stop server2 OK

- start server2 -> NOK

Postgresql on server2 failed to start. Here is the log entry :

2018-12-06 23:54:32 CET [26101]: [3-1] user=,db= LOG:  ending log output to stderr

2018-12-06 23:54:32 CET [26101]: [4-1] user=,db= HINT:  Future log output will go to log destination "csvlog".

lzop: <stdin>: not a lzop file

MSG: An unprocessed exception has avoided all error handling

DETAIL: Traceback (most recent call last):

  File "/usr/local/lib/python3.6/site-packages/wal_e/cmd.py", line 659, in main

    args.prefetch)

  File "/usr/local/lib/python3.6/site-packages/wal_e/operator/backup.py", line 353, in wal_restore

    self.gpg_key_id is not None)

  File "/usr/local/lib/python3.6/site-packages/wal_e/worker/worker_util.py", line 58, in do_lzop_get

    return blobstore.do_lzop_get(creds, url, path, decrypt, do_retry=do_retry)

  File "/usr/local/lib/python3.6/site-packages/wal_e/blobstore/file/file_util.py", line 52, in do_lzop_get

    raise exc

  File "/usr/local/lib/python3.6/site-packages/wal_e/blobstore/file/file_util.py", line 64, in write_and_return_error

    key.get_contents_to_file(stream)

  File "/usr/local/lib/python3.6/site-packages/wal_e/blobstore/file/calling_format.py", line 53, in get_contents_to_file

    with open(self.path, 'rb') as f:

FileNotFoundError: [Errno 2] No such file or directory: '/path_to_wals_backups/wal_005/00000002.history.lzo'

 And in the /path_to_wals_backups/wal_005/, wals are in the format 000000020000623B00000092.lzo

What am I doing wrong? 

Any help would be greatly appreciated!

Thanks in advance.