Re: Help with dying postmaster on win2k... - Mailing list pgsql-cygwin

Frankie,

On Thu, Feb 28, 2002 at 11:14:19AM -0500, Ramos-1, Frankie wrote:
> When I try to run the postmaster I'm getting the followin error:
>
> $ /usr/bin/postmaster -D /usr/local/pgsql/data
> DEBUG:  database system was shut down at 2002-02-28 11:06:26
> DEBUG:  CheckPoint record at (0, 1563504)
> DEBUG:  Redo record at (0, 1563504); Undo record at (0, 0); Shutdown TRUE
> DEBUG:  NextTransactionId: 615; NextOid: 18720
> DEBUG:  database system is in production state
> FATAL 1:  Database "admin" does not exist in the system catalog.
> DEBUG:  shutting down
> DEBUG:  database system is shut down
>
> I have no idea of why it is looking for the admin database?

Because you are connecting from an account called "admin" and PostgreSQL
defaults to a database name that is the same as your logname.

> Any help would be more than appreciated.

See the usage statement from psql:

    $ psql --help
    This is psql, the PostgreSQL interactive terminal.

    Usage:
      psql [options] [dbname [username]]
    ...

So, try supplying a database argument.  For example:

    $ psql template1

Jason