Getting Started Basic Admin

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

Browse pgsql-admin by date

  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?