Re: PgBackRest question?

[chiru r <chirupg@xxxxxxxxx>]

Can you please help on below pgbackrest restoration issue.

On Thu, Dec 28, 2017 at 6:15 PM, chiru r <chirupg@xxxxxxxxx> wrote:

I am unable to copy the complete backup.manifest file due to security reasons . please find the below contents.

[backup:db]

db-catalog-version=201510051

db-control-version=942

db-id=1

db-system-id=6444557285095914282

db-version="9.5"

[backup:option]

option-archive-check=true

option-archive-copy=false

option-backup-standby=false

option-checksum-page=false

option-compress=true

option-hardlink=false

option-_online_=true

[backup:target]

pg_data={"path":"/u02/pgdata01/9.5/data","type":"path"}

pg_tblspc/721349={"path":"/u02/pgdata02/report1","tablespace-id":"721349","tablespace-name":"report1","type":"link"}

[db]

db1={"db-id":770161,"db-last-system-id":13289}

db2={"db-id":770162,"db-last-system-id":13289}

db3={"db-id":770169,"db-last-system-id":13289}

postgres={"db-id":13294,"db-last-system-id":13289}

template0={"db-id":13289,"db-last-system-id":13289}

template1={"db-id":1,"db-last-system-id":13289}

Below are the databases and table-spaces associated with it. 

postgres=# \l+

                                                                            List of databases

   Name    |  Owner   | Encoding |   Collate   |    Ctype    |           Access privileges           |  Size   | Tablespace |                Description

-----------+----------+----------+-------------+-------------+---------------------------------------+---------+------------+-------------------------------------------

-

 db1       | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                                       | 7280 kB | report1    |

 db2       | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                                       | 7280 kB | report1    |

 db3       | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                                       | 7280 kB | pg_default |

Thanks,

Chiranjeevi

On Thu, Dec 28, 2017 at 5:41 PM, David Steele <david@xxxxxxxxxxxxx> wrote:

On 12/28/17 5:15 PM, chiru r wrote:

Please find the below details.

postgres=# select datname, oid from pg_database;
   datname  |  oid
-----------+--------
  template0 |  13289
  postgres  |  13294
  template1 |      1
  db1       | 770161
  db2       | 770162
  db3       | 770169
(6 rows)

That looks OK. The next thing to look at is the backup that you are trying to restore.  Based on your commands this should be the most recent backup.

Please attach the backup.manifest file from:

[repo-path]/backup/online_backups/latest/backup.manifest

It's probably best if you compress it before attaching.

Thanks,
--
-David
david@xxxxxxxxxxxxx