Обсуждение: BUG #10381: psql.exe and pg_dump.exe are wrong version
The following bug has been logged on the website: Bug reference: 10381 Logged by: Jon R Email address: thanhR@icanlearn.vn PostgreSQL version: 9.3.4 Operating system: Windows 7 (32 bit) Description: the binaries, psql.exe and pg_dump.exe shipped with the version 9.3.4 installer for 32-bit windows are actually version 9.2.2 which obviously causes problems when attempting to use them.
On Mon, May 19, 2014 at 2:32 PM, <thanhR@icanlearn.vn> wrote: > The following bug has been logged on the website: > > Bug reference: 10381 > Logged by: Jon R > Email address: thanhR@icanlearn.vn > PostgreSQL version: 9.3.4 > Operating system: Windows 7 (32 bit) > Description: > > the binaries, psql.exe and pg_dump.exe shipped with the version 9.3.4 > installer for 32-bit windows are actually version 9.2.2 which obviously > causes problems when attempting to use them. Are you sure that Path is set up correctly in your environment? Don't you have multiple versions of Postgres installed on the same machine. Or perhaps you are still having outdated binaries in a machine that has only the client installed? -- Michael
I solved the problem. I was using psql.exe from pgAdmin III and ran pg_dump.exe from the same folder. the psql & pg_dump binaries included with pgAdmin III are version 9.2.2 (pgAdmin 8.3 I think?, in any case, it's straight from the installer from the website advertised as 9.3.4, I didn't have postgres on my computer before the install)
However, I realized there were also the postgres binaries installed somewhere else, and those are the right version. I also set up my PATH variable to avoid issues, however pgAdmin was still using the old binaries so I copy-pasted from the postgreSQL folder.
tl;dr postgreSQL is fine, pgAdmin is shipped with the wrong version. Not sure if that's supposed to happen or not.
On Tue, May 20, 2014 at 3:28 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Mon, May 19, 2014 at 2:32 PM, <thanhR@icanlearn.vn> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 10381
> Logged by: Jon R
> Email address: thanhR@icanlearn.vn
> PostgreSQL version: 9.3.4
> Operating system: Windows 7 (32 bit)
> Description:
>
> the binaries, psql.exe and pg_dump.exe shipped with the version 9.3.4
> installer for 32-bit windows are actually version 9.2.2 which obviously
> causes problems when attempting to use them.
Are you sure that Path is set up correctly in your environment? Don't
you have multiple versions of Postgres installed on the same machine.
Or perhaps you are still having outdated binaries in a machine that
has only the client installed?
--
Michael
On Tue, May 20, 2014 at 5:15 AM, Jonathan (Th=C3=A0nh) <thanhr@icanlearn.vn= > wrote: > I solved the problem. I was using psql.exe from pgAdmin III and ran > pg_dump.exe from the same folder. the psql & pg_dump binaries included wi= th > pgAdmin III are version 9.2.2 (pgAdmin 8.3 I think?, in any case, it's > straight from the installer from the website advertised as 9.3.4, I didn'= t > have postgres on my computer before the install) > > However, I realized there were also the postgres binaries installed > somewhere else, and those are the right version. I also set up my PATH > variable to avoid issues, however pgAdmin was still using the old binarie= s > so I copy-pasted from the postgreSQL folder. > > tl;dr postgreSQL is fine, pgAdmin is shipped with the wrong version. Not > sure if that's supposed to happen or not. Depends what version of pgAdmin you have. Each major version (1.18.x, 1.16.x, 1.14.x) etc always ships with the utilities from the version of PostgreSQL released at the same time (e.g 9.3, 9.2 and 9.1 respectively). > > On Tue, May 20, 2014 at 3:28 PM, Michael Paquier <michael.paquier@gmail.c= om> > wrote: >> >> On Mon, May 19, 2014 at 2:32 PM, <thanhR@icanlearn.vn> wrote: >> > The following bug has been logged on the website: >> > >> > Bug reference: 10381 >> > Logged by: Jon R >> > Email address: thanhR@icanlearn.vn >> > PostgreSQL version: 9.3.4 >> > Operating system: Windows 7 (32 bit) >> > Description: >> > >> > the binaries, psql.exe and pg_dump.exe shipped with the version 9.3.4 >> > installer for 32-bit windows are actually version 9.2.2 which obviousl= y >> > causes problems when attempting to use them. >> Are you sure that Path is set up correctly in your environment? Don't >> you have multiple versions of Postgres installed on the same machine. >> Or perhaps you are still having outdated binaries in a machine that >> has only the client installed? >> -- >> Michael > > --=20 Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company