Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOSxJ-0008MN-DG for pgsql-admin@arkaria.postgresql.org; Tue, 24 Sep 2013 13:47:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VOSxI-0000FP-Sw for pgsql-admin@arkaria.postgresql.org; Tue, 24 Sep 2013 13:47:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOSxH-0000Dw-E2 for pgsql-admin@postgresql.org; Tue, 24 Sep 2013 13:47:07 +0000 Received: from nm4.bullet.mail.bf1.yahoo.com ([98.139.212.163]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOSxD-0000Pu-5x for pgsql-admin@postgresql.org; Tue, 24 Sep 2013 13:47:07 +0000 Received: from [98.139.212.150] by nm4.bullet.mail.bf1.yahoo.com with NNFMP; 24 Sep 2013 13:47:01 -0000 Received: from [98.139.212.213] by tm7.bullet.mail.bf1.yahoo.com with NNFMP; 24 Sep 2013 13:47:01 -0000 Received: from [127.0.0.1] by omp1022.mail.bf1.yahoo.com with NNFMP; 24 Sep 2013 13:47:01 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 588528.12493.bm@omp1022.mail.bf1.yahoo.com Received: (qmail 23608 invoked by uid 60001); 24 Sep 2013 13:47:00 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1380030420; bh=d9gt8ikQ8CaloPvQ1S6ZiaLB7hJek9qDHL3BydCxag0=; 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=krtFEqBnnwT3/BU0L4My5B1aLcucERR4tiHUUXOWgfWk2U/F52vE2fu/Jv6bcjj/0kFkPnTnd3iq6KyqnEMLAgv+RAuRmTfVkdXsGruITi03DSsYVSk/WNwlEG0kH4mkvbOEi+fOTXhktaApfjXvzK3VdADgzJj5C04NYo39b+Y= 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=oURDfvcCWlyDQc1N0hxAaiZqogYoF/7/gAmQ8BZPirco1Ewyc7i/q37vW+cudcMb7mfd46OOEa3sIMVq0WaNA3jo1iPeCylg+R52yZ6l1sZFgftO6P2yBQ7R4VJHXJnvrixtrQXWdqHDuzOFFecxRTboxqevWVeI7D9Z75LBZBk=; X-YMail-OSG: ucrnz3QVM1kOGbrgE1lrntiw8_bMIQbcjZbskNCGKlif9lG JKlY5OgsKqrMxvkEiYpAFQy7snwY9Msl7iMzi0YpFQVZHdzuJy696ncP02nd YhfppOZHdt07qazoCAP4jt_iIcKIK.AQOZ2_eLI5CQponNjHUt8zAz.8.2Py eiIBEzZekVoQ_F9HGRSfPmxb2CeaLvQ21IfrRee14debgu8iVCKHDJQr.75N yNKmrAJ9g6A0lTNlKQ78hXtd3lGk_fBLjHEEsOmmTl5IEuc.PO9askE236FH T8alFdpCHbUjMtyXJvHYzOe6tzB.whTae84QEGrbsFSmUDMW4Rcr8Axdu3fK xszKvmQssAz4inrtdQ.6dwVUub_7kSI0wokdXlTYcmIxzzZh1F3gYo2Doh_s .i4FA84tF2iv_fwUo26PnIlzexOrUzJpunuRy3snyPwQayZRxdXOf8huBDck xcEjM2mwlgQM1rbnStY5pSNP.85i.5g00x_ADZNDUTALtu1.sUfqW9Ur7M8o Ie_2pPvc2U5fuwq63Eq1aBJNUEZ.iyy2ILgFBCitRBI2DjmCzJSt8nunEhvk kyL169cgwwckPF04iwteWbpdl1cYzTrY- Received: from [50.241.80.25] by web125003.mail.ne1.yahoo.com via HTTP; Tue, 24 Sep 2013 06:47:00 PDT X-Rocket-MIMEInfo: 002.001, SGVyZSBhcmUgdGhlIHNldHRpbmdzIGluIHRoZSBwb3N0Z3Jlc3FsLmNvbmYgZmlsZToKwqAKSSByZW1lbWJlciB0dXJuaW5nIG9uIGxvZ2dpbmcgdG8gdHJvdWJsZXNob290IGEgcGVyZm9ybWFuY2UgaXNzdWUuLi4uCsKgCmxvZ19kZXN0aW5hdGlvbiA9ICdzdGRlcnInwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAKbG9nZ2luZ19jb2xsZWN0b3IgPSBvbsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgCmxvZ19kaXJlY3RvcnkgPSAncGdfbG9nJ8KgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoAoBMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> Message-ID: <1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com> Date: Tue, 24 Sep 2013 06:47:00 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: accidentally deleted data directory To: Albe Laurenz , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-723168630-1943411142-1380030420=:19939" 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 ---723168630-1943411142-1380030420=:19939 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Here are the settings in the postgresql.conf file:=0A=C2=A0=0AI remember tu= rning on logging to troubleshoot a performance issue....=0A=C2=A0=0Alog_des= tination =3D 'stderr'=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=0Alogging_collector =3D on=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=0A= log_directory =3D 'pg_log'=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=0A#log_filename =3D 'postgresql-= %a.log'=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0Alog_truncate_on_rotation=3Don=0Alo= g_rotation_age =3D 1d=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0Alog_rotation_size= =3D 0 =0A=C2=A0=0AI installed postges from an rpm file (pgdg-redhat92-9.2-= 7.noarch.rpm)=C2=A0using yum install.=0AThanks,=0Athara.=0A=0A_____________= ___________________=0AFrom: Albe Laurenz =0ATo: Th= ara Vadakkeveedu ; "pgsql-admin@postgresql.org" =0ASent: Tuesday, September 24, 2013 6:41 AM=0ASubject= : Re: [ADMIN] accidentally deleted data directory=0A=0A=0AThara Vadakkeveed= u wrote:=0A> ps =E2=80=93edf shows no postgres processes:=0A> -bash-4.1$ ps= -edf | grep postgres=0A> root=C2=A0 =C2=A0 =C2=A0 6412=C2=A0 6249=C2=A0 0 = 18:22 pts/0=C2=A0 =C2=A0 00:00:00 su - postgres=0A> postgres=C2=A0 6413=C2= =A0 6412=C2=A0 0 18:22 pts/0=C2=A0 =C2=A0 00:00:00 -bash=0A> postgres=C2=A0= 6465=C2=A0 6413=C2=A0 1 18:27 pts/0=C2=A0 =C2=A0 00:00:00 ps -edf=0A> post= gres=C2=A0 6466=C2=A0 6413=C2=A0 0 18:27 pts/0=C2=A0 =C2=A0 00:00:00 grep p= ostgres=0A=0AOk.=0A=0A> Ran the following command as postgres user=0A> -bas= h-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data=0A> =0A> pgst= artup.log is empty=0A> =0A> -bash-4.1$ pwd=0A> /var/lib/pgsql/9.2=0A> -bash= -4.1$ ls=0A> backups=C2=A0 data=C2=A0 logfile=C2=A0 pgstartup.log=0A> -bash= -4.1$ ls -al=0A> total 20=0A> drwx------.=C2=A0 4 postgres postgres 4096 Se= p 23 18:21 .=0A> drwx------.=C2=A0 3 postgres postgres 4096 Sep 23 18:18 ..= =0A> drwx------.=C2=A0 2 postgres postgres 4096 Apr=C2=A0 1 19:41 backups= =0A> drwx------. 15 postgres postgres 4096 Sep 23 18:28 data=0A> -rw-------= .=C2=A0 1 postgres postgres=C2=A0 409 Sep 22 11:44 logfile=0A> -rw-------= =C2=A0 1 postgres postgres=C2=A0 =C2=A0 0 Sep 23 18:20 pgstartup.log=0A> -b= ash-4.1$=0A> =0A> Is there something else I can try?=0A=0AYes.=0A=0ALook ho= w logging is configured in /var/lib/pgsql/9.2/data/postgresql.conf=0A(param= eters log_destination, logging_collector, log_directory, log_filename).=0A= =0AFind the log file and see what is in there.=0A=0A> I don=E2=80=99t have = any data to restore. This is an installation which is only a couple of week= s old. I can=0A> uninstall and reinstall if that is easier.=0A=0AI don't kn= ow if that would solve the problem.=0A=0A> Where can I find the uninstaller= ?=0A=0AHow did you install PostgreSQL?=0A=0AYours,=0ALaurenz Albe=0A=0A-- = =0ASent via pgsql-admin mailing list (pgsql-admin@postgresql.org)=0ATo make= changes to your subscription:=0Ahttp://www.postgresql.org/mailpref/pgsql-a= dmin ---723168630-1943411142-1380030420=:19939 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Here are the settings in the postgresql.c= onf file:
 
I remember turning o= n logging to troubleshoot a performance issue....
 
log_destination =3D = 'stderr'           &= nbsp; 
logging_collector =3D on       &nb= sp;        
log_directory =3D 'pg_log'       &= nbsp;       
#log_filename =3D 'postgresql= -%a.log'     
log_truncate_on_rotation=3Don
log_rotation_age =3D 1d     = ;            &n= bsp;
log_rotation_size =3D 0
 
I installed postges from an rpm file (pgdg-redhat92-9.2-7= .noarch.rpm) using yum install.
Thanks,
thara.
From: Albe Laurenz <laurenz.albe@wien.= gv.at>
To: Thara Vada= kkeveedu <tharagv@yahoo.com>; "pgsql-admin@postgresql.org" <pgsql-= admin@postgresql.org>
Sent: Tuesday, September 24, 2013 6:41 AM
Subject: Re: [ADMIN] accidentally deleted data director= y

Thara Vadakkeveedu w= rote:
> ps =E2=80=93edf shows no postgres processes:
> -bash-4.= 1$ ps -edf | grep postgres
> root      6412  6249=   0 18:22 pts/0    00:00:00 su - postgres
> postgres&n= bsp; 6413  6412  0 18:22 pts/0    00:00:00 -bash
>= ; postgres  6465  6413  1 18:27 pts/0    00:00:00 = ps -edf
> postgres  6466  6413  0 18:27 pts/0  &n= bsp; 00:00:00 grep postgres

Ok.

> Ran the following comman= d as postgres user
> -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/l= ib/pgsql/9.2/data
>
> pgstartup.log is empty
>
> = -bash-4.1$ pwd
> /var/lib/pgsql/9.2
> -bash-4.1$ ls
> bac= kups  data  logfile  pgstartup.log
> -bash-4.1$ ls -al=
> total 20
> 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 backu= ps
> 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 pgstartu= p.log
> -bash-4.1$
>
> Is there something else I can try= ?

Yes.

Look how logging is configured in /var/lib/pgsql/9.2/d= ata/postgresql.conf
(parameters log_destination, logging_collector, log_= directory, log_filename).

Find the log file and see what is in there= .

> I don=E2=80=99t have any data to restore. This is an installa= tion which is only a couple of weeks old. I can
> uninstall and reins= tall if that is easier.

I don't know if that would solve the problem= .

> Where can I find the uninstaller ?

How did you install PostgreSQL?

Yours,
Laurenz Albe

--
Sent via p= gsql-admin mailing list (pgsql-admin@postgresql.org)To make changes to your subscription:
http://www.postgresql.org/mailpr= ef/pgsql-admin


---723168630-1943411142-1380030420=:19939--