Re: [ADMIN] Cannot install postgreSQL

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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005