pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



Message-ID: <20050502021339.M43779@medinomics.com>
Permalink:  ../20050502021339.M43779@medinomics.com/
Also on:    postgresql.org/message-id/20050502021339.M43779@medinomics.com

 · 

reply

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