Can you please help on below pgbackrest restoration issue.
On Thu, Dec 28, 2017 at 6:15 PM, chiru r <chir...@gmail.com> 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 <da...@pgmasters.net> 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
>> da...@pgmasters.net
>>
>
>
