BackUp

[fromcalcutta]

Hi,

While taking backup of my small demo DB in PostgreSQL, I'm getting the message ..

Command i used :
bash-2.05b$ pg_dump -f /home/subho/backup/14April AssetMgmt

Message :
pg_dump: server version: PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 (Mandrake Linux 9.0 3.2-1mdk); pg_dump version: 7.2.2
pg_dump: aborting because of version mismatch (Use the -i option to proceed anyway.)

Command I used :
bash-2.05b$ pg_dump -i -f /home/subho/backup/14April AssetMgmt

Message :
pg_dump: server version: PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 (Mandrake Linux 9.0 3.2-1mdk); 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

Why is this happening ? I used to take backup using pg_dump few days back. And now it's not working .. How to solve this problem ? Please suggest as soon as possible ..

Thanks , Subho.

 

[wcd1468]

try to find how may version of pg_dump software is in your system.

Command:
# find / -name pg_dump -print

This will print out the a list of pg_dump and its directory.

rename the pg_dump that are from previous version.

 

[rycamor]

Did you install the latest version of PostgreSQL as an RPM, or did you compile from source? How was the previous version of PostgreSQL installed?

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html

 

[wcd1468]

for my case, I am using Red Hat linux and it is being install during red hat linux operating system setup.

When we instal the postgeSQL 7.3 we install using
the tar format. However, the system does not remove the
previous version of postgreSQL.

when we using the tools, it is link to the old version.

 

[danielhozac]

Have you tried issuing [tt]rpm -qa | grep postgresql[/tt] and uninstalling the packages it lists (with [tt]rpm -e <package name>[/tt])? I use something like [tt]for iii in $( rpm -qa | grep '^postgresql' ); do rpm -e $iii; done[/tt] to remove all PostgreSQL packages.

//Daniel

 

[rycamor]

Well, until we hear an answer from fromcalcutta, we have no way of providing good advice.

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html

 

[kurious]

I had this problem and uninstalling the RPMs worked for me. Thanks for answering my question before I asked it