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

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
Thread:
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

In response to

Responses

Browse pgsql-in-general by date

  From Date Subject
Next Message Jayadevan M 2010-11-10 07:03:55 Re: [Fwd: Re: Problem in connecting to database]
Previous Message Rekha Ravi Pai 2010-11-09 06:42:12 Re: [Fwd: Re: Problem in connecting to database]