22.12.2016, 04:21, "Adrian Klaver" <adrian.kla...@aklaver.com>:
> On 12/21/2016 02:17 PM, n...@olansoft.com wrote:
>> Hi.
>>
>> Perhaps i've sent it to wrong mail-list previously.
>>
>> After the upgrade postgresql had a strange behavior. After the crash,
>> server launch now take a long time, up to 30-40 minutes sometimes. When
>> connecting to the server (as well as in the log), the message - "the
>> database system is starting up". Startup process consumes 0.4 - 1% CPU.
>
> What upgrade and how was it done?
By standard distro method (emerge in my case), and then pg_upgrade utility
(according to pg docs). Upgrade was from 9.4 to 9.5, and now 9.5.3 to 9.6.1.
>
> What crash and what caused it?
>
> In particular why are you seeing multiple crashes?
Sorry, I did not specify a crash, i mean technical failure on the server -
power failure or sometimes CPU overheating ("home" server problem).
>
> What is the log just before the crash?
Nothing, as expected, since it's not postgresql crash.
>
> What is the log after the the "database system is starting up" part?
First - "the database system was interrupted; last known up at..."
then many times "database system is starting up" (one per connection attempt)
and after 5-40 min i get - database system was not properly shut down;
automatic recovery in progress...redo starts from...ready to accept
connections, and, finally, everything is going well.
(my logs in ru_RU locale, so do not place them here)
>
>> Tried different version 9.5.[2,3,4], 9.6.1 (9.4 works fine). On the
>> Internet this problem is not met, perhaps the problem lies in a combination
>> of different factors (configuration database, Linux kernel), may be my
>> config is wrong?
>
> Do you mean you searched for this problem description and could not find it?
Yes, it is, my fault, Google translator is not always saving me from mistakes.
>
>> Technical details:
>>
>> Gentoo Linux 4.4.2-hardened
>> current pg version 9.6.1
>>
>> ## pg config:
>>
>> listen_addresses = '*'
>> port = 5432
>> max_connections = 500
>> shared_buffers = 2048MB
>> temp_buffers = 16MB
>> work_mem = 64MB
>> maintenance_work_mem = 512MB
>> max_stack_depth = 4MB
>> dynamic_shared_memory_type = posix
>> wal_level = replica
>> wal_buffers = 8MB
>> checkpoint_completion_target = 0.85
>> archive_mode = on
>> archive_command = 'gzip < %p > /home/pgbasebackup/xlogs/%f.gz'
>> max_wal_senders = 3
>> effective_cache_size = 9GB
>> log_min_duration_statement = 1500
>> log_timezone = 'Asia/Yekaterinburg'
>> datestyle = 'iso, dmy'
>> timezone = 'Asia/Yekaterinburg'
>> lc_messages = 'ru_RU.UTF-8'
>> lc_monetary = 'ru_RU.UTF-8'
>> lc_numeric = 'ru_RU.UTF-8'
>> lc_time = 'ru_RU.UTF-8'
>> default_text_search_config = 'pg_catalog.russian'
>> plperl.on_init = 'use utf8; use re; package utf8; require "utf8_heavy.pl";'
>>
>> ## end of config
>>
>> Sorry for my eng :)
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
