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

Lists: pgsql-in-general
From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: pgsql-in-general(at)postgresql(dot)org
Subject: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 05:23:21
Message-ID: 4CD8DAC9.1050002@softjin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

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.
___________________________________________________________

From: sαbαяiиαŧЋαи Iyєя <sabari(dot)us(at)gmail(dot)com>
To: Rekha Ravi Pai <rekha(at)softjin(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 05:39:18
Message-ID: AANLkTimq9KN1sZW-EyvpEWDBEv+OEY8CdKsXs=gEg3Qi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

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> 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> 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)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-in-general
>
>

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 베이SQL : Postg토토

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.
___________________________________________________________

From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: Rekha Ravi Pai <rekha(at)softjin(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 05:50:23
Message-ID: OF81EC18BC.7C8BEA6B-ON652577D6.001FEE0C-652577D6.00201462@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

Hi
> org.postgresql.util.PSQLException: Connection refused. Check that
> the hostname and port are correct and that the postmaster is
> accepting TCP/IP connections.
>
Are you able to connect from psql?
Regards,
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 05:58:12
Message-ID: 4CD8E2F4.2030807@softjin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 사이트 추천SQL

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Yes, I can connect to database using psql command.<br>
Regards,<br>
Rekha<br>
Jayadevan M wrote:
<blockquote
cite="mid:OF81EC18BC(dot)7C8BEA6B-ON652577D6(dot)001FEE0C-652577D6(dot)00201462(at)ibsplc(dot)com"
type="cite">
<pre wrap="">Hi
</pre>
<blockquote type="cite">
<pre wrap="">org.postgresql.util.PSQLException: Connection refused. Check that
the hostname and port are correct and that the postmaster is
accepting TCP/IP connections.

</pre>
</blockquote>
<pre wrap=""><!---->Are you able to connect from psql?
Regards,
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

</pre>
</blockquote>
<br>
<pre>

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.
___________________________________________________________
</pre></body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.2 KB
From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: Rekha Ravi Pai <rekha(at)softjin(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 06:04:04
Message-ID: OF71C5B830.6BE9E47F-ON652577D6.002107FB-652577D6.0021553E@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

Hi,
>
> Yes, I can connect to database using psql command.
You mentioned upgrading. Are you connecting to the new version? From psql,
does
postgres=# select version();
give you version as 9?
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 06:20:24
Message-ID: 4CD8E828.7040100@softjin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=US-ASCII" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jayadevan,<br>
After installing pgsql 9 and dumping an existing database,<br>
I was able to run the psql command and run sql queries as<br>
well.<br>
Today when I gave the psql command I came across this error.<br>
<font color="#cc0000">psql: could not connect to server: No such file
or directory<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Is the server running locally and accepting<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connections on Unix domain socket "/tmp/.s.PGSQL.5432"?</font><br>
Can you please help me to run the pgsql.<br>
Regards,<br>
Rekha<br>
<br>
Jayadevan M wrote:
<blockquote
cite="mid:OF71C5B830(dot)6BE9E47F-ON652577D6(dot)002107FB-652577D6(dot)0021553E(at)ibsplc(dot)com"
type="cite">
<pre wrap="">Hi,
</pre>
<blockquote type="cite">
<pre wrap="">Yes, I can connect to database using psql command.
</pre>
</blockquote>
<pre wrap=""><!---->You mentioned upgrading. Are you connecting to the new version? From psql,
does
postgres=# select version();
give you version as 9?
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

</pre>
</blockquote>
<br>
<pre>

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.
___________________________________________________________
</pre></body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.6 KB
From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: Rekha Ravi Pai <rekha(at)softjin(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 06:25:11
Message-ID: OF9BABADFD.2E546812-ON652577D6.0022DEAB-652577D6.002343F8@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

> After installing pgsql 9 and dumping an existing database,
> I was able to run the psql command and run sql queries as
> well.
> Today when I gave the psql command I came across this error.
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> Can you please help me to run the pgsql.
How do you usually start the server? Is it likely the server failed to
restart and you were getting the errors because the server was not up?
Check status of server
-bash-3.2$ pg_ctl status
pg_ctl: server is running (PID: 11456)
/usr/local/pgsql/bin/postgres

Start the server using
pg_ctl start

Regards,
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 06:32:02
Message-ID: 4CD8EAE2.2050807@softjin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=US-ASCII" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jayadevan,<br>
I gave the command <br>
&nbsp;<font color="#cc0000">postmaster -D /usr/local/pgsql/data &gt; logfile
2&gt;&amp;1 &amp;<br>
<font color="#000000">and it started.<br>
Now I could run the command psql.<br>
Also when I ran the query "select version();"<br>
I got the following result.<br>
<br>
&nbsp;<font color="#cc0000">PostgreSQL 7.4.13 on i686-redhat-linux-gnu,
compiled by GCC gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)</font><br>
It seems it shows the version from which I took the database to dump.<br>
Regards,<br>
Rekha<br>
<br>
</font></font>Jayadevan M wrote:
<blockquote
cite="mid:OF9BABADFD(dot)2E546812-ON652577D6(dot)0022DEAB-652577D6(dot)002343F8(at)ibsplc(dot)com"
type="cite">
<blockquote type="cite">
<pre wrap="">After installing pgsql 9 and dumping an existing database,
I was able to run the psql command and run sql queries as
well.
Today when I gave the psql command I came across this error.
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Can you please help me to run the pgsql.
</pre>
</blockquote>
<pre wrap=""><!---->How do you usually start the server? Is it likely the server failed to
restart and you were getting the errors because the server was not up?
Check status of server
-bash-3.2$ pg_ctl status
pg_ctl: server is running (PID: 11456)
/usr/local/pgsql/bin/postgres

Start the server using
pg_ctl start

Regards,
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

</pre>
</blockquote>
<br>
<pre>

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.
___________________________________________________________
</pre></body>
</html>

Attachment Content-Type Size
unknown_filename text/html 3.1 KB
From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 06:34:56
Message-ID: OF505EEAA7.04DC6BB2-ON652577D6.0023FE19-652577D6.002428AE@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

Hi,
> I got the following result.
>
> PostgreSQL 7.4.13 on i686-redhat-linux-gnu, compiled by GCC gcc
> (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
> It seems it shows the version from which I took the database to dump.
Didn't you upgrade from 8.1 to 9? Where did 7.4 come from? How did you
upgrade?
Regards,
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-09 06:42:12
Message-ID: 4CD8ED44.7000507@softjin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=US-ASCII" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jayadevan,<br>
Actually this was done by system administrator. <br>
I will redo the things with pgsql 9 tar.gz file and get back to you.<br>
Thanks a lot for bringing this to my notice.<br>
Thanks for the query "select version();"<br>
Regards,<br>
Rekha.<br>
Jayadevan M wrote:
<blockquote
cite="mid:OF505EEAA7(dot)04DC6BB2-ON652577D6(dot)0023FE19-652577D6(dot)002428AE(at)ibsplc(dot)com"
type="cite">
<pre wrap="">Hi,
</pre>
<blockquote type="cite">
<pre wrap="">I got the following result.

PostgreSQL 7.4.13 on i686-redhat-linux-gnu, compiled by GCC gcc
(GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
It seems it shows the version from which I took the database to dump.
</pre>
</blockquote>
<pre wrap=""><!---->Didn't you upgrade from 8.1 to 9? Where did 7.4 come from? How did you
upgrade?
Regards,
Jayadevan

</pre>
</blockquote>
<br>
<pre>

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.
___________________________________________________________
</pre></body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB
From: Rekha Ravi Pai <rekha(at)softjin(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-10 06:44:57
Message-ID: 4CDA3F69.4030700@softjin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jayadevan,<br>
It was the PATH problem. I was accessing default psql that came with
linux.<br>
Now after setting the PATH, and running the command,<br>
<font color="#cc0000">/usr/local/pgsql/bin/pg_ctl start -D .<br>
<font color="#000000">I am getting the following error.<br>
<font color="#cc0000">FATAL:&nbsp; database files are incompatible with
server<br>
DETAIL:&nbsp; The data directory was initialized by PostgreSQL version 7.4,
which is not compatible with this version 9.0.1.<br>
<font color="#000000">How to resolve this?<br>
Regards,<br>
Rekha.<br>
</font><br>
</font></font></font>Jayadevan M wrote:
<blockquote
cite="mid:OF505EEAA7(dot)04DC6BB2-ON652577D6(dot)0023FE19-652577D6(dot)002428AE(at)ibsplc(dot)com"
type="cite">
<pre wrap="">Hi,
</pre>
<blockquote type="cite">
<pre wrap="">I got the following result.

PostgreSQL 7.4.13 on i686-redhat-linux-gnu, compiled by GCC gcc
(GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
It seems it shows the version from which I took the database to dump.
</pre>
</blockquote>
<pre wrap=""><!---->Didn't you upgrade from 8.1 to 9? Where did 7.4 come from? How did you
upgrade?
Regards,
Jayadevan

</pre>
</blockquote>
<br>
<pre>

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.
___________________________________________________________
</pre></body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.2 KB
From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: Rekha Ravi Pai <rekha(at)softjin(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Problem in connecting to database]
Date: 2010-11-10 07:03:55
Message-ID: OFED0B6D5B.0E0EBCD5-ON652577D7.00267A6C-652577D7.0026DF33@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-in-general

Hi,

> It was the PATH problem. I was accessing default psql that came with
linux.
> Now after setting the PATH, and running the command,
> /usr/local/pgsql/bin/pg_ctl start -D .
> I am getting the following error.
> FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 7.
> 4, which is not compatible with this version 9.0.1.
> How to resolve this?
Probably your DATA path is wrong. Try
-bash-3.2$ env | grep DATA
I get
PGDATA=/usr/local/pgsql/data

I think it will help you if you read documentation on installing and
starting PostgreSQL, especially pg_ctl options, initializing the cluster
etc.

Regards,
Jayadevan

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."