Re: version problem with pg_dump - Mailing list pgsql-general

From Steve Crawford
Subject Re: version problem with pg_dump
Date
Msg-id 44230A22.6070103@pinpointresearch.com
Whole thread Raw
List pgsql-general
Brian Kitzberger wrote:
> Hi Steve,
>
> pg_dump --version    returned 7.4.8
> pg_dumpall --version returned 7.4.8
> psql *version  returned 7.4.8
> which pg_dump  returned /usr/bin/pg_dump
> which pg_dumpall   returned /usr/bin/pg_dump
> which psql  returned /usr/bin/psql
>
> To find the file I used from the root
> find . -name pg_dump

It would be unusual for the files to be in those locations if you did
the usual "./configure ; make ; make install". How, exactly, did you
install PostgreSQL?

As Scott suggested, try running "rpm -qa | grep -i postgres" (assuming
rpm is at the core of your package management) and when you find that it
was already installed, use rpm to erase it.

Here, things can get interesting. While you may not have intentionally
installed PostgreSQL, your package manager may have installed it for you
to solve a dependency (PHP with PG support or some app that requires PG
for example) you may find your package manager complaining about
dependencies when you try to remove it. But worry about burning that
bridge when you get to it.

Cheers,
Steve

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Re: Logging of sql statements?
Next
From: Scott Marlowe
Date:
Subject: Re: Logging of sql statements?