Restore xxxxx.backup database
| От | adccs |
|---|---|
| Тема | Restore xxxxx.backup database |
| Дата | |
| Msg-id | 1127806631.3712.15.camel@localhost.localdomain обсуждение исходный текст |
| Ответы |
Re: Restore xxxxx.backup database
|
| Список | pgsql-general |
Help needed to restore a backup database!
1. Postgres service was started. When I run a restore command for the backup stored in /tmp (backed from another server working on this database and sent to meby email by another user). I created a database by the same name "royapuram" by using createdb in template1 and then ran the following command:
[root@adccs ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
ERROR: pg_restore: [archiver] unsupported version (1.10) in file header
2. Alternatively I used (after creating "royapuram" database
[root@adccs ~]# su - postgres
-bash-3.00$ psql royapuram < /tmp/royapuram.backup;
RESULT
ERROR: syntax error at or near "" at character 1
and the whole terminal churns up junk characters and stops!
What do I do to restore!!
Regards
1. Postgres service was started. When I run a restore command for the backup stored in /tmp (backed from another server working on this database and sent to meby email by another user). I created a database by the same name "royapuram" by using createdb in template1 and then ran the following command:
[root@adccs ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
ERROR: pg_restore: [archiver] unsupported version (1.10) in file header
2. Alternatively I used (after creating "royapuram" database
[root@adccs ~]# su - postgres
-bash-3.00$ psql royapuram < /tmp/royapuram.backup;
RESULT
ERROR: syntax error at or near "" at character 1
and the whole terminal churns up junk characters and stops!
What do I do to restore!!
Regards
| K. Rajaraman |
В списке pgsql-general по дате отправления: