problem in database backup
| От | vijaykumar M |
|---|---|
| Тема | problem in database backup |
| Дата | |
| Msg-id | BAY2-F56btA1ZPp5ohC00012e0f@hotmail.com обсуждение |
| Ответы |
Re: problem in database backup
Re: problem in database backup |
| Список | pgsql-sql |
Hi All,
I'm using Postgresql V7.3.3, on that i created one database with name "mydb".
PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
While taking a backup of my postgresql database, i'm getting the below error.
bash-2.05b$ pg_dump mydb >mydb.out
pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2
pg_dump: aborting because of version mismatch (Use the -i option to proceed any
================================================================
bash-2.05b$ pg_dump -i mydb > mydb.out
pg_dump: server version: SAGES/pg_dump.mo; pg_dump version: 7.2.2
pg_dump: proceeding despite version mismatch
pg_dump: query to obtain list of data types failed: ERROR: Attribute "typprtlen" not found
==============================================================
After getting these errors, i tried to check the version of pg_dump on my system by using the below command. Here is the result .....
[root@sql-linux root]# find / -name pg_dump -print
/root/postgresql-7.3.3/src/bin/pg_dump
/root/postgresql-7.3.3/src/bin/pg_dump/pg_dump
/usr/bin/pg_dump
/usr/local/pgsql/bin/pg_dump
============================================================
Kindly guide me to solve this problem. ..
Thanks in advance,
With Regards,
Vijay
It's all happening @ F1. Feel the thrill! Race along right here!
В списке pgsql-sql по дате отправления: