Re: [GENERAL] PostgresSQL and HIPAA compliance

On 2016-06-17 14:09, Paul Jungwirth wrote: > On 06/17/2016 03:03 AM, Alex John wrote: >> RDS is a prime candidate except for the fact that they have explicitly >> stated that the Postgres engine is *not* HIPAA compliant. > > More precisely, it is not covered by the BAA Amazon will sign. > > I've

Re: [GENERAL] OT hardware recommend

On 18/06/16 14:23, Scott Marlowe wrote: On Fri, Jun 17, 2016 at 2:36 PM, Andy Colson > wrote: Hi all. I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box that might have some good IO speed

Re: [GENERAL] OT hardware recommend

On Fri, Jun 17, 2016 at 2:36 PM, Andy Colson wrote: > Hi all. > > I have access to quite a few laptop HD's (10 to 15 of them at least), and > thought that might make a neat test box that might have some good IO speed. > > Needs to be cheap though, so linux with software raid, rack mount > preferr

Re: [GENERAL] UUID and Enum columns in exclusion constraints

Hi Adam, On 06/17/2016 03:01 PM, Adam Brusselback wrote: Just wondering what others have done for using enum or uuid columns in exclusion constraints? [snip] And as a closing note on this, I really can't wait until these are supported types for gist indexes. Here is some work I did to add supp

[GENERAL] UUID and Enum columns in exclusion constraints

Just wondering what others have done for using enum or uuid columns in exclusion constraints? I have a solution now, but I just wanted to see what others have ended up doing as well and see if what i'm doing is sane. If i'm doing something unsafe, or you know of a better way, please chime in. Fo

Re: [GENERAL] OT hardware recommend

On 6/17/2016 2:33 PM, John W Higgins wrote: http://www.ebay.com/itm/2U-24-bay-2-5-Supermicro-Server-X8DTH-iF-2x-Xeon-Quad-Core-32GB-RAM-SAS2-216EL1-/222132081393?hash=item33b81a92f1:g:UzYAAOSwR5dXSQVw With it being 2U you can then pop out the motherboard and go with anything more modern you wan

Re: [GENERAL] OT hardware recommend

On 18/06/16 08:36, Andy Colson wrote: Hi all. I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box that might have some good IO speed. Needs to be cheap though, so linux with software raid, rack mount preferred but not required.

Re: [GENERAL] OT hardware recommend

I would start with something like this http://www.ebay.com/itm/2U-24-bay-2-5-Supermicro-Server-X8DTH-iF-2x-Xeon-Quad-Core-32GB-RAM-SAS2-216EL1-/222132081393?hash=item33b81a92f1:g:UzYAAOSwR5dXSQVw With it being 2U you can then pop out the motherboard and go with anything more modern you wanted in

[GENERAL] OT hardware recommend

Hi all. I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box that might have some good IO speed. Needs to be cheap though, so linux with software raid, rack mount preferred but not required. Anyone have any experience with anythi

Re: [GENERAL] Regression in query optimizer when upgrading from 9.4.5 to 9.5.2?

"Erdmann, Markus @ Bellevue" writes: > We’re trying to debug a performance issue affecting our staging database, and > we’ve narrowed it down to a difference in the query optimizer in 9.5.2. > Upgrading to 9.5 is important for us because we need the ability to import > foreign schemas. I think

Re: [GENERAL] PostgresSQL and HIPAA compliance

-Original Message- From: Alex John Sent: Friday, June 17, 2016 3:04 AM To: pgsql-general@postgresql.org Subject: [GENERAL] PostgresSQL and HIPAA compliance Hello, I have a few questions regarding the use of PostgreSQL and HIPAA compliance. I work for a company that plans on storing protect

Re: [GENERAL] PostgresSQL and HIPAA compliance

On 06/17/2016 03:03 AM, Alex John wrote: RDS is a prime candidate except for the fact that they have explicitly stated that the Postgres engine is *not* HIPAA compliant. More precisely, it is not covered by the BAA Amazon will sign. I've helped several companies run HIPAA-compliant Postgres on

Re: [GENERAL] Regression in query optimizer when upgrading from 9.4.5 to 9.5.2?

On Thu, Jun 16, 2016 at 8:40 PM, Erdmann, Markus @ Bellevue < markus.erdm...@cbre.com> wrote: > Hello, > > We’re trying to debug a performance issue affecting our staging database, > and we’ve narrowed it down to a difference in the query optimizer in 9.5.2. > Upgrading to 9.5 is important for us

Re: [GENERAL] Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

