Skip site navigation (1) Skip section navigation (2)

Re: [Fwd: Re: Problem in connecting to database]

From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: s?b??i?????? Iy?? <sabari(dot)us(at)gmail(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 05:46:24
Message-ID: 4CD8E030.6070406@softjin.com (view raw or flat)
Thread:
Lists: pgsql-in-general
Hi Sabarinathan,
I have installed tomcat 6 and postgresql 9 on the same machine.
I am trying to upgrade my postgresql from 8.1 to 9. Also I am trying to 
upgrade
tomcat from 5.5 to 6.
For me tomcat 5.5 and postgresql 8.1 combination is working fine.
I am coming across this problem while upgrading.
Regards,
Rekha.
s?b??i?????? Iy?? wrote:
> hi Rekha,
>        Please check using telnet from machine from where your trying 
> to connect .
>
> -- 
> Best Regards and Thanks,
> S.Sabarinathan .
>
>
>
>
> On 9 November 2010 10:53, Rekha Ravi Pai <rekha(at)softjin(dot)com 
> <mailto:rekha(at)softjin(dot)com>> wrote:
>
>     Hi,
>     In my postgresql.conf file I have added these key values.
>
>     tcpip_socket = true
>     max_connections = 100
>     port = 5432
>     shared_buffers = 1000
>     log_connections = yes
>     search_path = '$user,public'
>
>     lc_messages = 'en_US.UTF-8'        # locale for system error
>     message strings
>     lc_monetary = 'en_US.UTF-8'        # locale for monetary formatting
>     lc_numeric = 'en_US.UTF-8'        # locale for number formatting
>     lc_time = 'en_US.UTF-8'
>
>
>     Regards,
>     Rekha.
>
>
>     Business Disclaimer
>     ____________________________________________________________
>     This e-mail message and any files transmitted with it are intended
>     solely
>     for  the use  of the  individual or entity  to which they  are
>      addressed. It
>     may  contain confidential,  proprietary or legally  privileged
>      information.
>     If  you  are  not  the  intended recipient please be advised that
>     you have
>     received  this  message in error and any use is strictly
>     prohibited. Please
>     immediately  delete it  and all copies of it from your system,
>     destroy any
>     hard  copies  of  it and  notify  the  sender  by return mail. You
>     must not,
>     directly or indirectly, use,  disclose,  distribute, print, or
>     copy any part of
>     this message if you are not the intended recipient.
>     ___________________________________________________________
>
>     where is port no 5432 in url
>
>     On Mon, Nov 8, 2010 at 2:00 PM, Rekha Ravi Pai <rekha(at)softjin(dot)com
>     <mailto:rekha(at)softjin(dot)com>> wrote:
>
>         Hi,
>         I have installed postgresql 9.0 and tomcat 6.0.
>         I created the jsp page given below.
>         ---------------------------------------------------------------------------------------------------
>         <html>
>         <head>
>         </head>
>         <%@ page language="java" import="java.sql.*, beans.*" %>
>         <%!
>         Connection myConn=null;
>         %>
>         <body>
>         <%
>         //PasswordEncryptService p = new PasswordEncryptService();
>         try{
>         Class.forName("org.postgresql.Driver").newInstance();
>         myConn=DriverManager.getConnection("jdbc:postgresql://localhost/postgres?user=postgres&password=postgres");
>         out.println("myConn :"+myConn.toString());
>         }catch(Exception e){
>             out.println(e.toString());
>         }
>         out.println("myConn :");
>         %>
>         <B>Done</B>
>         </body>
>         </html>
>         -------------------------------------------------------------------------------------------------------------------------------
>         On running the web page I am getting the following error.
>         org.postgresql.util.PSQLException: Connection refused. Check
>         that the hostname and port are correct and that the postmaster
>         is accepting TCP/IP connections.
>
>         Can anybody help me in this regard?
>
>         Regards,
>         Rekha
>
>         Business Disclaimer
>         ____________________________________________________________
>         This e-mail message and any files transmitted with it are intended solely
>         for  the use  of the  individual or entity  to which they  are  addressed. It
>         may  contain confidential,  proprietary or legally  privileged  information.
>         If  you  are  not  the  intended recipient please be advised that you have
>         received  this  message in error and any use is strictly prohibited. Please
>         immediately  delete it  and all copies of it from your system, destroy any
>         hard  copies  of  it and  notify  the  sender  by return mail. You must not,
>         directly or indirectly, use,  disclose,  distribute, print, or copy any part of
>         this message if you are not the intended recipient.
>         ___________________________________________________________
>               
>
>
>
>
>     -- 
>     Rajesh Sirsat
>
>
>     --
>     Sent via pgsql-in-general mailing list
>     (pgsql-in-general(at)postgresql(dot)org
>     <mailto:pgsql-in-general(at)postgresql(dot)org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-in-general
>
>



Business Disclaimer
____________________________________________________________
This e-mail message and any files transmitted with it are intended solely
for  the use  of the  individual or entity  to which they  are  addressed. It
may  contain confidential,  proprietary or legally  privileged  information.
If  you  are  not  the  intended recipient please be advised that you have
received  this  message in error and any use is strictly prohibited. Please
immediately  delete it  and all copies of it from your system, destroy any
hard  copies  of  it and  notify  the  sender  by return mail. You must not,
directly or indirectly, use,  disclose,  distribute, print, or copy any part of
this message if you are not the intended recipient.
___________________________________________________________

In response to

Responses

pgsql-in-general by date

Next:From: Jayadevan MDate: 2010-11-09 05:50:23
Subject: Re: [Fwd: Re: Problem in connecting to database]
Previous:From: sαbαяiиαŧЋαи IyєяDate: 2010-11-09 05:39:18
Subject: Re: [Fwd: Re: Problem in connecting to database]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group