Re: [ADMIN] Cannot install postgreSQL - Mailing list pgsql-admin

From Ross J. Reedstrom
Subject Re: [ADMIN] Cannot install postgreSQL
Date
Msg-id 20000307141438.B22084@rice.edu
Whole thread Raw
In response to Re: [ADMIN] Cannot install postgreSQL  (Roman Kurmanowytsch <romank@infosys.tuwien.ac.at>)
Responses Re: [ADMIN] Cannot install postgreSQL
Re: [ADMIN] Cannot install postgreSQL
List pgsql-admin
On Tue, Mar 07, 2000 at 07:44:39PM +0100, Roman Kurmanowytsch wrote:
> Oliver,
>
> >There is no database called "romkur", because you haven't yet created it.
> >
> >When initdb is run, it creates a database called template1; this is the
> >only database that exists until you create some more.
> >
> >When you try to connect as a database user, postgres assumes you want
> >your eponymous database, unless you tell it different.  So tell it
> >you want to connect to template1.
>
> Sorry, I don't get it.
>
> >From the postgresql-6.5.2/INSTALL file:
> ------------------------------------------------------
> ...
> 18. $ initdb...
> 19. Set up permissions to access the database...
> 20. Briefly test that the backend will start and
>     run by running it from the command line.
>     a. Start the postmaster daemon running in the
>        background by typing
>        $ cd
>        $ nohup postmaster -i > pgserver.log 2>&1 &
>     ...
> ------------------------------------------------------

From your first post to HACKERS:

> Seems OK to me, but when I run postgres (after starting the ipc daemon) with:
> postgres.exe -i
> I get the following error-message:
>

Postgres is different than postmaster. Although they're the same
executable, you get different behavior based on the name it's invoked
as. As postmaster, it's the daemon that serves incoming connections. As
postgres, it starts up a 'backend' proceess that access the db files. So,
yes, by running postgres.exe you _were_ trying to access the database
romkur.

Ross

--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

pgsql-admin by date:

Previous
From: Roman Kurmanowytsch
Date:
Subject: Re: [ADMIN] Cannot install postgreSQL
Next
From: "Daniel J. Blezek, Ph.D."
Date:
Subject: Exec limit in pgtclsh