Thread: initdb in 6.5 not creating 'postgres' db
Just installed 6.5, all seems well, but it wont start - claims initdb didn't creat the database 'postgres' ... whats happening here ? thanks Bob --- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive! 4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of the original DJ's - back on air - and supporting not only the original Vets, in comprehensive AFVN Archives, but putting together segments for the fighting men and women of todays services all around the world. World Music, for people of the world.
On Wed, 16 Jun 1999, Robert Chalmers wrote:
> Just installed 6.5, all seems well, but it wont start - claims initdb didn't
> creat the database 'postgres' ...
> whats happening here ?
initdb only creates `template1'. you have to `createdb postgres' for
yourself if you even want the postgres user to have it's own personal
database.
____________________}John Flinchbaugh{______________________
| -> glynis@hjsoft.com <- john@cs.millersv.edu |
| glynis@netrax.net http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~
On Wed, 16 Jun 1999, John M. Flinchbaugh wrote:
> On Wed, 16 Jun 1999, Robert Chalmers wrote:
> > Just installed 6.5, all seems well, but it wont start - claims initdb didn't
> > creat the database 'postgres' ...
> > whats happening here ?
>
> initdb only creates `template1'. you have to `createdb postgres' for
> yourself if you even want the postgres user to have it's own personal
> database.
So, just to elaborate on the problem report to start with, the problem is
starting up the back and just typing 'psql', vs 'psql template1'?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
Thats what I thought but when I tried to run the backend to test it with
postmaster -i
It complained that the database 'postgres' didnt exist... I know., use
postmaster -i template1 I suppose?
thanks
Bob
----- Original Message -----
From: John M. Flinchbaugh <glynis@butterfly.hjsoft.com>
To: <pgsql-general@postgreSQL.org>
Sent: Thursday, 17 June 1999 1:56
Subject: Re: [GENERAL] initdb in 6.5 not creating 'postgres' db
> On Wed, 16 Jun 1999, Robert Chalmers wrote:
> > Just installed 6.5, all seems well, but it wont start - claims initdb
didn't
> > creat the database 'postgres' ...
> > whats happening here ?
>
> initdb only creates `template1'. you have to `createdb postgres' for
> yourself if you even want the postgres user to have it's own personal
> database.
>
> ____________________}John Flinchbaugh{______________________
> | -> glynis@hjsoft.com <- john@cs.millersv.edu |
> | glynis@netrax.net http://www.hjsoft.com/~glynis/ |
> ~~Powered by Linux: Reboots are for hardware upgrades only~~
>
>
>
On Thu, 17 Jun 1999, Robert Chalmers wrote:
> Thats what I thought but when I tried to run the backend to test it with
> postmaster -i
> It complained that the database 'postgres' didnt exist... I know., use
> postmaster -i template1 I suppose?
actually, start postmaster as usual.
by default, initdb only creates template1, and psql defaults to trying to
open a database with the user's name, so user john's default database name
is `john'. psql run as user postgres tries to open the `postgres'
database.
`psql template1' to open a database other than the default. the
postmaster still manages all the different databases, so you don't need to
tell it on the commandline.
if you want to create new databases, then just run `createdb <name>', so
if you wanted postgres to have it's `postgres' database you must run
`createdb postgres'.
____________________}John Flinchbaugh{______________________
| -> glynis@hjsoft.com <- john@cs.millersv.edu |
| glynis@netrax.net http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~