FW: Creating DataBases on Suse LINUX Platform

oops forgot to send this to the group... apologies.

Larry

-----Original Message-----
From: Cook, Larry ISC
Sent: April 11, 2005 10:22 AM
To: 'brew@theMode.com'
Subject: RE: [NOVICE] Creating DataBases on Suse LINUX Platform


Hi Brew...

Thanx for responding..  I tried that already... as i figured that is how it
should
work, however, still get the same error message --> could not connect to
database template1: FATAL:  IDENT authentication failed for user "postgres".
This really has
me baffled. Do you think upgrading to 8.1 would help? I am getting a little
frustrated
trying to get this project going and don't really want to use Oracle. Any
other
suggestions?

Thanx for your time,
Larry

-----Original Message-----
From: brew@theMode.com [mailto:brew@theMode.com]
Sent: April 11, 2005 10:14 AM
To: 'pgsql-novice@postgresql.org'
Subject: Re: [NOVICE] Creating DataBases on Suse LINUX Platform



Larry.....

> You will need to become the operating system user under which PostgreSQL
> was installed (usually postgres) to create the first user account.
> According to the sys people it was installed over the network;
> presumably as the "root" user.

Yes, but even if it was installed on linux as root it creates the linux
user postgres as the root user of postgreSQL.

Log in to the linux box as root and then su to postgres. i.e.

su - postgres

Then create the database and database users there.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend