Re: Several problems with installation on FreeBSD - how to reinstall without loosing data

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: Jon Theil Nielsen <jontheil(at)gmail(dot)com>
Cc: Kevin Grittner <kgrittn(at)ymail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Date: 2013-09-18 03:31:10
Message-ID: CAFS1N4iOe-kfOxh23OXpYjY8FhNbM9GOsjcfQLbYLb9zwGHNxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
You have lines in the output which say
"Sep 17 17:39:43 <local5.info> mflserver4 postgres[21022]: [39-1] LOG:
connection authorized: user=root database=root"
In case you are not doing it manually, do you have some cron job that is
expected to backup the database or vacuum the database, and it is trying to
connect to the database as root user, to database root?
Regards,
Jayadevan

On Tue, Sep 17, 2013 at 11:37 PM, Jon Theil Nielsen <jontheil(at)gmail(dot)com>wrote:

> > log_connections = on
>>> > log_disconnections = on
>>>
>>> With those turned on, there should be more lines of interest in the
>>> cluster's log. Reviewing the log is your best bet.
>>>
>>> --
>>> Kevin Grittner
>>> EDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
> The suggested log settings were already on. Debug level is currently 5.
>
> I don't know if it is right to use attachments on this list, so I will
> insert the output of my log file from a restart and a few minutes
> afterwards. Sorry, it takes a lot of space. But maybe someone clearly can
> see what the problem(s) is (are):
>
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [1-1] DEBUG:
> postgres: PostmasterMain: initial environment dump:
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [2-1] DEBUG:
> -----------------------------------------
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [3-1] DEBUG:
> LC_TIME=C
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [4-1] DEBUG:
> LC_NUMERIC=C
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [5-1] DEBUG:
> LC_MONETARY=C
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [6-1] DEBUG:
> LC_MESSAGES=C
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [7-1] DEBUG:
> LC_CTYPE=C
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [8-1] DEBUG:
> LC_COLLATE=C
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [9-1] DEBUG:
> MAIL=/var/mail/pgsql
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [10-1] DEBUG:
> PGLOCALEDIR=/usr/local/share/locale
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [11-1] DEBUG:
> PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/local/pgsql/bin
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [12-1] DEBUG:
> PGDATA=/usr/local/pgsql/data
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [13-1] DEBUG:
> PWD=/usr/local/pgsql
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [14-1] DEBUG:
> PGSYSCONFDIR=/usr/local/etc/postgresql
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [15-1] DEBUG:
> TERM=xterm
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [16-1] DEBUG:
> HOME=/usr/local/pgsql
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [17-1] DEBUG:
> USER=pgsql
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [18-1] DEBUG:
> SHELL=/bin/sh
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [19-1] DEBUG:
> PG_GRANDPARENT_PID=21003
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [20-1] DEBUG:
> BLOCKSIZE=K
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [21-1] DEBUG:
> -----------------------------------------
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [22-1] DEBUG:
> invoking IpcMemoryCreate(size=41279488)
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [23-1] DEBUG:
> SlruScanDirectory invoking callback on pg_notify/0000
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [24-1] DEBUG:
> removing file "pg_notify/0000"
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [25-1] DEBUG:
> max_safe_fds = 983, usable_fds = 1000, already_open = 7
> Sep 17 17:39:38 <local5.info> mflserver4 postgres[21008]: [26-1] LOG:
> database system was shut down at 2013-09-17 17:39:37 CEST
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [27-1] DEBUG:
> checkpoint record is at 0/DDB13D0
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [28-1] DEBUG:
> redo record is at 0/DDB13D0; shutdown TRUE
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [29-1] DEBUG:
> next transaction ID: 0/12904; next OID: 52598
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [30-1] DEBUG:
> next MultiXactId: 1597; next MultiXactOffset: 4415
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [31-1] DEBUG:
> oldest unfrozen transaction ID: 983, in database 1
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [32-1] DEBUG:
> transaction ID wrap limit is 2147484630, limited by database with OID 1
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [33-1] DEBUG:
> shmem_exit(0): 4 callbacks to make
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [34-1] DEBUG:
> proc_exit(0): 2 callbacks to make
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [35-1] DEBUG:
> exit(0)
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [36-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21008]: [37-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21006]: [26-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21009]: [27-1] DEBUG:
> checkpointer updated shared memory configuration values
> Sep 17 17:39:38 <local5.info> mflserver4 postgres[21006]: [27-1] LOG:
> database system is ready to accept connections
> Sep 17 17:39:38 <local5.info> mflserver4 postgres[21012]: [27-1] LOG:
> autovacuum launcher started
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21012]: [28-1] DEBUG:
> InitPostgres
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21012]: [29-1] DEBUG:
> my backend ID is 1
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21012]: [30-1] DEBUG:
> StartTransaction
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21012]: [31-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21012]: [32-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:38 <local5.debug> mflserver4 postgres[21012]: [33-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21006]: [28-1] DEBUG:
> forked new backend, pid=21014 socket=11
> Sep 17 17:39:39 <local5.info> mflserver4 postgres[21014]: [28-1] LOG:
> connection received: host=[local]
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [29-1] DEBUG:
> postgres child[21014]: starting with (
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [30-1] DEBUG:
> postgres
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [31-1] DEBUG: )
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [32-1] DEBUG:
> InitPostgres
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [33-1] DEBUG:
> my backend ID is 2
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [34-1] DEBUG:
> StartTransaction
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [35-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:39 <local5.info> mflserver4 postgres[21014]: [36-1] LOG:
> connection authorized: user=pgsql database=postgres
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [37-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [38-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [39-1] DEBUG:
> shmem_exit(0): 7 callbacks to make
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [40-1] DEBUG:
> proc_exit(0): 4 callbacks to make
> Sep 17 17:39:39 <local5.info> mflserver4 postgres[21014]: [41-1] LOG:
> disconnection: session time: 0:00:00.006 user=pgsql database=postgres
> host=[local]
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [42-1] DEBUG:
> exit(0)
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [43-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21014]: [44-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21006]: [29-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:39 <local5.debug> mflserver4 postgres[21006]: [30-1] DEBUG:
> server process (PID 21014) exited with exit code 0
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21006]: [31-1] DEBUG:
> forked new backend, pid=21022 socket=11
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21022]: [31-1] LOG:
> connection received: host=localhost port=40319
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [32-1] DEBUG:
> postgres child[21022]: starting with (
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [33-1] DEBUG:
> postgres
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [34-1] DEBUG: )
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [35-1] DEBUG:
> InitPostgres
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [36-1] DEBUG:
> my backend ID is 2
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [37-1] DEBUG:
> StartTransaction
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [38-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21022]: [39-1] LOG:
> connection authorized: user=root database=root
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [40-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [41-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [42-1] DEBUG:
> shmem_exit(0): 7 callbacks to make
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [43-1] DEBUG:
> proc_exit(0): 4 callbacks to make
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21022]: [44-1] LOG:
> disconnection: session time: 0:00:00.006 user=root database=root
> host=localhost port=40319
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [45-1] DEBUG:
> exit(0)
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21006]: [32-1] DEBUG:
> forked new backend, pid=21023 socket=11
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [46-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21022]: [47-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21023]: [32-1] LOG:
> connection received: host=[local]
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [33-1] DEBUG:
> postgres child[21023]: starting with (
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [34-1] DEBUG:
> postgres
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [35-1] DEBUG: )
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21006]: [33-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21006]: [34-1] DEBUG:
> server process (PID 21022) exited with exit code 0
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [36-1] DEBUG:
> InitPostgres
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [37-1] DEBUG:
> my backend ID is 2
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [38-1] DEBUG:
> StartTransaction
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [39-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21023]: [40-1] LOG:
> connection authorized: user=root database=root
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [41-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [42-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21023]: [43-1] LOG:
> could not send data to client: Broken pipe
> Sep 17 17:39:43 <local5.err> mflserver4 postgres[21023]: [44-1] FATAL:
> connection to client lost
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [45-1] DEBUG:
> shmem_exit(1): 7 callbacks to make
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [46-1] DEBUG:
> proc_exit(1): 4 callbacks to make
> Sep 17 17:39:43 <local5.info> mflserver4 postgres[21023]: [47-1] LOG:
> disconnection: session time: 0:00:00.003 user=root database=root
> host=[local]
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [48-1] DEBUG:
> exit(1)
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [49-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21023]: [50-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21006]: [35-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:43 <local5.debug> mflserver4 postgres[21006]: [36-1] DEBUG:
> server process (PID 21023) exited with exit code 1
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21012]: [34-1] DEBUG:
> StartTransaction
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21012]: [35-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21012]: [36-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21012]: [37-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [37-1] DEBUG:
> InitPostgres
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [38-1] DEBUG:
> my backend ID is 2
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [39-1] DEBUG:
> StartTransaction
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [40-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [41-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [42-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [43-1] DEBUG:
> autovacuum: processing database "root"
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [44-1] DEBUG:
> StartTransaction
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [45-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [46-1] DEBUG:
> pg_authid: vac: 0 (threshold 50), anl: 1 (threshold 50)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [47-1] DEBUG:
> pg_class: vac: 0 (threshold 108), anl: 0 (threshold 79)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [48-1] DEBUG:
> pg_attribute: vac: 0 (threshold 499), anl: 0 (threshold 275)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [49-1] DEBUG:
> pg_opclass: vac: 0 (threshold 74), anl: 0 (threshold 62)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [50-1] DEBUG:
> pg_am: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [51-1] DEBUG:
> pg_amproc: vac: 0 (threshold 107), anl: 0 (threshold 79)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [52-1] DEBUG:
> pg_database: vac: 1 (threshold 50), anl: 3 (threshold 50)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [53-1] DEBUG:
> pg_db_role_setting: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [54-1] DEBUG:
> pg_tablespace: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [55-1] DEBUG:
> pg_shdepend: vac: 0 (threshold 76), anl: 0 (threshold 63)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [56-1] DEBUG:
> pg_index: vac: 0 (threshold 72), anl: 0 (threshold 61)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [57-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [58-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [59-1] DEBUG:
> shmem_exit(0): 8 callbacks to make
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [60-1] DEBUG:
> proc_exit(0): 2 callbacks to make
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [61-1] DEBUG:
> exit(0)
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [62-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21030]: [63-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21006]: [37-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:54 <local5.debug> mflserver4 postgres[21006]: [38-1] DEBUG:
> server process (PID 21030) exited with exit code 0
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21006]: [39-1] DEBUG:
> forked new backend, pid=21031 socket=11
> Sep 17 17:39:58 <local5.info> mflserver4 postgres[21031]: [39-1] LOG:
> connection received: host=localhost port=16707
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [40-1] DEBUG:
> postgres child[21031]: starting with (
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [41-1] DEBUG:
> postgres
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [42-1] DEBUG: )
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [43-1] DEBUG:
> InitPostgres
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [44-1] DEBUG:
> my backend ID is 2
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [45-1] DEBUG:
> StartTransaction
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [46-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:58 <local5.info> mflserver4 postgres[21031]: [47-1] LOG:
> connection authorized: user=root database=root
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [48-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [49-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [50-1] DEBUG:
> shmem_exit(0): 7 callbacks to make
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [51-1] DEBUG:
> proc_exit(0): 4 callbacks to make
> Sep 17 17:39:58 <local5.info> mflserver4 postgres[21031]: [52-1] LOG:
> disconnection: session time: 0:00:00.002 user=root database=root
> host=localhost port=16707
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [53-1] DEBUG:
> exit(0)
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21006]: [40-1] DEBUG:
> forked new backend, pid=21032 socket=11
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [54-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21031]: [55-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:58 <local5.info> mflserver4 postgres[21032]: [40-1] LOG:
> connection received: host=[local]
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [41-1] DEBUG:
> postgres child[21032]: starting with (
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [42-1] DEBUG:
> postgres
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [43-1] DEBUG: )
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21006]: [41-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21006]: [42-1] DEBUG:
> server process (PID 21031) exited with exit code 0
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [44-1] DEBUG:
> InitPostgres
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [45-1] DEBUG:
> my backend ID is 2
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [46-1] DEBUG:
> StartTransaction
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [47-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:58 <local5.info> mflserver4 postgres[21032]: [48-1] LOG:
> connection authorized: user=root database=root
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [49-1] DEBUG:
> CommitTransaction
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [50-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:39:58 <local5.info> mflserver4 postgres[21032]: [51-1] LOG:
> could not send data to client: Broken pipe
> Sep 17 17:39:58 <local5.err> mflserver4 postgres[21032]: [52-1] FATAL:
> connection to client lost
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [53-1] DEBUG:
> shmem_exit(1): 7 callbacks to make
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [54-1] DEBUG:
> proc_exit(1): 3 callbacks to make
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [55-1] DEBUG:
> exit(1)
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [56-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21032]: [57-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21006]: [43-1] DEBUG:
> reaping dead processes
> Sep 17 17:39:58 <local5.debug> mflserver4 postgres[21006]: [44-1] DEBUG:
> server process (PID 21032) exited with exit code 1
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21012]: [38-1] DEBUG:
> StartTransaction
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21012]: [39-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21012]: [40-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21012]: [41-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [45-1] DEBUG:
> InitPostgres
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [46-1] DEBUG:
> my backend ID is 2
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [47-1] DEBUG:
> StartTransaction
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [48-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [49-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [50-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [51-1] DEBUG:
> autovacuum: processing database "davical"
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [52-1] DEBUG:
> StartTransaction
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [53-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [54-1] DEBUG:
> pg_statistic: vac: 5 (threshold 140), anl: 50 (threshold 95)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [55-1] DEBUG:
> pg_type: vac: 0 (threshold 138), anl: 0 (threshold 94)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [56-1] DEBUG:
> pg_authid: vac: 0 (threshold 50), anl: 1 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [57-1] DEBUG:
> pg_proc: vac: 0 (threshold 548), anl: 0 (threshold 299)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [58-1] DEBUG:
> pg_class: vac: 0 (threshold 135), anl: 0 (threshold 93)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [59-1] DEBUG:
> pg_attribute: vac: 0 (threshold 688), anl: 0 (threshold 369)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [60-1] DEBUG:
> pg_constraint: vac: 0 (threshold 65), anl: 0 (threshold 57)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [61-1] DEBUG:
> pg_operator: vac: 0 (threshold 196), anl: 0 (threshold 123)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [62-1] DEBUG:
> pg_opclass: vac: 0 (threshold 74), anl: 0 (threshold 62)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [63-1] DEBUG:
> pg_am: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [64-1] DEBUG:
> pg_amop: vac: 0 (threshold 129), anl: 0 (threshold 89)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [65-1] DEBUG:
> pg_amproc: vac: 0 (threshold 107), anl: 0 (threshold 79)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [66-1] DEBUG:
> pg_language: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [67-1] DEBUG:
> pg_aggregate: vac: 0 (threshold 74), anl: 0 (threshold 62)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [68-1] DEBUG:
> pg_rewrite: vac: 0 (threshold 71), anl: 0 (threshold 61)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [69-1] DEBUG:
> pg_trigger: vac: 0 (threshold 85), anl: 0 (threshold 68)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [70-1] DEBUG:
> pg_namespace: vac: 0 (threshold 51), anl: 0 (threshold 51)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [71-1] DEBUG:
> pg_database: vac: 1 (threshold 50), anl: 3 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [72-1] DEBUG:
> pg_db_role_setting: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [73-1] DEBUG:
> pg_tablespace: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [74-1] DEBUG:
> pg_shdepend: vac: 0 (threshold 69), anl: 0 (threshold 60)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [75-1] DEBUG:
> pg_attrdef: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [76-1] DEBUG:
> calendar_alarm: vac: 79 (threshold 172), anl: 47 (threshold 111)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [77-1] DEBUG:
> pg_index: vac: 0 (threshold 85), anl: 0 (threshold 68)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [78-1] DEBUG:
> awl_db_revision: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [79-1] DEBUG:
> caldav_data: vac: 12 (threshold 300), anl: 142 (threshold 175)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [80-1] DEBUG:
> calendar_item: vac: 1 (threshold 300), anl: 142 (threshold 175)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [81-1] DEBUG:
> calendar_attendee: vac: 0 (threshold 52), anl: 0 (threshold 51)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [82-1] DEBUG:
> dav_binding: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [83-1] DEBUG:
> pg_cast: vac: 0 (threshold 89), anl: 0 (threshold 70)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [84-1] DEBUG:
> collection: vac: 4 (threshold 51), anl: 40 (threshold 51)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [85-1] DEBUG:
> addressbook_resource: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [86-1] DEBUG:
> roles: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [87-1] DEBUG:
> supported_locales: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [88-1] DEBUG:
> sync_changes: vac: 0 (threshold 2320), anl: 142 (threshold 1185)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [89-1] DEBUG:
> property: vac: 0 (threshold 52), anl: 0 (threshold 51)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [90-1] DEBUG:
> role_member: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [91-1] DEBUG:
> grants: vac: 2 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [92-1] DEBUG:
> group_member: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [93-1] DEBUG:
> locks: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [94-1] DEBUG:
> session: vac: 11 (threshold 57), anl: 12 (threshold 53)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [95-1] DEBUG:
> principal: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [96-1] DEBUG:
> principal_type: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [97-1] DEBUG:
> usr: vac: 1 (threshold 51), anl: 1 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [98-1] DEBUG:
> sync_tokens: vac: 75 (threshold 8553), anl: 334 (threshold 4302)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [99-1] DEBUG:
> access_ticket: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [100-1] DEBUG:
> timezones: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [101-1] DEBUG:
> pg_toast_2619: vac: 6 (threshold 58), anl: 12 (threshold 54)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [102-1] DEBUG:
> pg_toast_2618: vac: 0 (threshold 84), anl: 0 (threshold 67)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [103-1] DEBUG:
> pg_toast_18402: vac: 22 (threshold 51), anl: 128 (threshold 50)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [104-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [105-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [106-1] DEBUG:
> shmem_exit(0): 8 callbacks to make
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [107-1] DEBUG:
> proc_exit(0): 2 callbacks to make
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [108-1] DEBUG:
> exit(0)
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [109-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21037]: [110-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21006]: [45-1] DEBUG:
> reaping dead processes
> Sep 17 17:40:09 <local5.debug> mflserver4 postgres[21006]: [46-1] DEBUG:
> server process (PID 21037) exited with exit code 0
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21006]: [47-1] DEBUG:
> forked new backend, pid=21038 socket=11
> Sep 17 17:40:13 <local5.info> mflserver4 postgres[21038]: [47-1] LOG:
> connection received: host=localhost port=16712
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [48-1] DEBUG:
> postgres child[21038]: starting with (
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [49-1] DEBUG:
> postgres
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [50-1] DEBUG: )
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [51-1] DEBUG:
> InitPostgres
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [52-1] DEBUG:
> my backend ID is 2
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [53-1] DEBUG:
> StartTransaction
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [54-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:13 <local5.info> mflserver4 postgres[21038]: [55-1] LOG:
> connection authorized: user=root database=root
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [56-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [57-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [58-1] DEBUG:
> shmem_exit(0): 7 callbacks to make
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [59-1] DEBUG:
> proc_exit(0): 4 callbacks to make
> Sep 17 17:40:13 <local5.info> mflserver4 postgres[21038]: [60-1] LOG:
> disconnection: session time: 0:00:00.002 user=root database=root
> host=localhost port=16712
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [61-1] DEBUG:
> exit(0)
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21006]: [48-1] DEBUG:
> forked new backend, pid=21039 socket=11
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [62-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21038]: [63-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:40:13 <local5.info> mflserver4 postgres[21039]: [48-1] LOG:
> connection received: host=[local]
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [49-1] DEBUG:
> postgres child[21039]: starting with (
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [50-1] DEBUG:
> postgres
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [51-1] DEBUG: )
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21006]: [49-1] DEBUG:
> reaping dead processes
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [52-1] DEBUG:
> InitPostgres
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [53-1] DEBUG:
> my backend ID is 2
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21006]: [50-1] DEBUG:
> server process (PID 21038) exited with exit code 0
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [54-1] DEBUG:
> StartTransaction
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [55-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:13 <local5.info> mflserver4 postgres[21039]: [56-1] LOG:
> connection authorized: user=root database=root
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [57-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:13 <local5.debug> mflserver4 postgres[21039]: [58-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:23 <local5.debug> mflserver4 postgres[21012]: [42-1] DEBUG:
> StartTransaction
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21012]: [43-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:13 <local5.info> mflserver4 postgres[21039]: [59-1] LOG:
> could not send data to client: Broken pipe
> Sep 17 17:40:26 <local5.err> mflserver4 postgres[21039]: [60-1] FATAL:
> connection to client lost
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21012]: [44-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21039]: [61-1] DEBUG:
> shmem_exit(1): 7 callbacks to make
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21039]: [62-1] DEBUG:
> proc_exit(1): 4 callbacks to make
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21012]: [45-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:26 <local5.info> mflserver4 postgres[21039]: [63-1] LOG:
> disconnection: session time: 0:00:12.618 user=root database=root
> host=[local]
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21039]: [64-1] DEBUG:
> exit(1)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21039]: [65-1] DEBUG:
> shmem_exit(-1): 0 callbacks to make
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21039]: [66-1] DEBUG:
> proc_exit(-1): 0 callbacks to make
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21006]: [51-1] DEBUG:
> reaping dead processes
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21006]: [52-1] DEBUG:
> server process (PID 21039) exited with exit code 1
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [53-1] DEBUG:
> InitPostgres
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [54-1] DEBUG:
> my backend ID is 2
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [55-1] DEBUG:
> StartTransaction
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [56-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [57-1] DEBUG:
> CommitTransaction
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [58-1] DEBUG:
> name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [59-1] DEBUG:
> autovacuum: processing database "postgres"
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [60-1] DEBUG:
> StartTransaction
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [61-1] DEBUG:
> name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [62-1] DEBUG:
> pg_statistic: vac: 0 (threshold 127), anl: 0 (threshold 88)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [63-1] DEBUG:
> pg_type: vac: 0 (threshold 116), anl: 0 (threshold 83)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [64-1] DEBUG:
> pg_authid: vac: 0 (threshold 50), anl: 1 (threshold 50)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [65-1] DEBUG:
> pg_proc: vac: 0 (threshold 548), anl: 0 (threshold 299)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [66-1] DEBUG:
> pg_class: vac: 0 (threshold 108), anl: 0 (threshold 79)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [67-1] DEBUG:
> pg_attribute: vac: 0 (threshold 499), anl: 0 (threshold 275)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [68-1] DEBUG:
> pg_operator: vac: 0 (threshold 196), anl: 0 (threshold 123)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [69-1] DEBUG:
> pg_opclass: vac: 0 (threshold 74), anl: 0 (threshold 62)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [70-1] DEBUG:
> pg_am: vac: 0 (threshold 51), anl: 0 (threshold 50)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [71-1] DEBUG:
> pg_amop: vac: 0 (threshold 129), anl: 0 (threshold 89)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [72-1] DEBUG:
> pg_amproc: vac: 0 (threshold 107), anl: 0 (threshold 79)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [73-1] DEBUG:
> pg_database: vac: 1 (threshold 50), anl: 3 (threshold 50)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [74-1] DEBUG:
> pg_namespace: vac: 0 (threshold 51), anl: 0 (threshold 51)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [75-1] DEBUG:
> pg_db_role_setting: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [76-1] DEBUG:
> pg_tablespace: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [77-1] DEBUG:
> pg_shdepend: vac: 0 (threshold 50), anl: 0 (threshold 50)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [78-1] DEBUG:
> pg_index: vac: 0 (threshold 72), anl: 0 (threshold 61)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [79-1] DEBUG:
> pg_cast: vac: 0 (threshold 89), anl: 0 (threshold 70)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [80-1] DEBUG:
> pg_toast_2619: vac: 0 (threshold 52), anl: 0 (threshold 51)
> Sep 17 17:40:26 <local5.debug> mflserver4 postgres[21043]: [81-1] DEBUG:
> CommitTransaction
>
> Regards,
> Jon
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Grittner 2013-09-18 08:55:31 Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Previous Message Jon Theil Nielsen 2013-09-17 18:07:43 Re: Several problems with installation on FreeBSD - how to reinstall without loosing data