Re: [GENERAL] PG and database encryption

On 22-08-2017 22:48, rakeshkumar464 wrote: We have a requirement to encrypt the entire database. What is the best tool to accomplish this. Our primary goal is that it should be transparent to the application, with no change in the application, as compared to un-encrypted database. Reading

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

On Tue, Aug 22, 2017 at 11:39 PM, Magnus Hagander wrote: > On Tue, Aug 22, 2017 at 3:06 AM, Michael Paquier > wrote: >> That flow looks correct to me. No I think that you should trigger >> manually a checkpoint after step 2 on the promoted standby

Re: [GENERAL] Retrieving query results

Hi, Michael, On Tue, Aug 22, 2017 at 8:32 PM, Michael Paquier wrote: > On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot wrote: >> [quote] >> PQntuples >> >> Returns the number of rows (tuples) in the query result. Because it >> returns an integer

Re: [GENERAL] Retrieving query results

On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot wrote: > [quote] > PQntuples > > Returns the number of rows (tuples) in the query result. Because it > returns an integer result, large result sets might overflow the return > value on 32-bit operating systems. > > int

Re: [GENERAL] install the oracle data wrapper extension

On Tue, Aug 22, 2017 at 2:47 PM, Peter Koukoulis wrote: > > Hi > > Is there a reliable way to create a database link from PosgreSQL 9.6 to > Oracle 11g? > I am running 9.6 on Linux 64 bit. > I can connect to the Oracle database with sqlplus from the PostgreSQL > server. > >

Re: [GENERAL] PG and database encryption

On Tue, Aug 22, 2017 at 3:13 PM, PT wrote: > On Tue, 22 Aug 2017 12:48:13 -0700 (MST) > rakeshkumar464 wrote: > >> We have a requirement to encrypt the entire database. What is the best tool >> to accomplish this. Our primary goal is that it

Re: [GENERAL] make postgresql 9.5 default on centos 7

On Tue, Aug 22, 2017 at 12:44 PM, Devrim Gündüz wrote: > > Hi, > > On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote: >> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default >> 9.2 version that comes with CentOS 7. >> >> Is there a simple way to fix

Re: [GENERAL] What is the proper query

Melvin et al, On Tue, Aug 22, 2017 at 12:55 PM, Melvin Davidson wrote: > > > > *While the information_schema is useful, there is no substitute for > learning how to use the pg_catalog and system information functions.* > > > *See if this query gives you what you are

[GENERAL] install the oracle data wrapper extension

Hi Is there a reliable way to create a database link from PosgreSQL 9.6 to Oracle 11g? I am running 9.6 on Linux 64 bit. I can connect to the Oracle database with sqlplus from the PostgreSQL server. Also, I have in attempted to install the oracle_fdw wrapper as an alternatve, but I keep getting

Re: [GENERAL] PG and database encryption

On Tue, 22 Aug 2017 12:48:13 -0700 (MST) rakeshkumar464 wrote: > We have a requirement to encrypt the entire database. What is the best tool > to accomplish this. Our primary goal is that it should be transparent to the > application, with no change in the

Re: [GENERAL] PG and database encryption

On Tue, Aug 22, 2017 at 3:27 PM, rakeshkumar464 wrote: > Thanks John and JD. > > John: Are you telling that the backup of a database has no protection? If you use LUKS to encrypt a filesystem and then copy any file data on that filesystem to another file on an

Re: [GENERAL] PG and database encryption

Thanks John and JD. John: Are you telling that the backup of a database has no protection? -- View this message in context: http://www.postgresql-archive.org/PG-and-database-encryption-tp5979618p5979624.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

Re: [GENERAL] PG and database encryption

On 08/22/2017 01:08 PM, John McKown wrote: On Tue, Aug 22, 2017 at 2:48 PM, rakeshkumar464 wrote: We have a requirement to encrypt the entire database. Personally, what I'd do (and actually do at work) is to us LUKS. I second that, although I'll add that if

Re: [GENERAL] PG and database encryption

On 08/22/2017 02:55 PM, Joshua D. Drake wrote: On 08/22/2017 12:48 PM, rakeshkumar464 wrote: We have a requirement to encrypt the entire database. What is the best tool to accomplish this. Our primary goal is that it should be transparent to the application, with no change in the application,

Re: [GENERAL] PG and database encryption

On Tue, Aug 22, 2017 at 2:48 PM, rakeshkumar464 wrote: > We have a requirement to encrypt the entire database. What is the best tool > to accomplish this. Our primary goal is that it should be transparent to the > application, with no change in the application, as

Re: [GENERAL] PG and database encryption

On 08/22/2017 12:48 PM, rakeshkumar464 wrote: We have a requirement to encrypt the entire database. What is the best tool to accomplish this. Our primary goal is that it should be transparent to the application, with no change in the application, as compared to un-encrypted database. Reading

[GENERAL] PG and database encryption

