Re: PgBackRest question? - Mailing list pgsql-general
| From | chiru r |
|---|---|
| Subject | Re: PgBackRest question? |
| Date | |
| Msg-id | CA+RSxMiqAcg+8OPV81sRLVQsXPA3_5ZEUSKwOVe4ZYFDBcMnzA@mail.gmail.com Whole thread Raw |
| In response to | Re: PgBackRest question? (David Steele <david@pgmasters.net>) |
| Responses |
Re: PgBackRest question?
Re: PgBackRest question? |
| List | 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@pgmasters.net> wrote:
On 12/28/17 5:15 PM, chiru r wrote: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 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)
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@pgmasters.net
pgsql-general by date: