Thread

  1. Postgres 7.1.3 on OpenBSD 2.9?

    Pete Leonard <pete@hero.com> — 2001-09-21T16:46:54Z

    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
    
    
    
    
  2. Re: Postgres 7.1.3 on OpenBSD 2.9?

    bpalmer <bpalmer@crimelabs.net> — 2001-09-21T18:11:13Z

    >
    > 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
    
    
    
  3. Re: Postgres 7.1.3 on OpenBSD 2.9?

    Keary Suska <hierophant@pcisys.net> — 2001-09-21T18:14:28Z

    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
    > 
    
    
    
  4. Re: Postgres 7.1.3 on OpenBSD 2.9?

    Peter Eisentraut <peter_e@gmx.net> — 2001-09-21T18:45:46Z

    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
    
    
    
  5. Re: Postgres 7.1.3 on OpenBSD 2.9?

    Alex Pilosov <alex@pilosoft.com> — 2001-09-21T19:14:57Z

    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
    > 
    >