From: | "sv" <sv(at)medinomics(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Getting Started Basic Admin |
Date: | 2005-05-02 02:13:39 |
Message-ID: | 20050502021339.M43779@medinomics.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I am very confused. I have a Debian server with PostGreSQL running. I have
everything installed and working.
Here is my wish list:
1. To do anything, I have to "su - postgres". This has no password. How do I
put a password on it. I have tried "passwd postgres wackypass" but it did
not work.
2. How do I add new users? When I add a regular user account in Linux does
it add a Postgres user automatically? I tried "createuser" and it works but
I can't login as that user in phpPgAdmin (front page login). Once I login
with the "false" security (see Question 3), I see all the users I added
with "createuser".
3. With phpPgAdmin, I can login because i turned "extra_login_security" to
false... not very secure. How does this relate to the adduser (Linux
account) and/or "createuser".
I am sorry about the questions. I have spent hours reading and piecing
together posts to try to reverse into my answers but have had no luck.
Thank you in advance,
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Enrico Weigelt | 2005-05-02 03:11:18 | Re: Suse 9.2 stops booting while starting the postgres-server |
Previous Message | Tom Lane | 2005-04-30 16:27:36 | Re: Backing up users? |