From: sv <sv@medinomics.com>
To: pgsql-admin@postgresql.org
Subject: Getting Started Basic Admin
Date: Sun, 1 May 2005 21:13:39 -0500
Message-ID: <20050502021339.M43779@medinomics.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sv@medinomics.com
Subject: Re: Getting Started Basic Admin
In-Reply-To: <20050502021339.M43779@medinomics.com>
References: <20050502021339.M43779@medinomics.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox