X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EC502D1D31D for ; Tue, 10 Feb 2004 14:45:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08258-02 for ; Tue, 10 Feb 2004 10:45:30 -0400 (AST) Received: from diver.highboard.com (ns5.highboard.com [207.44.244.101]) by svr1.postgresql.org (Postfix) with ESMTP id 6EAA8D1C7F7 for ; Tue, 10 Feb 2004 10:45:26 -0400 (AST) Received: from roc-66-67-208-52.rochester.rr.com ([66.67.208.52] helo=swimmer) by diver.highboard.com with smtp (Exim 4.24) id 1AqZ9R-0002wv-Jj for pgsql-admin@postgresql.org; Tue, 10 Feb 2004 09:46:13 -0500 From: "Jeremy Smith" To: Subject: Upgrading from 7.2 to 7.4.1 on Redhat 7 Date: Tue, 10 Feb 2004 09:45:55 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - diver.highboard.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - xpertleagues.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/131 X-Sequence-Number: 12305 Hi, I have owned a server for about a year, and apparently PostgreSQL 7.2 was originally installed with Redhat. I made an attempt to set up a database on the current Postgres setup, but when trying to set up my configure files in WHM (Cpanel) I received the error: Setting up Postgres Config...Done Reloading Postgres...pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid And when I tried to set up a database or user from Cpanel, it just wouldn't work. There wasn't an error, but when I would add a user or database, it wouldn't show up afterwords in my list of users and DBs. So I did some research, and found out about running postmaster in a non-root account. I tried that and recieved this error message: FATAL: The data directory was initialized by PostgreSQL version 7.2, which is not compatible with this version 7.3.3.