Thread: Postgres 7.1.3 on OpenBSD 2.9?
Has anyone out there succeeded in installing Postgres 7.1.3 on an
x86-based OpenBSD 2.9 install?
My setup -
x86 OpenBSD 2.9, out-of-the-box (no patches).
Unpacked the Postgres 7.1.3 tarball. Configure, make, make check all
pass. Installed cleanly. Updated /var/run/ld.so.hints to include
/usr/local/pgsql/lib.
initdb -D /usr/local/pgsql/data/ ran fine.
database started up without complaint.
createdb test was fine.
Attempting to log into the database with pgsql died as follows:
bash-2.05$ /usr/local/pgsql/bin/psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
/usr/libexec/ld.so: Undefined symbol "_tgetent" called from
psql:/usr/lib/libreadline.so.0.0 at 0x40165964
pq_recvbuf: unexpected EOF on client connection
Any suggestions? There's nothing in the documentation that suggests
special settings for installing on OpenBSD. If there's any additional
information I can provide, please let me know.
thanks,
--peter
> > Has anyone out there succeeded in installing Postgres 7.1.3 on an > x86-based OpenBSD 2.9 install? Did ya try the ports tree? 7.1.3 is in it if you are tracking 2.9-current. Else, let me know and I can make the the tarball available for 2.9-release. - Brandon ---------------------------------------------------------------------------- c: 646-456-5455 h: 201-798-4983 b. palmer, bpalmer@crimelabs.net pgp:crimelabs.net/bpalmer.pgp5
It looks like there is something amiss with your installed readline libraries. Are they GNU readline? If not, you may need to install the GNU version. I don't recall of PG expects it precisely, and I cant say if installing GNU will break other programs. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" > From: Pete Leonard <pete@hero.com> > Date: Fri, 21 Sep 2001 09:46:54 -0700 (PDT) > To: pgsql-general@postgresql.org > Subject: [GENERAL] Postgres 7.1.3 on OpenBSD 2.9? > > > Has anyone out there succeeded in installing Postgres 7.1.3 on an > x86-based OpenBSD 2.9 install? > > My setup - > > x86 OpenBSD 2.9, out-of-the-box (no patches). > > Unpacked the Postgres 7.1.3 tarball. Configure, make, make check all > pass. Installed cleanly. Updated /var/run/ld.so.hints to include > /usr/local/pgsql/lib. > > initdb -D /usr/local/pgsql/data/ ran fine. > database started up without complaint. > createdb test was fine. > > Attempting to log into the database with pgsql died as follows: > > bash-2.05$ /usr/local/pgsql/bin/psql test > Welcome to psql, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > /usr/libexec/ld.so: Undefined symbol "_tgetent" called from > psql:/usr/lib/libreadline.so.0.0 at 0x40165964 > pq_recvbuf: unexpected EOF on client connection > > > Any suggestions? There's nothing in the documentation that suggests > special settings for installing on OpenBSD. If there's any additional > information I can provide, please let me know. > > thanks, > > --peter > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
The issue is that OpenBSD ships with a wierd readline. Its a one-line fix, search the archives for openbsd and readline. 7.2 should have the fix already. Alternatively, compile pgsql without readline. -alex On Fri, 21 Sep 2001, Keary Suska wrote: > It looks like there is something amiss with your installed readline > libraries. Are they GNU readline? If not, you may need to install the GNU > version. I don't recall of PG expects it precisely, and I cant say if > installing GNU will break other programs. > > Keary Suska > Esoteritech, Inc. > "Leveraging Open Source for a better Internet" > > > From: Pete Leonard <pete@hero.com> > > Date: Fri, 21 Sep 2001 09:46:54 -0700 (PDT) > > To: pgsql-general@postgresql.org > > Subject: [GENERAL] Postgres 7.1.3 on OpenBSD 2.9? > > > > > > Has anyone out there succeeded in installing Postgres 7.1.3 on an > > x86-based OpenBSD 2.9 install? > > > > My setup - > > > > x86 OpenBSD 2.9, out-of-the-box (no patches). > > > > Unpacked the Postgres 7.1.3 tarball. Configure, make, make check all > > pass. Installed cleanly. Updated /var/run/ld.so.hints to include > > /usr/local/pgsql/lib. > > > > initdb -D /usr/local/pgsql/data/ ran fine. > > database started up without complaint. > > createdb test was fine. > > > > Attempting to log into the database with pgsql died as follows: > > > > bash-2.05$ /usr/local/pgsql/bin/psql test > > Welcome to psql, the PostgreSQL interactive terminal. > > > > Type: \copyright for distribution terms > > \h for help with SQL commands > > \? for help on internal slash commands > > \g or terminate with semicolon to execute query > > \q to quit > > > > /usr/libexec/ld.so: Undefined symbol "_tgetent" called from > > psql:/usr/lib/libreadline.so.0.0 at 0x40165964 > > pq_recvbuf: unexpected EOF on client connection > > > > > > Any suggestions? There's nothing in the documentation that suggests > > special settings for installing on OpenBSD. If there's any additional > > information I can provide, please let me know. > > > > thanks, > > > > --peter > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
Pete Leonard writes: > /usr/libexec/ld.so: Undefined symbol "_tgetent" called from > psql:/usr/lib/libreadline.so.0.0 at 0x40165964 Rebuild thus: LIBS=-lcurses ./configure ...(usual options) make make install etc. This is fixed (or better worked around) in the upcoming 7.2 release. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter