Re: Add user on old database with password - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: Add user on old database with password
Date
Msg-id Pine.LNX.4.44.0306131713550.1360-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Add user on old database with password  ("Ramesh PAtel " <ramesh@banas.guj.nic.in>)
List pgsql-admin
> 1) create one user with password and all Grant on Database. it is a admin
> user

The below steps would help:

$ su - postgres
$ createuser your_user
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER

Use GRANT command to grant privileges to specified user.

> 2) i want to add password to postgres user.

1) If the authentication mode is trust then it is simple. Connect to any
database as postgres and using alter user you must be able to set password
for postgres user.

2) If the authentication mode is any other, then you may not be able to
connect to any database as postgres user, since you didn't set password
for postgres user. So, set the authentication mode to trust and restart
postmaster and repeat step one to set password for postgres user. Finally
restore the authentication mode.

regards,
bhuvaneswaran



pgsql-admin by date:

Previous
From: "Ramesh PAtel "
Date:
Subject: Add user on old database with password
Next
From: "kopra"
Date:
Subject: Re: DUMPall PG7.1.3 restore to PG7.3.2