On Fri, Jun 17, 2016 at 2:16 PM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > hi sir > > as you mentioned above > > members in pgsql mailing list were not frustrating about my tone & mail > which i sent related to postgres > > as i believe they are always happy to serve for postgres >

Re: [GENERAL] PostgresSQL and HIPAA compliance

On 06/17/2016 03:03 AM, Alex John wrote: Hello, I have a few questions regarding the use of PostgreSQL and HIPAA compliance. I work for a company that plans on storing protected health information (PHI) on our servers. We have looked at various solutions for doing so, and RDS is a prime candidate

Re: [GENERAL] PostgresSQL and HIPAA compliance

The method you use to store the data is irrelevant. Access to your network. Logging. If you're encrypting the disk. How is the application presenting this data. What kind of ACLs are you using. Asking if PG is good to store HIPAA data is exactly as useful as asking if you can even store HIPAA data.

Re: [GENERAL] PostgresSQL and HIPAA compliance

> On Jun 17, 2016, at 3:03 AM, Alex John wrote: > > Hello, I have a few questions regarding the use of PostgreSQL and HIPAA > compliance. I work for a company that plans on storing protected health > information (PHI) on our servers. We have looked at various solutions for > doing > so, and RDS

[GENERAL] PostgresSQL and HIPAA compliance

Hello, I have a few questions regarding the use of PostgreSQL and HIPAA compliance. I work for a company that plans on storing protected health information (PHI) on our servers. We have looked at various solutions for doing so, and RDS is a prime candidate except for the fact that they have explici

[GENERAL] Regression in query optimizer when upgrading from 9.4.5 to 9.5.2?

Hello, We’re trying to debug a performance issue affecting our staging database, and we’ve narrowed it down to a difference in the query optimizer in 9.5.2. Upgrading to 9.5 is important for us because we need the ability to import foreign schemas. This is the query we’re running: CREATE TEMP

Re: ***SPAM*** Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

On 06/17/2016 09:01 AM, Catalin Maftei wrote: Please do not top post: https://en.wikipedia.org/wiki/Posting_style well, the for your reply, we have PG on linux ubuntu 14.04 distribution, but pls remember this issue started when our DB size increase to 3-5GB, now it is 16GB. See Merlins pos

Re: ***SPAM*** Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

On Fri, Jun 17, 2016 at 12:01 PM, Catalin Maftei wrote: > well, > > the for your reply, > > we have PG on linux ubuntu 14.04 distribution, but pls remember this issue > started when our DB size increase to 3-5GB, now it is 16GB. > > this happend only when we use "*CREATE OR REPLACE"* > > > since

Re: [GENERAL] Question about RUM-index

On Fri, Jun 17, 2016 at 4:50 PM, Andreas Joseph Krogh wrote: > På fredag 17. juni 2016 kl. 15:47:08, skrev Oleg Bartunov < > obartu...@gmail.com>: > > > > On Fri, Jun 17, 2016 at 3:52 PM, Andreas Joseph Krogh > wrote: >> >> På fredag 17. juni 2016 kl. 13:53:34, skrev Oleg Bartunov < >> obartu...

Re: [GENERAL] Question about RUM-index

På fredag 17. juni 2016 kl. 15:47:08, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:     On Fri, Jun 17, 2016 at 3:52 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 17. juni 2016 kl. 13:53:34, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:     On Fri, Jun 17, 2016 at 2

Re: [GENERAL] Question about RUM-index

On Fri, Jun 17, 2016 at 3:52 PM, Andreas Joseph Krogh wrote: > På fredag 17. juni 2016 kl. 13:53:34, skrev Oleg Bartunov < > obartu...@gmail.com>: > > > > On Fri, Jun 17, 2016 at 2:10 PM, Oleg Bartunov > wrote: >> >> >> >> On Fri, Jun 17, 2016 at 9:32 AM, Andreas Joseph Krogh > > wrote: >>> >>>

Re: ***SPAM*** Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

On Thu, Jun 16, 2016 at 6:55 PM, Melvin Davidson wrote: You have not provided information as to the O/S of the PostgreSQL server or your PgAdmin remote system (I suspect Windows), but regardless, you > are just asking for trouble by doing development over a remote connection. > You should verify

[GENERAL] Creating or modifying a tsquery from PL/pgSQL

I'd like to convert a plain search string into a tsquery, much like plainto_tsquery(), but enabling prefix searches (:*) for every word. I've come up with this: select regexp_replace( plainto_tsquery('english', 'text to search')::text, '''(?= |$)', ''':*', 'g' )::tsq

Re: [GENERAL] Table ordering in pg_dump

On Thu, Jun 16, 2016 at 10:32 AM, Jean-Francois Prieur wrote: > 1) Is there any way to tell pg_dump the order in which the tables should > be dumped? > 2) Am I correct to assume that if I use the --disable-trigger option in > pg_restore it should mitigate the problem? This only works on a data-on

Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei wrote: > when I recreate a VIEW or FUNCTION with a small change I get: > > Query returned successfully with no result in 03:58 minutes. This is almost certainly due to locks. Next time this happens, query pg_stat_activity and pg_locks -- the inform

Re: [GENERAL] Hot disable WAL archiving

On Fri, 17 Jun 2016, 9:12 p.m. Igor Neyman, wrote: > > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] On Behalf Of Job > Sent: Friday, June 17, 2016 9:01 AM > To: Albe Laurenz ; pgsql-general@postgresql.org > Subject: [GENERAL]

Re: [GENERAL] Hot disable WAL archiving

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Job Sent: Friday, June 17, 2016 9:01 AM To: Albe Laurenz ; pgsql-general@postgresql.org Subject: [GENERAL] R: Hot disable WAL archiving Hi Albe and thank you, first of all

[GENERAL] R: Hot disable WAL archiving

Hi Albe and thank you, first of all. Is there a way to disable Wal logging only for specific table, permanently? Thank you again! Francesco Da: Albe Laurenz [laurenz.a...@wien.gv.at] Inviato: venerdì 17 giugno 2016 13.48 A: Job; pgsql-general@postgresql.o

Re: [GENERAL] Question about RUM-index

På fredag 17. juni 2016 kl. 13:53:34, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:     On Fri, Jun 17, 2016 at 2:10 PM, Oleg Bartunov mailto:obartu...@gmail.com>> wrote:     On Fri, Jun 17, 2016 at 9:32 AM, Andreas Joseph Kroghmailto:andr...@visena.com>> wrote: På torsdag 16. juni 2016 kl. 0

Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

On Fri, Jun 17, 2016 at 8:29 PM, Job wrote: > i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with > Postgresql 9.5. > If i use a previous version of Psql it compile and works. The project page states that 9.5 is supported with this version: https://github.com/ossc-db/pg_bul

Re: [GENERAL] Question about RUM-index

On Fri, Jun 17, 2016 at 2:10 PM, Oleg Bartunov wrote: > > > On Fri, Jun 17, 2016 at 9:32 AM, Andreas Joseph Krogh > wrote: > >> På torsdag 16. juni 2016 kl. 00:50:45, skrev Jeff Janes < >> jeff.ja...@gmail.com>: >> >> On Wed, Jun 15, 2016 at 3:56 AM, Andreas Joseph Krogh > > wrote: >>> >>> Hi. >

Re: [GENERAL] Hot disable WAL archiving

Job wrote: > is there a way in Postgresql-9.5 to disable temporarily WAL archiving to > speed up pg_bulkload with > restarting database engine? You can set 'archive_command=/bin/true' and reload, then no WAL archives will be written. Make sure to perform a base backup as soon as your bulk load i

[GENERAL] Hot disable WAL archiving

Hello, is there a way in Postgresql-9.5 to disable temporarily WAL archiving to speed up pg_bulkload with restarting database engine? Thank you, Francesco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailp

[GENERAL] Pg_bulkload for PostgreSql 9.5

Hello, i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with Postgresql 9.5. If i use a previous version of Psql it compile and works. Thank you if you can help me Francesco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] Question about RUM-index

On Fri, Jun 17, 2016 at 9:32 AM, Andreas Joseph Krogh wrote: > På torsdag 16. juni 2016 kl. 00:50:45, skrev Jeff Janes < > jeff.ja...@gmail.com>: > > On Wed, Jun 15, 2016 at 3:56 AM, Andreas Joseph Krogh > wrote: >> >> Hi. >> >> First; Is this the correct forum to ask questions about the Postgre

Re: [GENERAL] Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

hi sir as you mentioned above members in pgsql mailing list were not frustrating about my tone & mail which i sent related to postgres as i believe they are always happy to serve for postgres as well as i like very much postgres On Thu, Jun 16, 2016 at 9:33 PM, Sameer Kumar wrote: > Discla

Re: [GENERAL] Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

hi sir as per above conversation i need to download jdbc driver as sameer suggested on migration with runmtk.sh from sql to postgres thank you sir super fast response only from postgres pgdg regarding postgres issues On Fri, Jun 17, 2016 at 1:18 AM, Adrian Klaver wrote: > On 06/16/2016 11: