| From: | adccs <adccs(at)tn(dot)gov(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Restore xxxxx.backup database |
| Date: | 2005-09-27 07:37:11 |
| Message-ID: | 1127806631.3712.15.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gábor Farkas | 2005-09-27 08:15:28 | change db encoding? |
| Previous Message | Rolf stvik | 2005-09-27 07:04:38 | Re: regarding select into |