Re: Authentication Failed - new user installation - Mailing list pgsql-general
| From | Scott Mead |
|---|---|
| Subject | Re: Authentication Failed - new user installation |
| Date | |
| Msg-id | d3ab2ec80903280921i3d327465n379871d3305000c4@mail.gmail.com Whole thread Raw |
| In response to | Authentication Failed - new user installation (ray <Ray.Joseph@CDICorp.com>) |
| Responses |
Re: Authentication Failed - new user installation
(Dave Page <dpage@pgadmin.org>)
|
| List | pgsql-general |
On Sat, Mar 28, 2009 at 3:51 AM, ray <Ray.Joseph@cdicorp.com> wrote:
That is correct. If you saw a red 'X' over the icon next to " PostgreSQL Database Server 8.2 (localhost:5432)" then the server would be offline.
Nothing :) A server (aka database cluster) can be started or stopped. Once started, a database server has multiple databases that you can connect to within it. If you drill-down beyond the 'postgres' database, you will see 'schemas'. Drill down further and you will see 'tables' etc...
The username / password will not be the same as your windows logon. It will be the postgres database username / password.
Try the username 'postgres' when connecting to another server.
To be honest though, I don't think you need to do this, it sounds like you just need to drill further into the 'postgres' database in the tree.
That is a user that was created in the operating system.
Postgres has 2 types of users:
*) OS user
There is only one of these (in your case). When postgres starts (look at the services control panel) it uses that windows logon to run the service. Postgres cannot be run as a 'root' or 'admin' user for security reasons, so the installer creates a user for you.
*) Database users
These are users inside the database cluster that have privileges on each table / object within the database. These users can be named the same as OS users, but for all intensive purposes, are in no way releated to windows users.
I'm not really sure you have a problem, just spend some more time clicking '+' signs in pgAdmin :)
--Scott
I have installed 8.2 on a Windows 2000 laptop.
I think it is installed. From the pgAdmin, it shows "Servers (1)" and
it is named PostgreSQL Database Server 8.2 (localhost:5432). Right
clicking for says I can stop services or disconnect so I am guessing
that it is running.
Is that correct?
That is correct. If you saw a red 'X' over the icon next to " PostgreSQL Database Server 8.2 (localhost:5432)" then the server would be offline.
Under that, there is a Databases(1) folder with the component
"postgres". Right clicking on it does not give a choice to start or
stop. What is this telling me?
Nothing :) A server (aka database cluster) can be started or stopped. Once started, a database server has multiple databases that you can connect to within it. If you drill-down beyond the 'postgres' database, you will see 'schemas'. Drill down further and you will see 'tables' etc...
On the file menu, when I select "add server" and fill in the boxes, I
get an error message "An error has occurred: Error connecting to the
server: FATAL: password authentication failed for user
myadminaccnt."
The username / password will not be the same as your windows logon. It will be the postgres database username / password.
When I setup 8.3, I used my myadminaccnt password for the
installation, I used it again on the next request for a password. So
I have used only it for all the requested passwords.
Try the username 'postgres' when connecting to another server.
To be honest though, I don't think you need to do this, it sounds like you just need to drill further into the 'postgres' database in the tree.
I don't know if this has any relationship, but when I installed 8.3, I
tried to use myadminaccnt as the user name but it said that was
missing a right so I elected to let 8.3 build a user "postgreadmin"
with the same password.
That is a user that was created in the operating system.
Postgres has 2 types of users:
*) OS user
There is only one of these (in your case). When postgres starts (look at the services control panel) it uses that windows logon to run the service. Postgres cannot be run as a 'root' or 'admin' user for security reasons, so the installer creates a user for you.
*) Database users
These are users inside the database cluster that have privileges on each table / object within the database. These users can be named the same as OS users, but for all intensive purposes, are in no way releated to windows users.
How can I go forward? When I build this again on another machine, how
do I avoid this problem?
I'm not really sure you have a problem, just spend some more time clicking '+' signs in pgAdmin :)
--Scott
TIA,
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pgsql-general by date: