|
Home > Archive > PostgreSQL Newbies > February 2006 > How to enable remote anoymous logins? (+ admin books?)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to enable remote anoymous logins? (+ admin books?)
|
|
| kynn@panix.com 2006-02-28, 8:31 pm |
|
Hi. What must I do to enable remote anonymous logins to our
PostgreSQL server? What determines whether a password is required?
Is it possible to require that the password be the user's e-mail
address? Does the server keep record of all connections?
(BTW, our server is version 8.0, and runs on Linux.)
As you can see, I have many questions, too many in fact! I have not
had much luck finding good resources on *administering* a PostgreSQL
server. Are there any good books for this? Or other resources for
the novice dbadmin? I'm particularly interested in stuff on
administering PostgreSQL on Linux/Unix.
Many thanks in advance!
kj
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Andrej Ricnik-Bay 2006-02-28, 8:31 pm |
| On 2/28/06, kynn@panix.com <kynn@panix.com> wrote:
>
>
>
> Hi. What must I do to enable remote anonymous logins to our
> PostgreSQL server? What determines whether a password is required?
I'd suggest you start by reading the FAQ, and the excellent documentation.
As for the authentication, look at $PGDATA/pg_hba.conf ....
> Is it possible to require that the password be the user's e-mail
> address? Does the server keep record of all connections?
How is it anonymous if you require his password? Or do
you just want to keep track of who it is that logged in without
actual authentication?
As for the recording: it will if you tell it to, again, read the
excellent documentation.
> As you can see, I have many questions, too many in fact! I have not
> had much luck finding good resources on *administering* a PostgreSQL
> server.
Look at again. http://www.postgresql.org/docs/
> Are there any good books for this? Or other resources for
> the novice dbadmin? I'm particularly interested in stuff on
> administering PostgreSQL on Linux/Unix.
There's a couple ... have a search on Amazon for PpostgreSQL
Cheers,
Andrej
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| kynn@panix.com 2006-02-28, 8:31 pm |
|
Date: Tue, 28 Feb 2006 06:50:51 +1300
From: "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
On 2/28/06, kynn@panix.com <kynn@panix.com> wrote:
> Is it possible to require that the password be the user's e-mail
> address? Does the server keep record of all connections?
How is it anonymous if you require his password?
I meant "anonymous" in the same spirit as "anonymous FTP", which often
requests an e-mail address as password. I realize that often it is
possible for users to enter anything in response to this request, but
it is still helpful with users who choose to satisfy the request.
> Are there any good books for this? Or other resources for
> the novice dbadmin? I'm particularly interested in stuff on
> administering PostgreSQL on Linux/Unix.
There's a couple ... have a search on Amazon for PpostgreSQL
That was my initial approach, and I ended up with a book that did not
answer the questions I just posted. Hence I thought I would ask those
with more knowledge for some specific recommendations.
kj
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|
|