Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VNmAG-0008TV-73 for pgsql-admin@arkaria.postgresql.org; Sun, 22 Sep 2013 16:05:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VNmAF-0000GS-Ep for pgsql-admin@arkaria.postgresql.org; Sun, 22 Sep 2013 16:05:39 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VNmAE-0000GL-7M for pgsql-admin@postgresql.org; Sun, 22 Sep 2013 16:05:38 +0000 Received: from nm32-vm7.bullet.mail.bf1.yahoo.com ([72.30.239.143]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VNmAB-0005bb-7O for pgsql-admin@postgresql.org; Sun, 22 Sep 2013 16:05:37 +0000 Received: from [98.139.212.146] by nm32.bullet.mail.bf1.yahoo.com with NNFMP; 22 Sep 2013 16:05:34 -0000 Received: from [98.139.212.227] by tm3.bullet.mail.bf1.yahoo.com with NNFMP; 22 Sep 2013 16:05:34 -0000 Received: from [127.0.0.1] by omp1036.mail.bf1.yahoo.com with NNFMP; 22 Sep 2013 16:05:34 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 297740.13924.bm@omp1036.mail.bf1.yahoo.com Received: (qmail 15485 invoked by uid 60001); 22 Sep 2013 16:05:33 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1379865933; bh=oV7OpYNPGnR9pAc2NOPxx9dflq0lDjFxzCDJbdSg8ks=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=qjH86qPSJGGhSgw3ytC4U6Rm2vQrsCknvAk8er7akPuRSEXCeRL3rqpMSAR8ieQBbh45/Xb2z+AmKc55UAAfs3JAe8lwCjSuIk/YfG/k5lD3OG6eOMPeBsLv/zCK7XhrfkjlRffiCnSyuSol8YMviODkv4hgEvafRL0p90vs4gk= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=oiXrM8EF213JkBAhQQda1l/BuPBRDtDfO7hAyStLZX87u6bVHJNrtBMHYjZwQPy6FHZCfKK5bkkEnA8OHON2qoFDBUT7YOHUMxJiOM9vs/Dl2SDnQobxXk+xruLMc9XNKRirN+/0VudLA45mwl/UAmCnQT2nOrkEFk5/qfTkxoM=; X-YMail-OSG: ZgAp1eQVM1lFzgc0Udp8wiqM0l_dC8iecB1M0rjg5.qIko1 sKUXuC0DnZF7C7YfSf07nryG6iM868eMTeoGqSiSQ7EH4hBBRERQnRs7ZIPk JilrQJA53Fwg9.z6PQnbSijZ.TFKx2.tCibtPefLdvEk1YRXjj5IUA47cD7y h6FIQ1OdcFK37p8Us5sL6l.1two3LM3GjHqSFnYrQel8GIp5f1n96Z41PgrR 9czT9CeMP7WDYZJ_hbTgx6xTnztHtXtZE_LVgUcbsSLO.rR4cf3hE4P0vyjU x5eVxO25ICm.ATCJFQ5LMc1lHNLG0CfEidDT6ihApmOXkKb45OggUuUJ_q.1 DfpZjLx_yA2Ok9u2MfwqEKq9UE3LXyoKN3m2MDnrS.lLSzWgCbLu1cvVaTpC xmqQ3GeXKC26Sg3TfTpNhx_y9zVboNlH4YbsVtyG9lH3dAouKbPHqQlA2qm. 37zq75Ly3DOvg1ONlz3B0XQK8_DjZrJlGPhgIR0lcxJVvPNZxlDx5KwIk2f9 lYmz2zCo8Y74AiuYp6Ziwq9msFEnKc1VyMzS3xObUtnMbN4mWrweFYRaGcL4 k6rhRMRIt Received: from [50.241.80.25] by web125003.mail.ne1.yahoo.com via HTTP; Sun, 22 Sep 2013 09:05:33 PDT X-Rocket-MIMEInfo: 002.001, SGkKSSBhbSBuZXcgdG8gcG9zdGdyZXNxbC4gSSBoYXZlIHBvc3RncmVzcWwgOS4yIGluc3RhbGxlZCBvbiBSZWQgaGF0IGxpbnV4IDYuNApJIGFjY2lkZW50YWxseSBkZWxldGVkIGRhdGEgZGlyZWN0b3J5IHRoaXMgbW9ybmluZyAoL3Zhci9saWIvcG9zdGdyZXNxbC85LjIvZGF0YSkKwqAKSSB0cmllZCB0byBzdGFydCBwb3NncmVzcWwgOS4yIHNlcnZpY2UKc2VydmljZSBwb3N0Z3Jlc3FsOS4yIHN0YXJ0CsKgCkkgZ290IGEgYW1lc3NhZ2UgdG8gaW5pdGlhbGl6ZSB0aGUgZGIgZmlyc3QuCsKgCnNvIEkgcmEBMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 Message-ID: <1379865933.14475.YahooMailNeo@web125003.mail.ne1.yahoo.com> Date: Sun, 22 Sep 2013 09:05:33 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: accidentally deleted data directory To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-723168630-450030487-1379865933=:14475" X-Pg-Spam-Score: -1.6 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---723168630-450030487-1379865933=:14475 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi=0AI am new to postgresql. I have postgresql 9.2 installed on Red hat lin= ux 6.4=0AI accidentally deleted data directory this morning (/var/lib/postg= resql/9.2/data)=0A=A0=0AI tried to start posgresql 9.2 service=0Aservice po= stgresql9.2 start=0A=A0=0AI got a amessage to initialize the db first.=0A= =A0=0Aso I ran service postgresql-9.2 initdb=0A=A0=0Athis was successful=0A= then i tried service postgresql-9.2 start=0Athis failed.=0A=A0=0Apgstartup.= log indicated I can start the database server using:=0A=A0=A0=A0 /usr/pgsql= -9.2/bin/postgres -D /var/lib/pgsql/9.2/data=0Aor=0A=A0=A0=A0 /usr/pgsql-9.= 2/bin/pg_ctl -D /var/lib/pgsql/9.2/data -l logfile start=0A=0AHowever I=A0 = am unable to start database as root=0A=A0=0AThat is the only account I use = on this server. =0AI tried=A0 su - postgres=0Aand then from the bash shell = i tried to run these commands (tried one at a time)=0Abut it said address i= n use=0Athere are no processes running on 5432.=0A=A0=0AHow can I start pos= tgres service?=0A=A0=0AThanks=0AThara. ---723168630-450030487-1379865933=:14475 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi
I am new to postgresql. I have postgresql 9.2 in= stalled on Red hat linux 6.4
I accidentally deleted data directory this morni= ng (/var/lib/postgresql/9.2/data)
 
I tried to start posgresql 9.2 service
service postgresql9.2 start
 
I got a amessage to initialize the db first.
 
so I ran service postgresql-9.2 initdb
 
this was successful
then i tried service postgresql-9.2 start
this failed.
 
pgstartup.log indicated I can start the database= server using:
    /usr/pgsql-9.2/bin/postgres -= D /var/lib/pgsql/9.2/data
or
    /usr/pgsql-9.2/bin/pg= _ctl -D /var/lib/pgsql/9.2/data -l logfile start
<= /div>
However I  am unable to start database as root
 
That is the only account I use on this server.
I tried  su - postgres
and then from the bash shell i tried to run these command= s (tried one at a time)
but it said address in use
there are no processes running on 5432.
 
How can I start postgres service?
 
Thanks
Thara.
---723168630-450030487-1379865933=:14475--