Re: FSM corruption and standby servers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If or when I get a successfull installation containing the abovementioned components in 24/7 operation I
will try to contribute to your documentation. Before that I would appreciate if one of you kind people
would review the solution. The cluster(OS) design I intend to get rewieved by Redhat to be sure of zero faulttolerant.

Thanks.

Poul

2016-10-31 22:46 GMT+01:00 Poul Kristensen <bcc5226@xxxxxxxxx>:
I have some comments to the documentation. 

I worked with PostgreSQL for some time ago( 5-8 years)  setting up a few Postgres databases using version 8.4 and RHEL 5:* in production and still running.
A LOT have happened since then and I am going to setup Postgres 9+ with everything needed to secure data, backup(PITR) 
, cluster with zero dataloss. OS is RHEL 7.2.
I my opinion the documentation is not very straightforward with examples omn exactly how to make such a complete installation using
2+ servers to make data available 24/7. One has to pick up a little here and a litte there. And one always have to do a litte there and here to make things switch
in order to make data available 24/7. 
Creating of tablespace can't be scriptet, Restore(I know this another list(pg_rman) can't handle symbolic links. 
Sorry about my belching as vocabulary and my bad english!

/Poul
     

 

2016-10-31 19:19 GMT+01:00 Tom Lane <tgl@xxxxxxxxxxxxx>:
"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes:
> On Mon, Oct 31, 2016 at 9:55 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>> I would have thought that the referenced page is clear enough about
>> needing to check the standbys; do you think it isn't?

> ​I can ​see how the following is a bit loose for someone not super-familiar
> with WAL.

Yeah.  On the other hand, I don't want people who aren't running
replication to stop reading as soon as they see something about standby
servers.  I tweaked the existing wording a bit to emphasize that standbys
can be corrupt even with a valid master; hopefully that's enough.

                        regards, tom lane


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA



--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux