Hi, I am unable to restart the PostgreSQL. I am using redhat Linux 9 with postgresql 7.4.5. Unexpectedly due to ups problem my server was shutdown once. After that i am unable to restart the server. How to stop and start. Present status is running. If i tried to start i am getting as
1) bash-2.05b$ pg_ctl start pg_ctl: Another postmaster may be running. Trying to start postmaster anyway. FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.5. pg_ctl: cannot start postmaster Examine the log output.
You have two versions of PostgreSQL installed (possibly one from RPM one from source). You presumably have two data directories and it is picking up the wrong one. Check $PGDATA etc.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
