Postgres Pro
Downloads
Home   >   mailing lists

Re: Uninstall postgresql 9.2 on red hat linux - Mailing list pgsql-novice

From Thara Vadakkeveedu
Subject Re: Uninstall postgresql 9.2 on red hat linux
Date
Msg-id 1380030834.28673.YahooMailNeo@web125003.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: Uninstall postgresql 9.2 on red hat linux  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: Uninstall postgresql 9.2 on red hat linux
List pgsql-novice
Tree view
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@gunduz.org>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.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

pgsql-novice by date:

Previous
From: James David Smith
Date:
Subject: Re: Tablespaces
Next
From: Thara Vadakkeveedu
Date:
Subject: Re: Uninstall postgresql 9.2 on red hat linux