Re: Which background task looks for pg_xlog in 10?

From: rob stone <floriparob(at)gmail(dot)com>
To: Johann Spies <johann(dot)spies(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Which background task looks for pg_xlog in 10?
Date: 2018-08-28 07:45:14
Message-ID: 26bbc1764d522d0710ed6f55f2eb9f8e82fdc9aa.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

On Tue, 2018-08-28 at 08:32 +0200, Johann Spies wrote:
> I see this in /var/log/postgresql/postgresql-10-main.log:
>
> postgres postgres(at)template1 ERROR: could not open directory
> "pg_xlog": No such file or directory
>
> postgres postgres(at)template1 STATEMENT: SELECT count(*) AS segments
> FROM pg_ls_dir('pg_xlog') t(fn) \
> WHERE fn ~ '^[0-9A-Z]{24}$'
>
> Where does this come from?
>
> Regards
> Johann
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you. (Psalm 63:3)
>

There is no directory pg_xlog in V10.

You might have some incompatible software somewhere or an application
is running this query.

Why does it say "postgres(at)template1?

Cheers,
Rob

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Haroldo Stenger 2018-08-28 07:49:09 Re: How to search particular line/text code in all Postgres all database object's
Previous Message Johann Spies 2018-08-28 06:32:38 Which background task looks for pg_xlog in 10?