pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: lmyho <lm_yho@yahoo.com>
To: Chris Travers <chris@metatrontech.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: Wed, 29 Mar 2006 20:14:19 -0800 (PST)
Message-ID: <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com> (raw)
In-Reply-To: <442B3603.7030309@metatrontech.com>

Hi Chris, 
 
thanks for the check list! I just came back from the Debian Recovery mode and checked all of them. please see below:

>Things to check when PostgreSQL doesn't seem to start:
 
>1)  Are there any postmaster programs running (ps -A | grep postmaster 
is useful here)
 
Checked. No postmaster running. 

>2)  If not, is there a postmaster.pid file n the postgresql data 
directory? (do a search for the file if you have to-- if no postmaster 
processes are running delete the file and try again)
 
Checked.  No postmaster.pid file in the postgres data directory.

>3)  What are the final entries in the serverlog in the data directory?
 
There is a long list of the log files of today as I started the system a few times. (By the way, The computer was powered off before I started to login.)  One big log file of yesterday.  All today's log files are similar except the first one has a long list of: 
...
autovacuum:processing database "progres"
autovacuum: processing database "template1"
autovacuum:processing database "progres"
autovacuum: processing database "template1"
...
 
In more detail, the logs looks like: 
...
db system was shutdown at <time>
checkingpoint record is at 0/33ABC4
redo record is at 0/33ABC4;undo record is at 0/0; sgutdown TRUE
next transaction ID: xx OID: xx
next MultiXactId:1; MultiXactOffset:0
database system is ready
transaction ID wrap limit is 2147484146, limited by database "postgres"
imcomplete startup packet
autovacuum:processing database "progres"
autovacuum: processing database "template1"
autovacuum:processing database "progres"
autovacuum: processing database "template1"
...
imcomplete startup packet
received fast shutdown request
shuttingdown
database system is shut down
logger shutting down
 
 
Something like this, each has a little different, but ends the same way.
 
I don't quite understand the contents here.  Can you see any problem?
 
I look forward any further help.  Thnaks a lot!!!
 
leo


>In your case, if PostgreSQL is hanging, I would suspect that the problem 
>is likely to be with something else.  Hopefully there would be info in 
>the serverlog that would help.



view thread (20+ messages)  latest in thread

Message-ID: <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com>
Permalink:  ../20060330041419.80853.qmail@web30804.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060330041419.80853.qmail@web30804.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lm_yho@yahoo.com, chris@metatrontech.com
  Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
  In-Reply-To: <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com>
  References: <442B3603.7030309@metatrontech.com> <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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