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 res
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 feat
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
