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 |
<div style="background-color:"><div><p><br />Hi All,<p>I'm using Postgresql V7.3.3, on that i created one database with name"mydb".<p><font color="#000033"><strong> 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)</strong></font><p>While taking a backup of my postgresql database, i'm getting the belowerror.<p>bash-2.05b$ <strong><font color="#993366">pg_dump mydb >mydb.out<br />pg_dump: server version: SAGES/pg_dump.mo;pg_dump version: 7.2.2<br />pg_dump: aborting because of version mismatch (Use the -i option to proceedany<br />================================================================</font></strong><p><strong><font color="#993366">bash-2.05b$pg_dump -i mydb > mydb.out<br />pg_dump: server version: SAGES/pg_dump.mo; pg_dump version:7.2.2<br />pg_dump: proceeding despite version mismatch<br />pg_dump: query to obtain list of data types failed:ERROR: Attribute "typprtlen" not found<br />==============================================================</font></strong><p><fontcolor="#000033">After getting these</font><fontcolor="#000033"> errors, i tried to check the version of pg_dump on my system by using the below command.Here is the result .....</font><p><strong><font color="#993366">[root@sql-linux root]# find / -name pg_dump -print<br/>/root/postgresql-7.3.3/src/bin/pg_dump<br />/root/postgresql-7.3.3/src/bin/pg_dump/pg_dump<br />/usr/bin/pg_dump<br/>/usr/local/pgsql/bin/pg_dump<br /></font></strong><font color="#993366"></font><p><font color="#993366">============================================================</font><p><fontcolor="#000033">Kindly guide meto solve this problem. .. </font><p><font color="#000033">Thanks in advance,</font><p><font color="#000033">With Regards,</font><p><fontcolor="#000033">Vijay</font><p> <p> <p> <p> <p> </div></div><br clear="all" /><hr />It's all happening@ F1. Feel the thrill! <a href="http://g.msn.com/8HMXENIN/2734??PS=">Race along right here!</a>
В списке pgsql-sql по дате отправления: