FAQ
Operating system: SuSE 7.2 Professional with postgres v7.1 installed
manually.
(I prefer to manually set up software)
Directory: /postgres
Data Directory: /var/lib/pgsql/data
Options: ODBC emabled
Server startup line: postmaster -i -D /var/lib/pgsql/data > logfile.txt &
Port: 9427
System: AMD Athalon 1.4 Ghz, 512 MB Ram, D-Link network card

Upon trying to connect to the postgres backend by psql (with password
authentication enabled), postgres crashes saying "FATAL 1: Bad abstime
external representation ' '". I have also gotten '@!' and '/g!' in addition
to the ' '. The Postgres backend then terminates abnormally.

The '' was reported at debug_level 0, the '@!' was reported at debug_level
5, and the '/g!' was reported at debug_level 9. The psql string used to
connect was simply psql (database name). Adding additional paramaters, such
as -U have resulted in the same problem. When trying to channel the info
into a logfile, I did not have any luck, as the output file was empty.
Installation instructions were followed exactly.

Thanks

Erik Luke
eluke@cs.montana.edu

Search Discussions

  • Justin Clift at Aug 20, 2001 at 2:34 pm
    Hi Erik,

    Three questions :

    a) Did the database pass the regression test after you compiled it?

    b) Are the PostgreSQL specific environment variables "correct"? i.e.
    PGDATA, PGUSER, etc?

    c) Would you consider upgrading to PostgreSQL 7.1.3? What you describe
    may be a bug (or combination thereof) in the older 7.1 version.

    Regards and best wishes,

    Justin Clift


    Erik Luke wrote:
    Operating system: SuSE 7.2 Professional with postgres v7.1 installed
    manually.
    (I prefer to manually set up software)
    Directory: /postgres
    Data Directory: /var/lib/pgsql/data
    Options: ODBC emabled
    Server startup line: postmaster -i -D /var/lib/pgsql/data > logfile.txt &
    Port: 9427
    System: AMD Athalon 1.4 Ghz, 512 MB Ram, D-Link network card

    Upon trying to connect to the postgres backend by psql (with password
    authentication enabled), postgres crashes saying "FATAL 1: Bad abstime
    external representation ' '". I have also gotten '@!' and '/g!' in addition
    to the ' '. The Postgres backend then terminates abnormally.

    The '' was reported at debug_level 0, the '@!' was reported at debug_level
    5, and the '/g!' was reported at debug_level 9. The psql string used to
    connect was simply psql (database name). Adding additional paramaters, such
    as -U have resulted in the same problem. When trying to channel the info
    into a logfile, I did not have any luck, as the output file was empty.
    Installation instructions were followed exactly.

    Thanks

    Erik Luke
    eluke@cs.montana.edu

    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
    --
    "My grandfather once told me that there are two kinds of people: those
    who work and those who take the credit. He told me to try to be in the
    first group; there was less competition there."
    - Indira Gandhi
  • Tom Lane at Aug 20, 2001 at 3:08 pm

    "Erik Luke" <eluke@cs.montana.edu> writes:
    Upon trying to connect to the postgres backend by psql (with password
    authentication enabled), postgres crashes saying "FATAL 1: Bad abstime
    external representation ' '". I have also gotten '@!' and '/g!' in addition
    to the ' '.
    It would seem that there's bogus info in the "valid until" column of
    your password file. What's in $PGDATA/pg_pwd?

    regards, tom lane
  • Tom Lane at Aug 20, 2001 at 3:25 pm

    I said:
    It would seem that there's bogus info in the "valid until" column of
    your password file. What's in $PGDATA/pg_pwd?
    Ooops, make that $PGDATA/global/pg_pwd

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedAug 20, '01 at 1:18p
activeAug 20, '01 at 3:25p
posts4
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase