Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres user - Mailing list pgsql-admin

From rakesh
Subject Re: postgres user
Date
Msg-id 007a01c3266d$e24fb0b0$0a00a8c0@cygnus.com
Whole thread Raw
In response to postgres user  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
Tree view
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 -----
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

pgsql-admin by date:

Previous
From: "Anagha Joshi"
Date:
Subject: postgres user
Next
From: Bob Wheldon
Date:
Subject: unsubscribe