Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 83E769F9FDA for ; Fri, 1 Dec 2006 02:34:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 26124-03 for ; Fri, 1 Dec 2006 02:33:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web52308.mail.yahoo.com (web52308.mail.yahoo.com [206.190.48.151]) by postgresql.org (Postfix) with SMTP id 0BB9E9F9EED for ; Fri, 1 Dec 2006 02:33:58 -0400 (AST) Received: (qmail 52356 invoked by uid 60001); 1 Dec 2006 06:33:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=osZX5NcSrmWKbEAXodM8y4N77KKcXA7gsvmHa8hK5MTWKgE7DOFg0DVRhyo9rVtaQ0FdJuu9AJetn87XuhSokWaEQq3M9dpQTtrKI5wb6s6Bv4hDf1O+vw/jzIY3kyjXK1j1kDmlMJuwCP73hdu3iQe6hXrm29xysxuwbK1oG6Y=; X-YMail-OSG: 881uYREVM1nI4gwSkAKIbUT4UV6OAHgVUV8O.5ra0Gh6w_0kM3EXe1opYajpIqe9aYbYxefYjP3LFnZ..NfiHtHtTtf0hUijsafRQWAniyeV9kdBysDLWGU58SYWN1x6zsGTVhDH_H0JNCQ- Received: from [61.95.207.84] by web52308.mail.yahoo.com via HTTP; Thu, 30 Nov 2006 22:33:57 PST Date: Thu, 30 Nov 2006 22:33:57 -0800 (PST) From: Manish Pillai Subject: Postgres 8.1.4 is not starting in RHEL 4 To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-308032806-1164954837=:51890" Content-Transfer-Encoding: 8bit Message-ID: <414317.51890.qm@web52308.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.253 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/1 X-Sequence-Number: 23793 --0-308032806-1164954837=:51890 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi I installed 8.1.4 POSTGRESQL RPMS on my system. When I tried to run /etc/init.d/postgresql start I got this error. [root@newdell init.d]# ./postgresql start Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists [FAILED] Starting postgresql service: [FAILED] Then i removed "pg_log" and given [root@newdell data]# pg_ctl --log /tmp/pg.log start pg_ctl: cannot be run as root Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process. Then i cahnged the user as postgres [root@newdell data]# su postgres bash-3.00$ pg_ctl --log /tmp/pg.log start pg_ctl: no database directory specified and environment variable PGDATA unset Try "pg_ctl --help" for more information. bash-3.00$ Please help me Thanks Manish --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited. --0-308032806-1164954837=:51890 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi
I installed 8.1.4 POSTGRESQL RPMS on my system. When I tried to run /etc/init.d/postgresql start I got this error.

[root@newdell init.d]# ./postgresql start
Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
[FAILED]
Starting postgresql service: [FAILED]
                  Then i removed "pg_log" and given
 
[root@newdell data]# pg_ctl --log /tmp/pg.log start
pg_ctl: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.


Then i cahnged the user as postgres

[root@newdell data]# su postgres
bash-3.00$ pg_ctl --log /tmp/pg.log start
pg_ctl: no database directory specified and environment variable PGDATA unset
Try "pg_ctl --help" for more information.
bash-3.00$
  Please help me
 
Thanks
Manish
 


Access over 1 million songs - Yahoo! Music Unlimited. --0-308032806-1164954837=:51890--