pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: 1726002692@qq.com
Subject: BUG #17685: pg_rewind: error: unexpected result while fetching remote files: ERROR:  could not open file ".s.PGS
Date: Fri, 11 Nov 2022 12:22:10 +0000
Message-ID: <17685-2456943edafec3e7@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      17685
Logged by:          强 魏
Email address:      1726002692@qq.com
PostgreSQL version: 15.1
Operating system:   Centos 7.6
Description:        

unix_socket_directories=".,/tmp"   or unix_socket_directories='.'

pg_rewind will be error:pg_rewind: error: unexpected result while fetching
remote files: ERROR:  could not open file ".s.PGSQL.5433" for reading:
没有那个设备或地址

[pg15@PG02 pg151]$ pg_rewind --target-pgdata=/pgdata/pg151
--source-server="host=192.168.247.100 port=5433 user=postgres password=root
dbname=postgres" -R -n
pg_rewind: servers diverged at WAL location 0/300000D8 on timeline 8
pg_rewind: rewinding from last common checkpoint at 0/30000028 on timeline
8
pg_rewind: error: unexpected result while fetching remote files: ERROR: 
could not open file ".s.PGSQL.5433" for reading: 没有那个设备或地址


unix_socket_directories='/tmp'  pg_rewind is ok

[pg15@PG02 pg151]$ pg_rewind --target-pgdata=/pgdata/pg151
--source-server="host=192.168.247.100 port=5433 user=postgres password=root
dbname=postgres" -R
pg_rewind: servers diverged at WAL location 0/300000D8 on timeline 8
pg_rewind: rewinding from last common checkpoint at 0/30000028 on timeline
8
pg_rewind: Done!



Message-ID: <17685-2456943edafec3e7@postgresql.org>
Permalink:  ../17685-2456943edafec3e7@postgresql.org/
Also on:    postgresql.org/message-id/17685-2456943edafec3e7@postgresql.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, 1726002692@qq.com
  Subject: Re: BUG #17685: pg_rewind: error: unexpected result while fetching remote files: ERROR:  could not open file ".s.PGS
  In-Reply-To: <17685-2456943edafec3e7@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox