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
(Thara Vadakkeveedu <tharagv@yahoo.com>)
|
| List | pgsql-novice |
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
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
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: