Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOEk4-0001nG-Fi for pgsql-admin@arkaria.postgresql.org; Mon, 23 Sep 2013 22:36:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VOEk3-0006JB-Tv for pgsql-admin@arkaria.postgresql.org; Mon, 23 Sep 2013 22:36:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOEk2-0006Hh-HE for pgsql-admin@postgresql.org; Mon, 23 Sep 2013 22:36:30 +0000 Received: from nm47-vm6.bullet.mail.bf1.yahoo.com ([216.109.115.141]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOEjx-000159-Qj for pgsql-admin@postgresql.org; Mon, 23 Sep 2013 22:36:30 +0000 Received: from [98.139.215.143] by nm47.bullet.mail.bf1.yahoo.com with NNFMP; 23 Sep 2013 22:36:23 -0000 Received: from [98.139.212.202] by tm14.bullet.mail.bf1.yahoo.com with NNFMP; 23 Sep 2013 22:36:23 -0000 Received: from [127.0.0.1] by omp1011.mail.bf1.yahoo.com with NNFMP; 23 Sep 2013 22:36:23 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 812698.58343.bm@omp1011.mail.bf1.yahoo.com Received: (qmail 31099 invoked by uid 60001); 23 Sep 2013 22:36:22 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1379975782; bh=321TAPAanR8sbsdDNJcGbv1JbeAPdRDs4zQ+ArOQP1Q=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=qHBzG7/oIgPLRjD977bcexmR/Oo3j/G7IOc7uq6SZjzPs3xGAgkklRkdm5jgG3tOoGO4EziSwJ4t+Dc32poe7dYPlUcAATluYfZVR0EAsdRi4IyuG3vtY+Q53JgnKtxYgEgZgFnEbzAKYvxFxV5TB0531uHMUlc8ynsm8VcgSO8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=4V4M06g4kca8zMGInMECdWkMZHFviJvzt3X80nQ5GmIaH7EsRSq3Cn7jIHKAy8V04l7wQpIiFATilsb5La7cPgwB+WUO82NRSBXdAivk67dav0KDP6kYY0j1SlMc2SmyslV7PYOEJrUVNdUurdgODde0VjDzGNfM82cgBDIapsI=; X-YMail-OSG: qwhmpRMVM1ltC7TPfh_a0znPm7vH9PEEY_fibQUTBwzDfpk 2rUgxvXka9g_A.LlVg6yditjkPG4wQk0pupvJQmjcY0Hu3HnSttlTqbTZfIl ozn.pvgpYYZGR42aogaDsAgMsR7BKX_CYPYLlPF.bc9ibxGhUMT6HfokHNzu l2tHay8zu.OwotRAvE78xwOvFPam5X_mEyvj.trjm2Hc923eeoJ40uYrwlxA J4UflR5HhEgzGcq3PFYvKOnZ4WOA3jgLcSjzQcv0lBLY67n8wnEL0LFXuEF3 elnVAhlT3.yV0r4jQI6S2low5UFzxdBJ63oIfZ0OuzGrYVcaJWSg2PEFMijD SgN4bHBkbLBicEG2QYF4AfA54CyN0AHP3PeGuEfj4D7hrPUT6JpIxC47ULV3 9UFpIiN9ALQ8.yA8clHkQdeuU1wB0v2KRTtZiIfMU0V6xXUQoR6bxymOJ0Nu slonEpeeMlfS4mNAZxFmQ7H_AzwYz93qo0KDYiuZDeg8glel.U6ba94st2km VeRTOPJM_yGlxJuQ93Bm2AVk1q3aowaImM2sbqh2D5r07EqgdRqUHu6vlxU. eDF74uFnxv8AQKUAiGFB2SM4M0yr_ZHM- Received: from [50.241.80.25] by web125005.mail.ne1.yahoo.com via HTTP; Mon, 23 Sep 2013 15:36:22 PDT X-Rocket-MIMEInfo: 002.001, wqAKU2VlIGlmIHRoZXJlIGFyZSBwcm9jZXNzZXMgcnVubmluZyBmb3IgdXNlciAicG9zdGdyZXMiIHRoYXQgbG9vawpsaWtlIGRhdGFiYXNlIHByb2Nlc3NlcyBhbmQga2lsbCB0aGVtLgrCoApUaGVuIHRyeSBhZ2Fpbi4KwqAKV2hhdCBleGFjdGx5IGlzIHRoZSBlcnJvciBtZXNzYWdlPwrCoApZb3VycywKTGF1cmVueiBBbGJlCsKgCsKgCkhpCsKgCsKgCnBzIOKAk2VkZiBzaG93cyBubyBwb3N0Z3JlcyBwcm9jZXNzZXM6Ci1iYXNoLTQuMSQgcHMgLWVkZiB8IGdyZXAgcG9zdGdyZXMKcm9vdMKgwqDCoMKgwqABMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> Message-ID: <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> Date: Mon, 23 Sep 2013 15:36:22 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: accidentally deleted data directory To: "pgsql-admin@postgresql.org" In-Reply-To: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1988236031-689864736-1379975782=:27726" X-Pg-Spam-Score: -4.3 (----) 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 --1988236031-689864736-1379975782=:27726 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable =C2=A0=0ASee if there are processes running for user "postgres" that look= =0Alike database processes and kill them.=0A=C2=A0=0AThen try again.=0A=C2= =A0=0AWhat exactly is the error message?=0A=C2=A0=0AYours,=0ALaurenz Albe= =0A=C2=A0=0A=C2=A0=0AHi=0A=C2=A0=0A=C2=A0=0Aps =E2=80=93edf shows no postgr= es processes:=0A-bash-4.1$ ps -edf | grep postgres=0Aroot=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 6412=C2=A0 6249=C2=A0 0 18:22 pts/0=C2=A0=C2=A0=C2=A0 00:00:00= su - postgres=0Apostgres=C2=A0 6413=C2=A0 6412=C2=A0 0 18:22 pts/0=C2=A0= =C2=A0=C2=A0 00:00:00 -bash=0Apostgres=C2=A0 6465=C2=A0 6413=C2=A0 1 18:27 = pts/0=C2=A0=C2=A0=C2=A0 00:00:00 ps -edf=0Apostgres=C2=A0 6466=C2=A0 6413= =C2=A0 0 18:27 pts/0=C2=A0=C2=A0=C2=A0 00:00:00 grep postgres=0A=C2=A0=0A= =C2=A0=0ARan the following command as postgres user=0A-bash-4.1$ /usr/pgsql= -9.2/bin/postgres -D /var/lib/pgsql/9.2/data=0A-bash-4.1$=0A=C2=A0=0Apgstar= tup.log is empty=0A=C2=A0=0A-bash-4.1$ pwd=0A/var/lib/pgsql/9.2=0A-bash-4.1= $ ls=0Abackups=C2=A0 data=C2=A0 logfile=C2=A0 pgstartup.log=0A-bash-4.1$ ls= -al=0Atotal 20=0Adrwx------.=C2=A0 4 postgres postgres 4096 Sep 23 18:21 .= =0Adrwx------.=C2=A0 3 postgres postgres 4096 Sep 23 18:18 ..=0Adrwx------.= =C2=A0 2 postgres postgres 4096 Apr=C2=A0 1 19:41 backups=0Adrwx------. 15 = postgres postgres 4096 Sep 23 18:28 data=0A-rw-------.=C2=A0 1 postgres pos= tgres=C2=A0 409 Sep 22 11:44 logfile=0A-rw-------=C2=A0=C2=A0 1 postgres po= stgres=C2=A0=C2=A0=C2=A0 0 Sep 23 18:20 pgstartup.log=0A-bash-4.1$=0A=C2=A0= =0AIs there something else I can try?=0A=C2=A0=0AI don=E2=80=99t have any d= ata to restore. This is an installation which is only a couple of weeks old= . I can uninstall and reinstall if that is easier.=0A=C2=A0=0A=C2=A0=0AWher= e can I find the uninstaller ?=0AThanks=0AThara. --1988236031-689864736-1379975782=:27726 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
 
See if there are processes running f= or user "postgres" that look
like database processes and kill them.
 
Then try again.
 
What exactly is the error message?
 
Yours,
Laurenz Albe
 
 
Hi
 
 
ps =E2=80=93edf shows no postgres processes:
-bash-4= .1$ ps -edf | grep postgres
root&nb= sp;     6412  6249  0 18:22 pts/0  =   00:00:00 su - postgres
postgre= s  6413  6412  0 18:22 pts/0    00:00:00 -bas= h
postgre= s  6465  6413  1 18:27 pts/0    00:00:00 ps -= edf
postgre= s  6466  6413  0 18:27 pts/0    00:00:00 grep= postgres
 <= /SPAN>
 <= /SPAN>
Ran the= following command as postgres user
-bash-4= .1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data
-bash-4= .1$
 <= /SPAN>
pgstart= up.log is empty
 <= /SPAN>
-bash-4= .1$ pwd
/var/li= b/pgsql/9.2
-bash-4= .1$ ls
backups=   data  logfile  pgstartup.log
-bash-4= .1$ ls -al
total 2= 0
drwx---= ---.  4 postgres postgres 4096 Sep 23 18:21 .
drwx---= ---.  3 postgres postgres 4096 Sep 23 18:18 ..
drwx---= ---.  2 postgres postgres 4096 Apr  1 19:41 backups
drwx---= ---. 15 postgres postgres 4096 Sep 23 18:28 data
-rw----= ---.  1 postgres postgres  409 Sep 22 11:44 logfile
-rw----= ---   1 postgres postgres    0 Sep 23 18:20 pgstar= tup.log
-bash-4= .1$
 <= /SPAN>
Is ther= e something else I can try?
 <= /SPAN>
I don= =E2=80=99t have any data to restore. This is an installation which is only = a couple of weeks old. I can uninstall and reinstall if that is easier.
 <= /SPAN>
 <= /SPAN>
Where c= an I find the uninstaller ?
Thanks<= /SPAN>
Thara.<= /SPAN>
 <= /SPAN>
 <= /SPAN>
 <= /SPAN>
 


=
--1988236031-689864736-1379975782=:27726--