Thread: Help with dying postmaster on win2k...

Hi.  I'm trying to get postgres to work on my w2k machine, I installed from the cygwin website everything.  Got the ipc
package,followed the instruction in doc/cygwin/post...  Everything seemed to work fine, initdb initialized with no
error,etc. 

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?  Any help would be more than appreciated.

Thanks in advance.

Frankie

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