From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What Could Cause This Behavior? |
Date: | 2006-01-27 02:22:50 |
Message-ID: | Pine.LNX.4.63.0601261818010.3884@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2006-01-27 02:24:49 | Re: What Could Cause This Behavior? |
Previous Message | Stephan Szabo | 2006-01-27 02:06:26 | Re: What Could Cause This Behavior? |