Re: How to set up postgres user

Hello Friends,

I try to follow your instruction to set up the
pg_hba.conf and it was worked. Thanks for your help.

And i have some trouble :
When i try to connect the Python file and PostgreSQL
service (under postgres user), it was works, but
when
i try the GUI application using Tkinter, there was
an
error messages:

bash-2.05$ python InputBiodataAdministrasiwithDB.py
Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified

Traceback (most recent call last):
File "InputBiodataAdministrasiwithDB.py", line 24,
in
?
root = Tk()
File "/usr/lib/python2.2/lib-tk/Tkinter.py", line
1487, in __init__
Tclerror: couldn't connect to display ":0"

Can you tell me how to fix the problem:
1. To make the user postgres have the authority for
acessing xserver (Xwindow).> 2. To make the other
user such as John to have an
access as same as the user postgres.

Thank you very much for your help.

Best Regards,

Santoso

> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > santoso berkah <im_id(at)yahoo(dot)com> writes:
> > > I try to set up the pg_hba.conf:
> >
> > > localhost mindik 192.168.0.3 trust
> >
> > BTW, this is certainly wrong... PG 7.2 supports
> > these two syntaxes:
> >
> > # Unix sockets:
> > local all
>
> > trust
> > # TCP sockets:
> > host all 127.0.0.1
> 255.255.255.255
> > trust
> >
> > You might perhaps also want
> > host all 192.168.0.3
> 255.255.255.255
> > trust
> > or
> > host all 192.168.0.0 255.255.255.0
>
> > trust
> > depending on your local network setup.
> >
> > regards, tom lane
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list
cleanly

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com