Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
I am unable to copy the complete backup.manifest file due to security reasons . please find the below contents.[backup:db]db-catalog-version=201510051db-control-version=942db-id=1db-system-id=6444557285095914282db-version="9.5"[backup:option]option-archive-check=trueoption-archive-copy=falseoption-backup-standby=falseoption-checksum-page=falseoption-compress=trueoption-hardlink=falseoption-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,ChiranjeeviOn Thu, Dec 28, 2017 at 5:41 PM, David Steele <david@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, -- -Daviddavid@pgmasters.net
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, -- -Daviddavid@pgmasters.net
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)
В списке pgsql-general по дате отправления: