hi all, I have a question. What is the reason for that Koha does not have support for postgresql 8.3?
On Wed, Oct 8, 2008 at 11:08 AM, ricardo mendoza <koha.spanish@gmail.com> wrote:
hi all, I have a question. What is the reason for that Koha does not have support for postgresql 8.3?
I'm not a developer so I don't know the answer to this. However, the installer does appear to know about Postgres, but I couldn't get it to work. I'm more familiar with PostreSQL than MySQL so I thought I would try setting up Koha to use a Postgres database. The Makefile.PL part of the installer allowed me to select PostgreSQL and the first steps on the web installer appeared to work (detected the database I'd selected for Koha and confirmed user privileges). However, once it got to the stage of populating the database I got an errror that I couldn't figure out. Transcript from the Web Installer: ------------------------------------------ Web Installer › Step 2 Database settings: * database type : Pg * database name : koha * database host : db2 * database port : 5432 (probably OK if blank) * database user : koha-admin Connection established. Database koha exists. User koha-admin has all required privileges on database koha. -- Web Installer › Step 3 The following error occurred while importing the database structure: Password for user koha-admin: psql: fe_sendauth: no password supplied Please contact your system administrator Errors in Apache2 error log: ----------------------------------- [Wed Oct 8 11:34:15 2008] install.pl: DBD::Pg::st execute failed: ERROR: relation "language_subtag_registry" does not exist at /usr/share/koha/lib/C4/Languages.pm line 178. [Wed Oct 8 11:34:15 2008] install.pl: DBD::Pg::st fetchrow_hashref failed: no statement executing at /usr/share/koha/lib/C4/Languages.pm line 179. As I said, I couldn't figure it out so I gave up and switched to MySQL. Sincerely, Bradley Peters.
On Wed, Oct 8, 2008 at 1:21 PM, Bradley Peters <koha@moberley.com> wrote:
On Wed, Oct 8, 2008 at 11:08 AM, ricardo mendoza <koha.spanish@gmail.com> wrote:
hi all, I have a question. What is the reason for that Koha does not have support for postgresql 8.3?
I'm not a developer so I don't know the answer to this. However, the installer does appear to know about Postgres, but I couldn't get it to work.
I'm more familiar with PostreSQL than MySQL so I thought I would try setting up Koha to use a Postgres database. The Makefile.PL part of the installer allowed me to select PostgreSQL and the first steps on the web installer appeared to work (detected the database I'd selected for Koha and confirmed user privileges). However, once it got to the stage of populating the database I got an errror that I couldn't figure out.
PostgreSQL support in Koha 3 is very experimental (as the INSTALL file mentions IIRC). The pg version of kohastructure.sql is very out of date and needs to be brought into sync with the current mysql kohastructure.sql for starters. Even granting that you could successfully install the db schema over pg, none of the sql within koha code has been converted, so things would still break very badly. Basically this project was put on ice pending the addition of true db abstraction in the koha code itself. There has been some discussion of this for a future version of koha. Regards, Chris
Thank you. That`s a good thing to know. I can see that Koha needs a better support for postgresql . see you.
participants (3)
-
Bradley Peters -
Chris Nighswonger -
ricardo mendoza