Re: Uninstall postgresql 9.2 on red hat linux

I looked at the postgres log, found a panic message on invalid checkpoint..verified there were no postgres processes running, deleted the data directory again, ran initdb and now the service starts successfully. I am all set.
thanks,
thara.

________________________________
From: Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, September 24, 2013 9:53 AM
Subject: Re: [NOVICE] Uninstall postgresql 9.2 on red hat linux

This is what I find in the posgresql log (entries relate to my attempts to start postgresql yesterday)
 
LOG:  database system was shut down at 2013-09-22 12:20:51 EDT
LOG:  invalid magic number 0000 in log file 0, segment 39, offset 0
LOG:  invalid primary checkpoint record
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 2361) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2013-09-22 12:20:51 EDT
LOG:  invalid magic number 0000 in log file 0, segment 39, offset 0
LOG:  invalid primary checkpoint record
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 6323) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2013-09-22 12:20:51 EDT
LOG:  invalid magic number 0000 in log file 0, segment 39, offset 0
LOG:  invalid primary checkpoint record
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 6346) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2013-09-22 12:20:51 EDT
LOG:  invalid magic number 0000 in log file 0, segment 39, offset 0
"postgresql-Mon.log" 49L, 2709C
 
Thanks
thara.

________________________________
From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, September 24, 2013 4:17 AM
Subject: Re: [NOVICE] Uninstall postgresql 9.2 on red hat linux

Hi,

On Sun, 2013-09-22 at 16:57 -0700, Thara Vadakkeveedu wrote:
> I am new to postgresql. I have postgresql 9.2 installed on Red hat
> linux 6.4
> I accidentally deleted data directory this morning
> (/var/lib/postgresql/9.2/data)
>
> I tried to start posgresql 9.2 service
> "service postgresql-9.2 start"
>
> I got a message 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.

Please look at  the log files under /var/lib/pgsql/9.2/data/pg_log/ .
PostgreSQL is probably complaining for another thing.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com/
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org/Twitter: http://twitter.com/devrimgunduz