Re: Help with dying postmaster on win2k...

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