Skip site navigation (1) Skip section navigation (2)

Re: First Install

From: "Kevin Crenshaw" <kcrenshaw(at)viscient(dot)com>
To: "'Williams, Rodger'" <Rodger(dot)Williams(at)bdsol(dot)co(dot)za>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: First Install
Date: 2005-10-25 13:47:05
Message-ID: 20051025134703.63593DAE05@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
Rodger,

In response to your first question:  Postgres creates the 'postgres' user
and the database 'template1' automatically after installation.  You should
be able to execute this command to log in:  psql -U postgres -d template1
After you have logged in, you can type:  'create database dbname;'
That will create a new database for you.

Sorry, but I can't help you with your second question.


HTH,

Kevin

 

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Williams, Rodger
Sent: Tuesday, October 25, 2005 8:52 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] First Install

Q1
Is there another way to create the first DB after a fresh install?
I used the createdb executable.
I read that this is a wrapper for executing create database sql command.
If I don't want to use the executable wrapper to create the first DB
after a fresh install, how do I create the first DB without using
pgAdmin? i.e How do I create the first user, first tablespace and first
DB?
I can't login via psql because there is no database to log into after a
fresh install.

Q2
After I installed PostgreSQL 8.0.3, I Logged in via pgAdmin as db user
postgres.
With pgAdmin tool, I created a user, tablespace and database.
Installed a third party software app that uses the newly created
database.
Installation failed.
I edited postgresql.conf (changed listen_adddress) and edited pg_hba
(added trust entry).
Reinstalled software application to use newly created database, which
now works fine.
Database still runs.
I just can't login via pgAdmin anymore.
I get an error "fe_sendauth: no password supplied".
Previously it would give me an opertunity to enter the postgres user
password. Now it does not.

From
Rodger

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2005-10-25 14:01:54
Subject: Re: pg_dump ordering problem
Previous:From: Salerno, VincentDate: 2005-10-25 13:45:30
Subject: unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group