From: | chiru r <chirupg(at)gmail(dot)com> |
---|---|
To: | David Steele <david(at)pgmasters(dot)net> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PgBackRest question? |
Date: | 2017-12-28 23:15:08 |
Message-ID: | CA+RSxMiqAcg+8OPV81sRLVQsXPA3_5ZEUSKwOVe4ZYFDBcMnzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)pgmasters(dot)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
> david(at)pgmasters(dot)net
>
From | Date | Subject | |
---|---|---|---|
Next Message | hmidi slim | 2017-12-29 10:47:01 | pool connection |
Previous Message | David Steele | 2017-12-28 22:41:03 | Re: PgBackRest question? |