Re: Query returns no rows in pg_basebackup cluster - Mailing list pgsql-general

From Tom Lane
Subject Re: Query returns no rows in pg_basebackup cluster
Date
Msg-id 25753.1590157378@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query returns no rows in pg_basebackup cluster  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Query returns no rows in pg_basebackup cluster  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
"Andrus" <kobruleht2@hot.ee> writes:
>> No, what it sounds like is the OP tried to physically replicate a
>> database on another platform with completely different sorting rules.

> The sorting rules for this locale must be the same in both platforms.
> Only locale names are different.

I think they are less alike than you hoped, because if they were alike,
you wouldn't be seeing this problem.

Possibly you could try running contrib/amcheck on the index in question
and see if it reports any issues.

            regards, tom lane



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_dump crashes
Next
From: Michael Lewis
Date:
Subject: Re: Suggestion to improve query performance of data validation in proc.