Thread: BUG #6591: pg_dump version not compatible
The following bug has been logged on the website: Bug reference: 6591 Logged by: Helgi Steinar Email address: helgisteinar@gmail.com PostgreSQL version: 9.1.3 Operating system: Mac OSX 10.7.3 Description:=20=20=20=20=20=20=20=20 I downloaded and installed the version of Postgres using the installer from http://www.enterprisedb.com/products-services-training/pgdownload#osx When trying to use pg_dump the result is pg_dump: server version: 9.1.3; pg_dump version: 9.0.5
On Sun, Apr 15, 2012 at 7:07 PM, <helgisteinar@gmail.com> wrote: > The following bug has been logged on the website: > > Bug reference: =A0 =A0 =A06591 > Logged by: =A0 =A0 =A0 =A0 =A0Helgi Steinar > Email address: =A0 =A0 =A0helgisteinar@gmail.com > PostgreSQL version: 9.1.3 > Operating system: =A0 Mac OSX 10.7.3 > Description: > > I downloaded and installed the version of Postgres using the installer fr= om > http://www.enterprisedb.com/products-services-training/pgdownload#osx > > When trying to use pg_dump the result is > > pg_dump: server version: 9.1.3; pg_dump version: 9.0.5 Use the pg_dump executable that came with the installer (normally installed in /Library/PostgreSQL/9.1/bin) - you're almost certainly using the older, Apple supplied one in /usr/bin. --=20 Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On 15.04.2012 22:07, helgisteinar@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 6591 > Logged by: Helgi Steinar > Email address: helgisteinar@gmail.com > PostgreSQL version: 9.1.3 > Operating system: Mac OSX 10.7.3 > Description: > > I downloaded and installed the version of Postgres using the installer from > http://www.enterprisedb.com/products-services-training/pgdownload#osx > > When trying to use pg_dump the result is > > pg_dump: server version: 9.1.3; pg_dump version: 9.0.5 You need to use a pg_dump version that's greater than or equal to the version of the server. It looks like your pg_dump binary is not the version that comes with the server installer. Maybe you had an older version of PostgreSQL installed already, and running "pg_dump" in a shell picked up the older version? Check your $PATH. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com