Thread: Help with dying postmaster on win2k...

Help with dying postmaster on win2k...

From
"Ramos-1, Frankie"
Date:
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

Re: Help with dying postmaster on win2k...

From
Jason Tishler
Date:
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