We have a requirement to encrypt the entire database. What is the best tool to accomplish this. Our primary goal is that it should be transparent to the application, with no change in the application, as compared to un-encrypted database. Reading about pgcrypto module, it seems it is good for few

Re: [GENERAL] make postgresql 9.5 default on centos 7

Hi, On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote: > I loaded 9.5 on CentOS 7 but by default every thing wants to use the default > 9.2 version that comes with CentOS 7. > > Is there a simple way to fix this so the 9.5 version of tools and libraries > are used. yum remove postgresql-*

[GENERAL] Retrieving query results

Hi, ALL, [quote] PQntuples Returns the number of rows (tuples) in the query result. Because it returns an integer result, large result sets might overflow the return value on 32-bit operating systems. int PQntuples(const PGresult *res); [/quote] Is there another way to not to overflow the

Re: [GENERAL] What is the proper query

Hi, Melvin, On Tue, Aug 22, 2017 at 12:55 PM, Melvin Davidson wrote: > > > > *While the information_schema is useful, there is no substitute for > learning how to use the pg_catalog and system information functions.* > > > *See if this query gives you what you are looking

Re: [GENERAL] What is the proper query

On Mon, Aug 21, 2017 at 9:08 PM, Igor Korot wrote: > Hi, ALL, > draft=# SELECT * FROM information_schema.key_column_usage > ​[...]​ > There are 3 foreign keys in that table. > > Is there a way to get values of 0, 1, 1, and 2 for the ordinal position? > Not using the

Re: [GENERAL] What is the proper query

*While the information_schema is useful, there is no substitute for learning how to use the pg_catalog and system information functions.* *See if this query gives you what you are looking for:* *SELECT rel.relname, con.conname, con.contype, con.consrc,

Re: [GENERAL] What is the proper query

Hi, David, On Tue, Aug 22, 2017 at 12:06 PM, David G. Johnston wrote: > On Tue, Aug 22, 2017 at 8:43 AM, Igor Korot wrote: >> >> Or this is the bug in 9.1? >> Since it looks like there are 2 columns with the same info in 1 >> table/view > > >

Re: [GENERAL] What is the proper query

On Tue, Aug 22, 2017 at 8:43 AM, Igor Korot wrote: > Or this is the bug in 9.1? > Since it looks like there are 2 columns with the same info in 1 > table/view > ​This old email thread sounds similar to what you are describing here.

Re: [GENERAL] Porting libpq to QNX 4.25

Thank you, Tom. We'll replace those QNX machines with WIndows XP ones (via dual boot), so we can use our Devart's ORM the same as the most "user oriented" applications. On 22/08/17 12:39, Tom Lane wrote: marcelo writes: Is there a libpq porting to QNX 4.25? I

Re: [GENERAL] What is the proper query

Or this is the bug in 9.1? Since it looks like there are 2 columns with the same info in 1 table/view Thank you. On Tue, Aug 22, 2017 at 12:08 AM, Igor Korot wrote: > Hi, ALL, > draft=# SELECT * FROM information_schema.key_column_usage WHERE > table_schema = 'public'

Re: [GENERAL] Porting libpq to QNX 4.25

marcelo writes: > Is there a libpq porting to QNX 4.25? I just tried to compile one of the > modules, but was rejected because the QNX's standard library have not an > Int64 type. We removed QNX support in 8.2, so you could try using some pre-8.2 release. It's

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

On Tue, Aug 22, 2017 at 3:06 AM, Michael Paquier wrote: > On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong > wrote: > > 1. Disable the master ltm member (all connections redired to slave > > member) > > 2. Promote slave (touch

Re: [GENERAL] Deadlocks

On Tue, Aug 22, 2017 at 9:42 AM, Martin Moore wrote: > Hi, I’m having issues with deadlocks. > > v9.6 on Debian Jessie. > > I have a number of ‘select’ functions which for logging purposes also call > another fn that inserts a record into a ‘logging’ table. > > However,

[GENERAL] Deadlocks

Hi, I’m having issues with deadlocks. v9.6 on Debian Jessie. I have a number of ‘select’ functions which for logging purposes also call another fn that inserts a record into a ‘logging’ table. However, even with only 1 or 2 users making very infrequent calls to the parent fn, deadlocks are

Re: [GENERAL] Porting libpq to QNX 4.25

I'm pretty sure that Watcom 9.6 libraries lacks long long or any such variants. And, of course, I don' t have another tool chain. Thank you On 21/08/17 22:20, George Neuner wrote: On Mon, 21 Aug 2017 13:27:56 -0300, marcelo wrote: Is there a libpq porting to QNX

Re: [GENERAL] [BUGS] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down

The client is a Hot Standby server. Regards, Abhijit On Tue, Aug 22, 2017 at 11:05 AM, Michael Paquier wrote: > On Tue, Aug 22, 2017 at 1:58 PM, Abhijit Gharami > wrote: > > Recently we have updated our PostgreSQL version from 9.4.12 to