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
_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-users