On Thu, Aug 26, 1999 at 11:55:14AM +0100, [EMAIL PROTECTED] wrote > Hallo all, > I've just installed the postgres stuff ok, but I thought I'd check out > a thought before I upset something. > I understand that user 'postgres' is the dba for postgres. It is user > postgres who adds and deletes users and > databases. Is it safe to change the password for user postgres? At the > moment I can only access the user by su'ing from root, is this the accepted > way of doing it? > Suggestions please. > I'd appreciate a cc as well 'cos I'm not at home at the moment. Thanks >
postgres is the user that owns the postgres data files, and the user that the postmaster is run as (much as www-data is for apache). A better plan is to su to postgres only to make your human dba's username a postgres user, and give him the ability to create users and databases. It would be best if the user postgres had an invalid password (*), like ftp and mail do. John P. -- [EMAIL PROTECTED] [EMAIL PROTECTED] "Oh - I - you know - my job is to fear everything." - Bill Gates in Denmark
