pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLOG: logger shutting down
3+ messages / 3 participants
[nested] [flat]
* LOG: logger shutting down
@ 2006-10-03 04:06 Bryce Nesbitt <bryce1@obviously.com>
2006-10-03 04:32 ` Re: LOG: logger shutting down Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Bryce Nesbitt @ 2006-10-03 04:06 UTC (permalink / raw)
To: pgsql-sql
My postmaster won't start. This is on a Fedora Core fc5 box, new and clean.
It's postgres 8.1.4. All I get is "LOG: logger shutting down" in the
pgstartup.log.
I've checked for permission errors.
At the relevant moment I get:
# sh -x /etc/init.d/postgresql start
...
++ cat /var/lib/pgsql/data/PG_VERSION
+ '[' x8.1 '!=' x8.1 ']'
+ echo -n 'Starting postgresql service: '
Starting postgresql service: + echo -n 'City CarShare Hacking'
+ runuser -l postgres -c '/usr/bin/postmaster -p '\''5432'\'' -D
'\''/var/lib/pgsql/data'\'' &'
+ sleep 2
LOG: logger shutting down
++ pidof -s /usr/bin/postmaster
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: LOG: logger shutting down
2006-10-03 04:06 LOG: logger shutting down Bryce Nesbitt <bryce1@obviously.com>
@ 2006-10-03 04:32 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2006-10-03 04:32 UTC (permalink / raw)
To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: pgsql-sql
Bryce Nesbitt <bryce1@obviously.com> writes:
> My postmaster won't start. This is on a Fedora Core fc5 box, new and clean.
> It's postgres 8.1.4. All I get is "LOG: logger shutting down" in the
> pgstartup.log.
My first instinct is to think selinux issue. Are you up2date on selinux
policy patches? A restorecon on the postgres executables and everything
under /var/lib/pgsql might help.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* LOG: logger shutting down
@ 2006-11-21 01:59 anil maran <anilmrn@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: anil maran @ 2006-11-21 01:59 UTC (permalink / raw)
To: anil maran <anilmrn@yahoo.com>; allan@saddi.com
my db server has crashed
i m using postgres
what happened is when reindexing was happening
postgres got shut down
now i m unable to start can you give me any pointers
CRON running vacuum on a database
and pg_ctl stop -m fast got called
Now I m unalbe ot run the database, the following is the error when I run
pg_ctl -D /work/database start
LOG: logger shutting down
on running tail -n 30 postgresql-Mon.log
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 8A/8F00833C
PANIC: block 1100 unfound
LOG: startup process (PID 31612) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
LOG: database system was interrupted while in recovery at 2006-11-20 16:56:18 PST
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: checkpoint record is at 8A/8F01D6D4
LOG: redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 32782967; next OID: 2499839
LOG: next MultiXactId: 972; next MultiXactOffset: 2099
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 8A/8F00833C
PANIC: block 1100 unfound
LOG: startup process (PID 31846) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
LOG: database system was interrupted while in recovery at 2006-11-20 17:12:21 PST
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: checkpoint record is at 8A/8F01D6D4
LOG: redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 32782967; next OID: 2499839
LOG: next MultiXactId: 972; next MultiXactOffset: 2099
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 8A/8F00833C
PANIC: block 1100 unfound
LOG: startup process (PID 32000) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
pg_controldata
pg_control version number: 812
Catalog version number: 200510211
Database system identifier: 4952196794948500735
Database cluster state: in recovery
pg_control last modified: Mon 20 Nov 2006 05:14:36 PM PST
Current log file ID: 138
Next log file segment: 170
Latest checkpoint location: 8A/8F01D6D4
Prior checkpoint location: 8A/8C01924C
Latest checkpoint's REDO location: 8A/8F00833C
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 32782967
Latest checkpoint's NextOID: 2499839
Latest checkpoint's NextMultiXactId: 972
Latest checkpoint's NextMultiOffset: 2099
Time of latest checkpoint: Mon 20 Nov 2006 12:53:56 PM PST
Maximum data alignment: 4
Database block size: 8192
Blocks per segment of large relation: 131072
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Date/time type storage: floating-point numbers
Maximum length of locale name: 128
LC_COLLATE: en_US.UTF-8
LC_CTYPE: en_US.UTF-8
I tried running pg_resetxlog everything got lost, so restoring the copied database folder
I got pointers to looking at
pg_filedump and I could not find out how to specify options to filedump
Please help me out
my data bases is like 1gigabyte, panicking
thanks
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-11-21 01:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-03 04:06 LOG: logger shutting down Bryce Nesbitt <bryce1@obviously.com>
2006-10-03 04:32 ` Re: LOG: logger shutting down Tom Lane <tgl@sss.pgh.pa.us>
2006-11-21 01:59 LOG: logger shutting down anil maran <anilmrn@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox