Re: postgres on SuSE 9.1

Dear my friend, Scott...

It's solved... Thank you very...very much, my
friend...

I still have one question. I also have one station at
home with SuSE 8.2. Why this postgres from SuSE 8.2
does not have "pg_hba.conf"?
and how can I use pgaccess to access into the postgres
server?
And its "postgresql.conf" is also different as the one
from SuSE 9.2.

Thank you very much in advance.
--- Scott Marlowe <smarlowe@qwest.net> wrote:
> On Mon, 2004-06-07 at 10:38, Prabu Subroto wrote:
> > Dear my friends...
> >
> > Usually I use MySQL. Now I have to migrate my
> database
> > from MySQL to Postgres.
> >
> > I have created a database successfully with
> "creatdb"
> > and a user account successfully.
> >
> > But I can not access the postgres with pgaccess.
> >
> > I found this error message :
> > "
> > Error trying to connect to database 'custadm' on
> host
> > localhost
> >
> > PostgreSQL error message: Connection to database
> > failed
> > could not create socket: HpHlH
>
> You need to do two things, likely:
>
> edit $PGDATA/postgresql.conf and turn on
> tcpip_socket = true, then edit
> $PGDATA/pg_hba.conf and add your machine IP with an
> appropriate
> authentication method for your needs there.  The
> line will look
> something like this:
>
> local  all    all             ident   sameuser
>
> or
>
> host  all   all   127.0.0.1    255.0.0.0   trust
>
> or something similar.  Then restart postgresql and
> you're golden.
>
>
>





__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/