pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpd_dump server mismatch error
8+ messages / 5 participants
[nested] [flat]
* pd_dump server mismatch error
@ 2013-09-25 18:55 Thara Vadakkeveedu <tharagv@yahoo.com>
0 siblings, 2 replies; 8+ messages in thread
From: Thara Vadakkeveedu @ 2013-09-25 18:55 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pd_dump server mismatch error
@ 2013-09-25 19:47 Alejandro Brust <alejandrob@pasteleros.org.ar>
parent: Thara Vadakkeveedu <tharagv@yahoo.com>
1 sibling, 2 replies; 8+ messages in thread
From: Alejandro Brust @ 2013-09-25 19:47 UTC (permalink / raw)
To: pgsql-admin
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.
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pd_dump server mismatch error
@ 2013-09-25 19:50 Lonni J Friedman <netllama@gmail.com>
parent: Alejandro Brust <alejandrob@pasteleros.org.ar>
1 sibling, 0 replies; 8+ messages in thread
From: Lonni J Friedman @ 2013-09-25 19:50 UTC (permalink / raw)
To: alejandrob@pasteleros.org.ar; +Cc: pgsql-admin
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
<alejandrob@pasteleros.org.ar> wrote:
> 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.
>
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand https://netllama.linux-sxs.org
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pd_dump server mismatch error
@ 2013-09-25 21:15 Thara Vadakkeveedu <tharagv@yahoo.com>
parent: Alejandro Brust <alejandrob@pasteleros.org.ar>
1 sibling, 1 reply; 8+ messages in thread
From: Thara Vadakkeveedu @ 2013-09-25 21:15 UTC (permalink / raw)
To: alejandrob@pasteleros.org.ar <alejandrob@pasteleros.org.ar>; pgsql-admin
Hi
I did not install the client separately. I assumed i would get the right client as part of the 9.2 Yum install...
I see psql is an older version too.
# su - postgres
-bash-4.1$ psql -d postgres
psql (8.4.13, server 9.2.4)
WARNING: psql version 8.4, server version 9.2.
Some psql features might not work.
When I installed postgresql-9.2 using Yum (yum install postgresql92 postgresql92-server)
The following 3 packages were installed:
postgresql92 x86_64 9.2.4-1PGDG.rhel6 pgdg92 970 k
postgresql92-server x86_64 9.2.4-1PGDG.rhel6 pgdg92 3.8 M
postgresql92-libs x86_64 9.2.4-1PGDG.rhel6 pgdg92 185 k
I assumed this took care of installing the right client. I run the client from the same machine where the server is installed.
Is there a separate package I should have installed for the 9.2 client ?
Thanks,
TG
________________________________
From: Alejandro Brust <alejandrob@pasteleros.org.ar>
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
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.
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Fw: pd_dump server mismatch error
@ 2013-09-25 21:33 Thara Vadakkeveedu <tharagv@yahoo.com>
parent: Thara Vadakkeveedu <tharagv@yahoo.com>
1 sibling, 0 replies; 8+ messages in thread
From: Thara Vadakkeveedu @ 2013-09-25 21:33 UTC (permalink / raw)
To: pgsql-admin
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 I upgrade pg_dump to 9.2 ?
Thanks,
TG
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pd_dump server mismatch error
@ 2013-09-25 21:41 Thara Vadakkeveedu <tharagv@yahoo.com>
parent: Thara Vadakkeveedu <tharagv@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Thara Vadakkeveedu @ 2013-09-25 21:41 UTC (permalink / raw)
To: Craig James <cjames@emolecules.com>; +Cc: pgsql-admin
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.4
How can I find the package name for the older version?
Thanks!
Thara.
________________________________
From: Craig James <cjames@emolecules.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
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 <tharagv@yahoo.com> wrote:
Hi
>I did not install the client separately. I assumed i would get the right client as part of the 9.2 Yum install...
>
You did get the right client, but that's not what you are running. You are running the preinstalled Postgres which came pre-installed on your system. Type "which pg_dump" to see where it is located. Your best bet is to use your package manager to remove the preinstalled version, as otherwise it's going to keep giving you trouble.
Craig
>I see psql is an older version too.
>
># su - postgres
>-bash-4.1$ psql -d postgres
>psql (8.4.13, server 9.2.4)
>WARNING: psql version 8.4, server version 9.2.
> Some psql features might not work.
>
>When I installed postgresql-9.2 using Yum (yum install postgresql92 postgresql92-server)
>
>The following 3 packages were installed:
>
> postgresql92 x86_64 9.2.4-1PGDG.rhel6 pgdg92 970 k
> postgresql92-server x86_64 9.2.4-1PGDG.rhel6 pgdg92 3.8 M
> postgresql92-libs x86_64 9.2.4-1PGDG.rhel6 pgdg92 185 k
>I assumed this took care of installing the right client. I run the client from the same machine where the server is installed.
>
>Is there a separate package I should have installed for the 9.2 client ?
>Thanks,
>TG
>
>
>
>
>
>
>
>________________________________
> From: Alejandro Brust <alejandrob@pasteleros.org.ar>
>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
>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.
>>
>>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pd_dump server mismatch error
@ 2013-09-26 01:43 DDT <410845160@qq.com>
0 siblings, 0 replies; 8+ messages in thread
From: DDT @ 2013-09-26 01:43 UTC (permalink / raw)
To: Thara Vadakkeveedu <tharagv@yahoo.com>; alejandrob@pasteleros.org.ar <alejandrob@pasteleros.org.ar>; pgsql-admin
I think you can find if there is a pg_dump through follow 2:
ps -ef | grep postgres
there will be at least one line include the path of postgres server excutable file.
and ls that path to show if there is a pg_dump.
if your disk hasn't huge number of files,
find / -name pg_dump
try the result like the 9.2 one
------------------ Original ------------------
From: "Thara Vadakkeveedu";<tharagv@yahoo.com>;
Date: Thu, Sep 26, 2013 05:15 AM
To: "alejandrob@pasteleros.org.ar"<alejandrob@pasteleros.org.ar>; "pgsql-admin@postgresql.org"<pgsql-admin@postgresql.org>;
Subject: Re: [ADMIN] pd_dump server mismatch error
Hi
I did not install the client separately. I assumed i would get the right client as part of the 9.2 Yum install...
I see psql is an older version too.
# su - postgres
-bash-4.1$ psql -d postgres
psql (8.4.13, server 9.2.4)
WARNING: psql version 8.4, server version 9.2.
Some psql features might not work.
When I installed postgresql-9.2 using Yum (yum install postgresql92 postgresql92-server)
The following 3 packages were installed:
postgresql92 x86_64 9.2.4-1PGDG.rhel6 pgdg92 970 k
postgresql92-server x86_64 9.2.4-1PGDG.rhel6 pgdg92 3.8 M
postgresql92-libs x86_64 9.2.4-1PGDG.rhel6 pgdg92 185 k
I assumed this took care of installing the right client. I run the client from the same machine where the server is installed.
Is there a separate package I should have installed for the 9.2 client ?
Thanks,
TG
From: Alejandro Brust <alejandrob@pasteleros.org.ar>
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
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pd_dump server mismatch error
@ 2013-09-26 21:57 Ian Lawrence Barwick <barwick@gmail.com>
parent: Thara Vadakkeveedu <tharagv@yahoo.com>
0 siblings, 0 replies; 8+ messages in thread
From: Ian Lawrence Barwick @ 2013-09-26 21:57 UTC (permalink / raw)
To: Thara Vadakkeveedu <tharagv@yahoo.com>; +Cc: Craig James <cjames@emolecules.com>; pgsql-admin
2013/9/26 Thara Vadakkeveedu <tharagv@yahoo.com>:
> 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.4
>
> How can I find the package name for the older version?
This:
rpm -qf $(which pg_dump)
should show the package which the pg_dump binary in your default path
belongs to.
Regards
Ian Barwick
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2013-09-26 21:57 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-09-25 18:55 pd_dump server mismatch error Thara Vadakkeveedu <tharagv@yahoo.com>
2013-09-25 19:47 ` Alejandro Brust <alejandrob@pasteleros.org.ar>
2013-09-25 19:50 ` Lonni J Friedman <netllama@gmail.com>
2013-09-25 21:15 ` Thara Vadakkeveedu <tharagv@yahoo.com>
2013-09-25 21:41 ` Thara Vadakkeveedu <tharagv@yahoo.com>
2013-09-26 21:57 ` Ian Lawrence Barwick <barwick@gmail.com>
2013-09-25 21:33 ` Thara Vadakkeveedu <tharagv@yahoo.com>
2013-09-26 01:43 Re: pd_dump server mismatch error DDT <410845160@qq.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox