Re: How to set up postgres user - Mailing list pgsql-novice

From santoso berkah
Subject Re: How to set up postgres user
Date
Msg-id 20030920231430.30793.qmail@web40705.mail.yahoo.com
Whole thread Raw
In response to Re: How to set up postgres user  (santoso berkah <im_id@yahoo.com>)
List 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@sss.pgh.pa.us> wrote:
> > santoso berkah <im_id@yahoo.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@postgresql.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@postgresql.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

pgsql-novice by date:

Previous
From: "Balazs Wellisch"
Date:
Subject: Re: Postgresql startup script on RH9
Next
From: Anshuman Kanwar
Date:
Subject: Create tables based on another table