2013/9/26 Thara Vadakkeveedu :
> Hi,
> When you say preinstalled with the system, you mean preinstalled with RedHat
> Linux?
>
> I seem to have the right version ... I had to use the full path to identify
> the version.
>
> -bash-4.1$ /usr/pgsql-9.2/bin/pg_dump --version
> pg_dump (PostgreSQL) 9.2.
older version?
Thanks!
Thara.
From: Craig James
To: Thara Vadakkeveedu
Sent: Wednesday, September 25, 2013 5:32 PM
Subject: Re: [ADMIN] pd_dump server mismatch error
On Wed, Sep 25, 2013 at 2:15 PM, Thara Vadakkeveedu wrote:
Hi
>I did not inst
Hi,
I found pg_dump under /usr/pgsql-9.2/bin/ and /usr/bin, but both of them show
version as 8.4.13.
# su - postgres
-bash-4.1$ cd /usr/pgsql-9.2/bin
-bash-4.1$ pg_dump --version
pg_dump (PostgreSQL) 8.4.13
-bash-4.1$ cd /usr/bin
-bash-4.1$ pg_dump --version
pg_dump (PostgreSQL) 8.4.13
How can
y the result like the 9.2 one
-- Original --
From: "Thara Vadakkeveedu";;
Date: Thu, Sep 26, 2013 05:15 AM
To: "alejand...@pasteleros.org.ar";
"pgsql-admin@postgresql.org";
Subject: Re: [ADMIN] pd_dump server mismatch error
?
Thanks,
TG
From: Alejandro Brust
To: pgsql-admin@postgresql.org
Sent: Wednesday, September 25, 2013 3:47 PM
Subject: Re: [ADMIN] pd_dump server mismatch error
Hello, first excuse my English
U cant do a backup whit a Client minor version than the server
Looks like the real problem here is that you got a version of
postgresql installed with the OS, and then you also installed the 9.2
RPMs. Uninstall the postgres that came with the OS and/or specify the
full path to the 9.2 pg_dump.
On Wed, Sep 25, 2013 at 12:47 PM, Alejandro Brust
wrote:
> Hello
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
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 po
