Yes TCP/IP was set to to "true". As mentioned previously, there is no
problem with postmaster as I use it regularly.
So my problem remains that I cannot connect to PostgreSQL through Open
Office by JDBC using these parameters
URL -jdbc:postgresql://localhost/accs
Driver -org.postgresql.Driver
Username -xxxxx
Character Set -system
Any ideas?
Scott
On Mon, 2002-12-16 at 22:07, Fernando Nasser wrote:
> Scott Taylor wrote:
> > In the "new data source" in OO where the driver information is, it asks
> > for username and password. I assume it means for PostgreSQL not the
> > system?
> >
> > I am on the same machine as the server, and my pg_hba.conf file has the
> > following access:
> >
> > # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
> > AUTH_ARGUMENT
> >
> > local all trust
> > host all 127.0.0.1 255.255.255.255 trust
> >
> > # Using sockets credentials for improved security. Not available
> > everywhere,
> > # but works on Linux, *BSD (and probably some others)
> >
> > local all ident sameuser
> >
>
> This would still not let you connect using TCP/IP. You must start your
> postmaster with '-i' or change the line in your postgresql.conf file from:
>
> #tcpip_socket = false
>
> to:
>
> tcpip_socket = true
>
> i.e., uncomment it and make it true (and restart your server).
>
>
> psql will connect regardless as it will use Unix sockets for a local database by
> default.
>
> --
> Fernando Nasser
> Red Hat - Toronto E-Mail: fnasser@redhat.com
> 2323 Yonge Street, Suite #300
> Toronto, Ontario M4P 2C9
>
--
Scott Taylor
Managing Director
4i dotCom
Phone: +44 7767 257 371
Email: scott.taylor@4i-dotcom.com
Web: http://www.4i-dotcom.com
This transmission is confidential and intended for the named recipient
only. Should you not be the person or entity named, please be advised
that you have received this in error, and that you should delete this
immediately.
"µú¡ ÛûÚV´}_aGG)O¤ÇÞäïeØW `îÀOÃüÀJèeBò ˵ýõ[\%ð;.Aó¶ ¡UGÒ~å?~¹PÉFÃL¬7¾tI