Re: Print database name - Mailing list pgsql-general

From Jaime Silvela
Subject Re: Print database name
Date
Msg-id 4615030C.2020004@bear.com
Whole thread Raw
In response to Re: Print database name  (Michael Fuhr <mike@fuhr.org>)
Responses Crash recovery  (Jaime Silvela <JSilvela@Bear.com>)
Re: Print database name  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I know you've probably discussed this in many places, but I have a crash
right now I need to recover from, and I'm not finding documentation that
fast.
Where should I go?

Below you can see the log on starting, after a kill -9 of a process
brought Postgres down.
After letting postgres run for a while, it seems to have fixed itself,
and now the log does not suggest any corruption, and I can access it
locally. However, TCP/IP connections are rejected. Any ideas?
Is there a page/s with information on quick recovery after corruption?

LOG:  could not create IPv6 socket: Address family not supported by
protocol
LOG:  database system was interrupted while in recovery at 2007-04-05
08:18:47 EDT
HINT:  This probably means that some data is corrupted and you will have
to use the last backup for recovery.





***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.

Bear Stearns does not provide tax, legal or accounting advice.  You
should consult your own tax, legal and accounting advisors before
engaging in any transaction. In order for Bear Stearns to comply with
Internal Revenue Service Circular 230 (if applicable), you are notified
that any discussion of U.S. federal tax issues contained or referred to
herein is not intended or written to be used, and cannot be used, for
the purpose of:  (A) avoiding penalties that may be imposed under the
Internal Revenue Code; nor (B) promoting, marketing or recommending to
another party any transaction or matter addressed herein.
***********************************************************************

pgsql-general by date:

Previous
From: omar
Date:
Subject: Re: Problem with oids for table names getting out of sync?
Next
From: Scott Ribe
Date:
Subject: Re: Using C# to create stored procedures