FAQ
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

Search Discussions

  • Rakesh at May 30, 2003 at 5:49 am
    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@postgresql.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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedMay 30, '03 at 4:56a
activeMay 30, '03 at 5:49a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Rakesh: 1 post Anagha Joshi: 1 post

People

Translate

site design / logo © 2022 Grokbase