Search Postgresql Archives

Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ah, ok. I somehow missed the first line of the message an the rest of it
left the impression that "something" must be wrong with replication.

I guess one of my colleagues might have shut down the database by
accident and forgot to tell me.

Anyway, thanks for your reply.

Marc


Alvaro Herrera wrote:
> Marc Schablewski wrote:
>   
>> Hi,
>>
>> we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22
>> kernel) as a hot standby. After some maintenances work the WAL files
>> couldn't be shipped to that system (which had nothing to do with
>> postgres, as we found out later). The problem was not noticed for about
>> a week. When looking for a reason why the WAL weren't shipped, we found
>> the following error message:
>>
>> 2008-10-31 17:07:52 CET 9162LOG:  received smart shutdown request
>> 2008-10-31 17:07:52 CET 9178FATAL:  could not restore file
>> "000000010000008600000018" from archive: return code 15
>>     
>
> This server was stopped intentionally by someone or something, external
> to Postgres itself.  "Smart shutdown" means the postmaster got SIGTERM.
>
>   



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux