| From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> |
| Subject: | Re: Query returns no rows in pg_basebackup cluster |
| Date: | 2020-05-22 06:15:39 |
| Message-ID: | 374800ED73A6423B9FF49F4763D83648@dell2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
>>Main server is in Linux and backup server is in windows.
>This is not a supported setup if you want to run a physical backup.
>Your backup and your primary need to be the same - software and hardware. Consider anything that is working to be a false
>negative – assume >something will break or simply give incorrect results.
This base backup should used for recovery. Taking new base backup in Linux does not allow to recover to earlier date.
Both servers have Intel 64 bit CPUs.
I understand that only issue is the index structure and that REINDEX will fix this.
What other issues may occur ?
Will pg_dump/pg_restore in Windows server fix all issues.
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-22 06:41:10 | Suggestion to improve query performance of data validation in proc. |
| Previous Message | David G. Johnston | 2020-05-22 05:56:30 | Re: Query returns no rows in pg_basebackup cluster |