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"
Show quoted text
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 connectionAny 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
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
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:
Show quoted text
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 connectionAny 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