Обсуждение: 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
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.
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
\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 JoshiSent: Friday, May 30, 2003 10:26 AMSubject: [ADMIN] postgres userHi,
Ive installed Postgres-7.3.2 on Linux. When Im 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