Re: pd_dump server mismatch error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello, first excuse my English
U cant do a backup whit a Client minor version than the server
U must have same version to do the backup, so U need upgrade your client (pg_dump 8.4.13) to at least 9.2.4


See U


El 25/09/2013 15:55, Thara Vadakkeveedu escribió:

Hi
I wanted to take a backup of my database.

pg_dump throws a server mismatch version error

# cd backups
# su - postgres
-bash-4.1$ pg_dump mydb > mydbfile
pg_dump: server version: 9.2.4; pg_dump version: 8.4.13
pg_dump: aborting because of server version mismatch

This is a fresh install of postgresql on a red hat linux server that did not have any previous database installed on it . I installed postgresql 9.2 from an rpm (pgdg-redhat92-9.2-7.noarch.rpm ) using yum install.

Why am I seeing this error?
How can I take a backup of my database? There are two tables that have 20,000+ rows in it, that I want to backup  and restore when needed.

thanks
thara.



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux