[GENERAL] My postgres is not logging anymore

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello. I have a postgres cluster made by two nodes with OS Ubuntu 14.04. About two weeks ago I did a minor update of postgres to the version 9.4.1-1.pgdg70+1. After I had to shutdown the machines and I could start them just last week. Since then postgr

Re: [GENERAL] My postgres is not logging anymore

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/18/2015 11:48 AM, Raymond O'Donnell wrote: > On 18/06/2015 10:34, Maila Fatticcioni wrote: >> Hello. I have a postgres cluster made by two nodes with OS Ubuntu >> 14.04. About two weeks ago I did a minor update of postgr

[GENERAL] Best filesystem for a high load db

and I would like to know which filesystem you would suggest me to use. I have read that ZFS with ZIL is now mature for a production server: do you think it is that true or that it would be better to stay safer with a common EXT4? Thanks in advance. Maila Fatticcioni -BEGIN PGP SIGNATURE

Re: [GENERAL] Best filesystem for a high load db

Thank you a lot to have shared with me your experiences. Indeed we will have two servers in cluster with high quality hardware so a fsck restore shouldn't be a big problem. I will analize the xfs option as well and then I will decide. Thank you again, Maila Fatticcioni - -- _

[GENERAL] High Availability Cluster

master to the slave instance of Postgresql. I was wondering if there is another way to set up a complete cluster that would manage in case of failure: * the relocation of the VIP (virtual ip address) * the relocation of the main instance of Postgresql Best Regards, Maila Fatticcioni -BEGIN PGP

Re: [GENERAL] High Availability Cluster

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/27/2014 12:34 PM, Andreas Kretschmer wrote: > Maila Fatticcioni wrote: > >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> >> Hello. I need to set up a high availability cluster with two >> servers. I have loo