From: | Reed Kempf <rkempf(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | postgresql database password |
Date: | 2005-11-12 16:48:07 |
Message-ID: | 1602c7880511120848t2eb618efre236cebe9d452dba@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello all,
I am new to postgres but have a pretty extensive background in Oracle. I
need a little help starting out with some basic concepts.
I have downloaded 8.1 on my linux box and have created a database called
test. I also have created a login role called test with password <test>.
I use this login from the linux command line. psql -h localhost -p 5432 -U
test -W
I read that the -W prompts for a password. I give the password test which I
set up when I created the user test and it let me in. The problem is I also
run the same command line login and didn't specify a password.
Am I missing something with authentication, perhaps a config file setting.
In Oracle, the heirarchy is server -> database -> schema(s). The database
itself would not have a password associated with it but each schema would to
be able to access their objects within the database with a password (or
not).
It appears that postgresql works a bit differently. I have looked in the
documentation for 8.1 but nothing seems to jump out at me.
Any help or pointers in the right direction would be awesome.
Regards,
ReedK
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-12 17:40:53 | Re: postgresql database password |
Previous Message | Tom Lane | 2005-11-12 15:30:06 | Re: Loop through records |