Re: postgres user

Hello,

I don't think you are providing the database name along with psql command as "postgres" user.
bash-2.05$ psql <database name> ( is an appropriate syntax. )

What you see is this=>
++++++++++++++++++++++++++++++++++++++++++++++++++++
bash-2.05$ psql
psql: FATAL 1: Database "postgres" does not exist in the system catalog.
bash-2.05$ psql template1
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

template1=# \q

++++++++++++++++++++++++++++++++++++++++++++++++++++

regards,
Rakesh P.
----- Original Message -----
From: Anagha Joshi
To: pgsql-admin(at)postgresql(dot)org
Sent: Friday, May 30, 2003 10:26 AM
Subject: [ADMIN] postgres user

Hi,

I've installed Postgres-7.3.2 on Linux. When I'm trying to start 'psql' as user 'postgres', I found error :

psql: FATAL 1: Database "postgres#" does not exist in the system catalog.

/etc/passwd shows entry like this:

postgres:x:1078:1:PostgreSQL-administrator:/usr/local/pgsql:/bin/sh

Is any other setting is reqd.?

Help appreciated.

Thx.,

Anagha