Re: Postgresql database encryption

Hi, Vikas, On Fri, Apr 20, 2018 at 10:24 AM, Vikas Sharma wrote: > Hello Guys, > > Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. > > This is a requirement in our

Re: Dynamically filtering a CTE?

On Fri, Apr 20, 2018 at 9:22 AM, W. Trevor King wrote: > format(' > WITH RECURSIVE _ancestors(id, ancestors) AS ( > SELECT > item.id AS id, > ARRAY[item.ancestor_id] AS ancestors > FROM items AS item > %s > ​[...]​ > > ',

Re: Dynamically filtering a CTE?

On Thu, Apr 19, 2018 at 05:28:00PM -0700, David G. Johnston wrote: > On Thursday, April 19, 2018, W. Trevor King wrote: > > Is there an idiomatic way to approach this problem? > > I would use pl/pgsql as the language and build a query using a > combination of text literals and the format()

Re: New website

> On Apr 18, 2018, at 8:38 PM, Adrian Klaver wrote: > > Clicking on the Mailing List link on front page should take you to page that > includes the archives. We’ve added a button that brings you to the archives from the homepage. Thanks, Jonathan

Re: New website

On 04/20/2018 11:33 AM, Jonathan S. Katz wrote: On Apr 18, 2018, at 8:38 PM, Adrian Klaver > wrote: Clicking on the Mailing List link on front page should take you to page that includes the archives. We’ve added a button that

Re: Postgresql database encryption

> Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. As far as I know there's no open source solution for instance or database wide encryption. If commercial solutions are ok for you,

Re: Postgresql database encryption

What requirements do you have? Would enabling full disk encryption suite your needs? On April 20, 2018 11:14:30 AM CDT, Tatsuo Ishii wrote: >> Could someone throw light on the postgresql instance wide or database >wide >> encryption please? Is this possible in postgresql and

Re: Dynamically filtering a CTE?

On Fri, Apr 20, 2018 at 09:33:22AM -0700, David G. Johnston wrote: > On Fri, Apr 20, 2018 at 9:22 AM, W. Trevor King wrote: > > format(' > > WITH RECURSIVE _ancestors(id, ancestors) AS ( > > SELECT > > item.id AS id, > > ARRAY[item.ancestor_id] AS ancestors > >

Re: Postgresql database encryption

On 04/20/2018 06:11 PM, Stephen Frost wrote: Greetings, * Ron (ronljohnso...@gmail.com) wrote: On 04/20/2018 03:55 PM, Vick Khera wrote: On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma

Re: Problem with trigger makes Detail record be invalid

Well, talking about responsabilities, I think one of responsabilities of a mature database is that it can only accept data it was configured for. If you try to store a timestamp in a integer field or a huge numeric value in a smallint field, Postgres will block you because that operation is not

Re: New website

> On Apr 20, 2018, at 2:57 PM, Adrian Klaver wrote: > > On 04/20/2018 11:33 AM, Jonathan S. Katz wrote: >>> On Apr 18, 2018, at 8:38 PM, Adrian Klaver >> > wrote: >>> >>> Clicking on the Mailing List link

Re: New website

On 04/20/2018 02:10 PM, Jonathan S. Katz wrote: While we are on the subject of Mailing Lists, it would help new users if they could see the list choices and what each list covers. Basically what you see when you go to the Archive section. As it is now going here:

Re: Postgresql database encryption

Greetings, * Ron (ronljohnso...@gmail.com) wrote: > On 04/20/2018 03:55 PM, Vick Khera wrote: > >On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma >For anyone to offer a proper solution, you need to say what purpose your > >encryption will serve. Does the data need to be

Re: Problem with trigger makes Detail record be invalid

On 04/20/2018 01:30 PM, PegoraroF10 wrote: Well, talking about responsabilities, I think one of responsabilities of a mature database is that it can only accept data it was configured for. If you try to store a timestamp in a integer field or a huge numeric value in a Actually there have been

Re: Postgresql database encryption

On 04/20/2018 03:55 PM, Vick Khera wrote: On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma > wrote: Hello Guys, Could someone throw light on the postgresql instance wide or database wide encryption please? Is this possible in postgresql

Re: Postgresql database encryption

Ron writes: > On 04/20/2018 03:55 PM, Vick Khera wrote: >> On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma > > wrote: >> > > Someone really needs to explain that to me. My company-issued laptop has > WDE, and that's great

Re: Postgresql database encryption

Vikas Sharma writes: > Hello Guys, > > Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. > > This is a requirement in our production implementation. > This sounds

Re: Strange error in Windows 10 Pro

Oops, my mistake.  I'll let this serve the list with what I've tried so far.  Thanks, Adrian for the reminder. I hope tomorrow to visit the customer and try the Admin user method of installing. Dale On 4/20/2018 11:03 PM, Adrian Klaver wrote: On 04/20/2018 07:52 PM, Dale Seaburg wrote:

Re: Strange error in Windows 10 Pro

On 04/20/2018 07:52 PM, Dale Seaburg wrote: Please also reply to list. Ccing list to put it front of more eyes. Thanks, Adrian, for suggestion(s). On 4/20/2018 9:35 PM, Adrian Klaver wrote: On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of

Re: Postgresql database encryption

Well, actually since 2003, this has been a standard requirement from the Credit Card industry. And it does make sense in the field of "while at rest" the data still cannot be accessed. Requirement 1. No NPI data should be displayed without controls - e.g. reports, PDF, etc. Requirement 2. Same

Re: Postgresql database encryption

On 04/20/2018 10:24 AM, Vikas Sharma wrote: Hello Guys, Could someone throw light on the postgresql instance wide or database wide encryption please? Is this possible in postgresql and been in use in production?. What about encrypted backups? -- Angular momentum makes the world go 'round.

Strange error in Windows 10 Pro

I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro.  It gets near the end of the install when the message says it is attempting to start the the database server.   There's a long pause, followed by an error message: "Failed to load

Re: Postgresql database encryption

PS. the following database servers do offer internal encryption on a page/block oriented read/write (for encrypted data at rest security requirements) PremierSQL TDE MariaDB 10.1.3+ *MySQL* 5.7.11+ Microsoft uses TDE Oracle AdvSec uses TDE DB2 v7.2 UDB MangoDB uses AES-256 PostgreSQL does - but

Re: Strange error in Windows 10 Pro

On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro.  It This was downloaded from where? gets near the end of the install when the message says it is attempting to start the the database

Re: Postgresql database encryption

Greetings, * Ron (ronljohnso...@gmail.com) wrote: > On 04/20/2018 06:11 PM, Stephen Frost wrote: > >* Ron (ronljohnso...@gmail.com) wrote: > >>On 04/20/2018 03:55 PM, Vick Khera wrote: > >>>On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma >>>For anyone to offer a proper

Postgresql database encryption

Hello Guys, Could someone throw light on the postgresql instance wide or database wide encryption please? Is this possible in postgresql and been in use in production?. This is a requirement in our production implementation. Many Thanks Vikas Sharma

Re: Doubts about replication..

Hi, If you want to reduce the amount of data lost, you might want to consider another type of backup : https://www.postgresql.org/docs/current/static/continuous-archiving.html That awsome tool can also help you with it : https://pgbackrest.org/ On 04/19/2018 08:48 PM, Edmundo Robles wrote: >

Re: pg_upgrade help

Hi Akshay, I m glad it worked. * Your new data folder will be on /var/ericsson/esm-data/postgresql-data-9.4/ therefore you should set PGDATA accordingly * analyze_new_cluster.sh runs on the new cluster, 9.4. Indeed you should start the db first, as mentioned in the upgrade message. If you

Re: Problem with trigger makes Detail record be invalid

On 04/19/2018 06:49 PM, PegoraroF10 wrote: Correct, that delete done a partial commit. And this is absolutely unacceptable. Yet a known possible outcome. See the section on Triggers towards bottom of page: https://en.wikipedia.org/wiki/Foreign_key I know I did that trigger incorrectly but

Re: postgres on physical replica crashes

Hi Greig, just last week I experienced the same situation as you on a 10.3 physical replica (it even has checksums activated), and a few months ago on 9.6 . We used the same resolution as you we, and so far we haven't noticed any problems with data integrity on the replicas. The logs

Re: Problem with trigger makes Detail record be invalid

On 04/20/2018 07:21 AM, David G. Johnston wrote: On 04/19/2018 06:49 PM, PegoraroF10 wrote: On Fri, Apr 20, 2018 at 6:55 AM, Adrian Klaver >wrote: I know I did that trigger incorrectly but referential integrity is

Re: A couple of pg_dump questions

On Thu, Apr 19, 2018 at 6:39 PM, Ron wrote: > > $ pg_dump --host=farawaysrvr -Fc $REMOTEDB > /local/disk/backups/$REMOTEDB. > dump > > Is the data compressed on the remote server (thus minimizing traffic on > the wire), or locally? (I'd test this myself, but the company