Re: non consistent? mixed version setup of binaries - Mailing list pgsql-pkg-debian

From Christoph Berg
Subject Re: non consistent? mixed version setup of binaries
Date
Msg-id 20131008075114.GA24083@msgid.df7cb.de
Whole thread Raw
In response to non consistent? mixed version setup of binaries  (Wim Bertels <wim.bertels@khleuven.be>)
Responses Re: non consistent? mixed version setup of binaries  (Wim Bertels <wim.bertels@khleuven.be>)
List pgsql-pkg-debian
Re: Wim Bertels 2013-10-06 <1381053296.4771.15.camel@zwerfkat>
> Hallo,
>
> using the apt.postgresql.org repo on debian stable, with versions 8.4 to
> 9.3 installed,
> my psql version reports as 9.3
> while my pg_dump version reports as 9.1
>
> eg:
> ROOT@server:/var/lib/postgresql# psql --version
> psql (PostgreSQL) 9.3.0
> ROOT@server:/var/lib/postgresql# pg_dump --version
> pg_dump (PostgreSQL) 9.1.9

Hi Wim,

this is expected. pg_wrapper will always redirect psql to the latest
version installed because it's downwards compatible, while directing
all other wrapped commands to the cluster you have selected.

9.1 seems to be the one on port 5432, so that's your default.

> so a standard pg_dump on a 9.3 database will fail,
> while a standard psql command will succeed;
> which seems inconsistent
>
> (the workarounc solution is in the case to use the full path to call the
> command)

You should be using pg_dump --cluster 9.3/main .

Christoph
--
cb@df7cb.de | http://www.df7cb.de/


pgsql-pkg-debian by date:

Previous
From: Wim Bertels
Date:
Subject: non consistent? mixed version setup of binaries
Next
From: Wim Bertels
Date:
Subject: Re: non consistent? mixed version setup of binaries