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: 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: (view raw, whole thread or download thread mbox)
Lists: pgsql-in-general
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
Hi Jayadevan,<br>
It was the PATH problem. I was accessing default psql that came with
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
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>
</font></font></font>Jayadevan M wrote:
  <pre wrap="">Hi,
  <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 wrap=""><!---->Didn't you upgrade from 8.1 to 9? Where did 7.4 come from? How did you 


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.

Attachment: unknown_filename
Description: text/html (2.2 KB)

In response to


pgsql-in-general by date

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

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