Re: [cobalt-users] PostgreSQL?

[Duncan Laurie <duncan@xxxxxxxxxx>]

the problem is that postgreSQL has little or no security by default, so it has
been set up to restrict access by password only.  this means that users without
a password (postgres being one) will not be able to connect at all.  

so if you modify /home/pgsql/pg_hba.conf (first line is new):

local template1 trust
local all crypt

then "su - postgres" and perform any administrative tasks, like

createdb exampledb
createuser duncan
psql -d template1 -c "ALTER USER duncan WITH PASSWORD foo"

and when you are done i would return the /home/pgsql/pg_hba.conf file to:

local all crypt

then if you want to connect to a database as a user you must use psql with the
-u option:

psql -u exampledb
and authenticate with username/password created earlier

-duncan

On Tue, 14 Dec 1999, Webmaster wrote:
> Date: Tue, 14 Dec 1999 17:06:15 -0600
> To: cobalt-users@xxxxxxxxxxxxxxx
> From: Webmaster <webmaster@xxxxxxxxxxxx>
> Reply-To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: [cobalt-users] PostgreSQL?
> 
> So we have this RAQ3i.
> 
> PostgreSQL is installed by Cobalt standard to handle the admin database I 
> assume as it loads up on boot automatically and shows in the fancy little 
> LCD display on the front.
> 
> OK!
> 
> Now, I want to know has anyone used the installed PostgreSQL for their own 
> web databases or did you install another db system and use that instead?
> 
> WHY?
> 
> Because I would like to use PostgreSQL and see no reason to install again.
> 
> YET!
> 
> I cannot seem for the life of me between the Cobalt site, manual, 
> PostgreSQL site/s, etc. to create a new database let alone get into psql 
> command line interface.
> 
> I keep getting password not supplied for 'template1' database and similar 
> messages, logged in as root, admin, and various users.
> 
> The template1 db is used as a template to create ALL new db's.
> 
> I really need some assistance on this and it ain't gonna come from Cobalt 
> apparently.
> 
> Thanks!
> 
> Jeff Rubin, CTO
> Audiopia
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-users