Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?

From: PMC OS <pmcos-support(at)freenet(dot)de>
To: PMC OS <pmcos-support(at)freenet(dot)de>,pgsql-general(at)postgresql(dot)org
Subject: Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?
Date: 2010-08-24 19:53:21
Message-ID: c373801c0059b804007ca9fc2a071853@email.freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

OK, now I can connect to the PostgreSQL Server but it is weird...

> -----Ursprüngliche Nachricht-----
> and in the pg_hba.conf
> local all postgres ident sameuser
> host system root 192.168.0.0/24 md5

I can not use "root" as the owner of the database...

Now I have created a user named "system" and changed from "root" to "system" is now working

Can someone tell me the command line, how to restrict the access to DB "system" to user "system" only?

Thanks

--

Exklusiv: Neue E-Mail-Adresse @iPhone.de jetzt verfügbar!
Sichern Sie sich jetzt ihre persönliche http://www.iphone.de/iphonemail/index.html?pid=10111947021

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-08-25 02:01:11 Re: How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?
Previous Message PMC OS 2010-08-24 19:02:06 How to setup PostgreSQL to work with libpam-pgsql/libnss-pgsql2?