From: | santoso berkah <im_id(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to set up postgres user |
Date: | 2003-09-20 23:14:30 |
Message-ID: | 20030920231430.30793.qmail@web40705.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Anshuman Kanwar | 2003-09-21 18:23:56 | Create tables based on another table |
Previous Message | Rod K | 2003-09-20 00:12:51 | Re: Postgresql startup script on RH9 |