Re: Postgresql backup via LVM snapshot?

2019-06-03 Thread Bruno Lavoie
can share experience with PG + ZFS ? Hope that helps Bruno Lavoie On 2019-05-30 3:38 p.m., Lu, Dan wrote: Hello, Would you be able to confirm for me that a host level LVM snapshot of the PGDATA directory along with PG_WAL directly via LVM backup is supported way of backup and restore? I

Instructions to build from source RPMs

2019-05-09 Thread Bruno Lavoie
Hello, I want to build a custom postgresql-server from source packages to change and test some compile time parameters. I didn't find any guide on how to do this. Any advice of guide? Thanks

Re: Shared hosting with FDW on AWS RDS

2019-02-15 Thread Bruno Lavoie
On 2019-02-14 10:21 p.m., Bruce Momjian wrote: On Sun, Feb 10, 2019 at 03:19:48PM -0800, Paul Jungwirth wrote: On 2/10/19 2:57 PM, auxsvr wrote: We'd like to configure an RDS server for shared hosting. The idea is that every customer will be using a different database and FDW will be

Re: Anonymize Data

2019-01-29 Thread Bruno Lavoie
Not an extension but this post can be useful about various strategies: https://blog.taadeem.net///english/2019/01/03/8_anonymization_strategies_with_postgres Each with strengths and weaknesses Le mar. 29 janv. 2019 5:08 AM, Sathish Kumar a écrit : > Hi Team, > > I am trying to protect some

Multiple Hosts connection with ODBC Driver

2018-11-20 Thread Bruno Lavoie
to the primary server like the way we can with native libpq. Reference: https://www.postgresql.org/docs/10/libpq-connect.html#LIBPQ-MULTIPLE-HOSTS Near the page end: target_session_attrs=read-write Thanks Bruno Lavoie

Re: Failed rpm package signature checks with reposync

2018-06-19 Thread Bruno Lavoie
Hi Devrim, It works now. Thanks On Mon, Jun 18, 2018 at 9:22 AM, Devrim Gündüz wrote: > > Hi Bruno, > > On Mon, 2018-06-18 at 08:31 -0400, Bruno Lavoie wrote: > > > > Sorry, me too just saw your email... > > > > Issue still persists: > >

Re: Failed rpm package signature checks with reposync

2018-06-18 Thread Bruno Lavoie
wrote: > > Hi, > > Just saw this email. Does the problem still persist? > > Regards, Devrim > > On Wed, 2018-04-25 at 11:22 -0400, Bruno Lavoie wrote: > > Hello, > > > > Don't know if I should post it to hackers list, by I'll try here first. > >

Failed rpm package signature checks with reposync

2018-04-25 Thread Bruno Lavoie
/rhel-7-x86_64 enabled=0 gpgcheck=1 gpgkey=https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-10 Any reasons for this? Thanks Bruno Lavoie