0000326: PostgreSQL check fails with 8.1.11 - Openbravo Issue Tracking System

(0000296)
jpabloae (viewer)
2008-05-22 00:42

Fixed in revision 46.

(0000326)
jpabloae (viewer)
2008-05-24 18:18

Workaround till a new 2.35MPX is released:

1. Move /usr/bin/psql to /usr/bin/psql2
2. Create /usr/bin/psql with this contents:

if [ "$1" = "-–version" ]; then
echo "psql (PostgreSQL) 8.1.9"
else
/usr/bin/psql2 $*
fi

3. Make it executable: chmod +x /usr/bin/psql

(0011829)
skoon (viewer)
2009-01-02 09:06

workaround does not work on osx. Still gives me "8.3 version is not supported"

(0011901)
jpabloae (viewer)
2009-01-04 04:40

skoon: If you that message it's because you are trying to install version 2.35MPX. And PostgreSQL 8.3 is not supported in that version. 2.35MP5 requires >=8.1.4 and <8.3.0.

(0011912)
skoon (viewer)
2009-01-05 12:09

thank you, i hope we talk about the same thing. there is no postgresql 8.2 for OSX regarding to http://www.enterprisedb.com/products/download.do [^]
i hope i am wrong

(0011913)
jpabloae (viewer)
2009-01-05 12:35

PostgreSQL 8.2 for Mac can be installed in two ways:

1) Building it from sources: http://www.postgresql.org/ftp/source/v8.2.11/ [^]
2) Installing it from a binary. You are right that EnterpriseDB doesn't offer 8.2 binaries. But Fink does:
http://pdb.finkproject.org/pdb/package.php/postgresql82 [^]

Anyway, I strongly suggest you to install 2.40 instead of 2.35MP5. PostgreSQL 8.3 works fine with 2.40. If you have any problems with 2.40, they should be fixable.

Issue History
Date Modified	Username	Field	Change
2008-05-16 10:46	jpabloae	New Issue
2008-05-16 10:46	jpabloae	Assigned To	=> jpabloae
2008-05-16 10:46	jpabloae	Status	new => acknowledged
2008-05-22 00:42	jpabloae	Status	acknowledged => scheduled
2008-05-22 00:42	jpabloae	Status	scheduled => resolved
2008-05-22 00:42	jpabloae	Fixed in Version	=> 2.40alpha-r2
2008-05-22 00:42	jpabloae	Resolution	open => fixed
2008-05-22 00:42	jpabloae	Note Added: 0000296
2008-05-24 18:18	jpabloae	Note Added: 0000326
2008-11-13 07:02	jpabloae	Status	resolved => closed
2008-11-25 21:41	pjuvara	Sticky Issue	No => Yes
2008-11-25 21:43	pjuvara	Project	@5@ => Openbravo ERP
2008-11-25 21:45	pjuvara	Category	Installer => K. Packaging
2008-11-25 21:47	pjuvara	Sticky Issue	Yes => No
2009-01-02 09:06	skoon	Note Added: 0011829
2009-01-04 04:40	jpabloae	Note Added: 0011901
2009-01-05 12:09	skoon	Note Added: 0011912
2009-01-05 12:35	jpabloae	Note Added: 0011913
2009-03-18 11:02	anonymous	sf_bug_id	0 => 2691280

Notes
(0000296) jpabloae (viewer) 2008-05-22 00:42	Fixed in revision 46.

(0000326) jpabloae (viewer) 2008-05-24 18:18	Workaround till a new 2.35MPX is released: 1. Move /usr/bin/psql to /usr/bin/psql2 2. Create /usr/bin/psql with this contents: if [ "$1" = "-–version" ]; then echo "psql (PostgreSQL) 8.1.9" else /usr/bin/psql2 $* fi 3. Make it executable: chmod +x /usr/bin/psql

(0011829) skoon (viewer) 2009-01-02 09:06	workaround does not work on osx. Still gives me "8.3 version is not supported"

(0011901) jpabloae (viewer) 2009-01-04 04:40	skoon: If you that message it's because you are trying to install version 2.35MPX. And PostgreSQL 8.3 is not supported in that version. 2.35MP5 requires >=8.1.4 and <8.3.0.

(0011912) skoon (viewer) 2009-01-05 12:09	thank you, i hope we talk about the same thing. there is no postgresql 8.2 for OSX regarding to http://www.enterprisedb.com/products/download.do [^] i hope i am wrong

(0011913) jpabloae (viewer) 2009-01-05 12:35	PostgreSQL 8.2 for Mac can be installed in two ways: 1) Building it from sources: http://www.postgresql.org/ftp/source/v8.2.11/ [^] 2) Installing it from a binary. You are right that EnterpriseDB doesn't offer 8.2 binaries. But Fink does: http://pdb.finkproject.org/pdb/package.php/postgresql82 [^] Anyway, I strongly suggest you to install 2.40 instead of 2.35MP5. PostgreSQL 8.3 works fine with 2.40. If you have any problems with 2.40, they should be fixable.