psql -l gives bad output - Mailing list pgsql-general

From Jeff Beck
Subject psql -l gives bad output
Date
Msg-id 1022037291.23388.5.camel@mercury
Whole thread Raw
List pgsql-general
Hi, I am running PostgreSQL 7.1.3 on Solaris 8.

The output of psql -l seems wrong.  In the following, their are 2
databases named "pay-test" and one named "/usr/local/pgsql/bi".  I can
dropdb one of the pay-tests but not the other, and I can't dropdb the
/usr/local/pgsql/bi database.  I can't access these databases either.
vacuumdb -a gives me an error too, when attempting to access these
databases.

# psql -U postgres -l
             List of databases
            Database             |  Owner
---------------------------------+----------
 pay                             | postgres
 pay-test                        | postgres
 pay-test
/usr/local/pgsql/bi | postgres
 template0                       | postgres
 template1                       | postgres
(5 rows)

Does anyone have any ideas?

Thanks,
Jeff



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: ERROR: value too long for type character varying(255)
Next
From: Roberto Andrade Fonseca
Date:
Subject: Pgsql and the MARC standards