Hi Jayadevan,
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?
Regards,
Rekha.
Jayadevan M wrote:
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
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.
___________________________________________________________