Re: What Could Cause This Behavior?

On Fri, 27 Jan 2006, Michael Glaesemann wrote:

> Could you provide a sample session, from login to psql to logout? The added
> information may give someone on the list more insight into what's going
> wrong.

Michael,

Sure:

[rshepard(at)salmo ~]$ su postgres
Password:
postgres(at)salmo:/home/rshepard$ psql
Welcome to psql 8.1.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# create database testcase
postgres-# \q
postgres(at)salmo:/home/rshepard$ psql -l
List of databases
Name | Owner | Encoding
-------------+------------+-----------
aesi | sql-ledger | LATIN1
contacts | rshepard | SQL_ASCII
eiabusiness | rshepard | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
test | postgres | SQL_ASCII
webcollab | rshepard | SQL_ASCII
(8 rows)

postgres(at)salmo:/home/rshepard$ exit
exit
[rshepard(at)salmo ~]$

> Without adding a database to connect to, psql defaults to connect to a
> database with the same name as the user. As of PostgreSQL 8.1, there is a
> default database named postgres. When use run psql as user postgres, you
> should be connecting to the postgres database.

Ah! I see.

> You may also want to read the release notes (in the documentation or on the
> website) to see if there are other changes that may be unknowingly
> affecting you.

I will certainly do this. I was aware of changes and that's why I bought
the Douglas/Douglas book. Regardless, I'll read the release notes and my pdf
copy of the manual.

Thanks,

Rich

--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863