Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

On 11/09/2017 05:52 PM, chiru r wrote: > If OpenSSL apply any patches at OS level, Is there any > changes/maintenance we need to perform at PostgreSQL end? > > On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote: >> Assuming you mean that you need only FIPS 140-2 compliant ciphers, you >> would want

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

Thanks. If OpenSSL apply any patches at OS level, Is there any changes/maintenance we need to perform at PostgreSQL end? On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote: > On 11/09/2017 01:59 PM, chiru r wrote: > > I am using PostgreSQL version *9.5.7* on Red hat

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

On 11/09/2017 01:59 PM, chiru r wrote: > I am using PostgreSQL version *9.5.7* on Red hat enterprise Linux *7.2.* > > *OpenSSL version : * OpenSSL 1.0.1e-fips 11 Feb 2013. > > I have a requirement to enable the SSL in my environment with specific > cipher suites,we want to restrict weak cipher

Re: [GENERAL] [HACKERS] SSL and Encryption

On Fri, Nov 3, 2017 at 4:12 PM, Jeff Janes wrote: > On Thu, Nov 2, 2017 at 10:22 PM, John R Pierce wrote: >> >> On 11/2/2017 10:12 PM, Jeff Janes wrote: >>> >>> https://wiki.postgresql.org/wiki/List_of_drivers >>> >>> What is 'python native'? psycopg

Re: [GENERAL] [HACKERS] SSL and Encryption

On Thu, Nov 2, 2017 at 10:22 PM, John R Pierce wrote: > On 11/2/2017 10:12 PM, Jeff Janes wrote: > >> https://wiki.postgresql.org/wiki/List_of_drivers >> >> What is 'python native'? psycopg works as long you update your libpq. >> > > > I thought pythonistas preferred using

Re: [GENERAL] [HACKERS] SSL and Encryption

On Fri, Nov 3, 2017 at 5:22 AM, John R Pierce wrote: > On 11/2/2017 10:12 PM, Jeff Janes wrote: >> >> https://wiki.postgresql.org/wiki/List_of_drivers >> >> What is 'python native'? psycopg works as long you update your libpq. > > I thought pythonistas preferred using a

Re: [GENERAL] [HACKERS] SSL and Encryption

On 11/2/2017 10:12 PM, Jeff Janes wrote: https://wiki.postgresql.org/wiki/List_of_drivers What is 'python native'?  psycopg works as long you update your libpq. I thought pythonistas preferred using a native driver that didn't use libpq ? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] [HACKERS] SSL and Encryption

On Thu, Nov 2, 2017 at 9:58 PM, John R Pierce wrote: > On 11/2/2017 9:39 PM, Michael Paquier wrote: > > The SCRAM discussion is spread across two threads mainly with hundreds > of emails, which may discourage even the bravest. Here are links to > the important >

Re: [GENERAL] [HACKERS] SSL and Encryption

On 11/2/2017 9:39 PM, Michael Paquier wrote: The SCRAM discussion is spread across two threads mainly with hundreds of emails, which may discourage even the bravest. Here are links to the important documentation: https://www.postgresql.org/docs/current/static/auth-methods.html#auth-password so

Re: [GENERAL] [HACKERS] SSL and Encryption

On Fri, Nov 3, 2017 at 3:19 AM, Craig Ringer wrote: > This is probably off topic for pgsql-hackers. > > For password crypto please go read the SCRAM thread and the PostgreSQL > 10 release notes. The SCRAM discussion is spread across two threads mainly with hundreds of

Re: [GENERAL] [HACKERS] SSL and Encryption

On 3 November 2017 at 11:16, chiru r wrote: > Hi , > > Please suggest the best chiper suite to configure openSSL for PostgreSQL > Server and client?. > > How to use other than md5 encryption algorithm to encrypt the passwords in > PostgreSQL? This is probably off topic for

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

Greetings John, * John R Pierce (pie...@hogranch.com) wrote: > On 9/20/2017 6:55 AM, Stephen Frost wrote: > >If AD is in the mix here, then there's no need to have things happening > >at the database level when it comes to passwords- configure PG to use > >Kerberos and create a princ in AD and

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On 9/20/2017 6:55 AM, Stephen Frost wrote: If AD is in the mix here, then there's no need to have things happening at the database level when it comes to passwords- configure PG to use Kerberos and create a princ in AD and put that on the database server and then users can authenticate that way.

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

John, * John R Pierce (pie...@hogranch.com) wrote: > On 9/19/2017 3:32 PM, chiru r wrote: > >How those application accounts get recognized in database? > > > >Let say  App_user1 authenticated through application ,after that > >how the App_user1 get access to DB? > > > >can you please provide more

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

Bruce, * Bruce Momjian (br...@momjian.us) wrote: > On Tue, Sep 19, 2017 at 01:28:11PM -0400, Stephen Frost wrote: > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > > chiru r writes: > > > > We are looking for User profiles in ope source PostgreSQL. > > > > For example, If a

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On 19/09/2017 20:09, Tom Lane wrote: chiru r writes: We are looking for User profiles in ope source PostgreSQL. For example, If a user password failed n+ times while login ,the user access has to be blocked few seconds. Please let us know, is there any plan to implement

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On 9/19/2017 3:32 PM, chiru r wrote: How those application accounts get recognized in database? Let say  App_user1 authenticated through application ,after that how the App_user1 get access to DB? can you please provide more information ,how the app users are accessing database ? the

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

Hi John, How those application accounts get recognized in database? Let say App_user1 authenticated through application ,after that how the App_user1 get access to DB? can you please provide more information ,how the app users are accessing database ? Thanks, Chiranjeevi On Tue, Sep 19,

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On 9/19/2017 12:33 PM, chiru r wrote: Yes, LDAP will do. However we need to sync the user accounts and  groups between AD and PG servers.and then AD profiles will apply to PG user accounts for authentication. if you're using LDAP from the AD servers to authenticate, whats to sync? my

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

Yes, LDAP will do. However we need to sync the user accounts and groups between AD and PG servers.and then AD profiles will apply to PG user accounts for authentication. It is good if we have user profiles in core PostgreSQL database system. So it will add more security. Thanks, Chiranjeevi On

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On Tue, Sep 19, 2017 at 01:28:11PM -0400, Stephen Frost wrote: > Tom, > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > chiru r writes: > > > We are looking for User profiles in ope source PostgreSQL. > > > For example, If a user password failed n+ times while login ,the user >

Re: [GENERAL] [HACKERS] pgjdbc logical replication client throwing exception

Hi Andres, I also checked server log. Nothing unusual is recorded there. Do you have any other suggestion. Thank you. Best regards, Dipesh Dangol On Fri, Sep 15, 2017 at 11:32 PM, Dipesh Dangol wrote: > Hi Vladimir, > Ya, initially I was trying with

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On Tue, Sep 19, 2017 at 1:28 PM, Stephen Frost wrote: > Tom, > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > chiru r writes: > > > We are looking for User profiles in ope source PostgreSQL. > > > For example, If a user password failed n+ times while login

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

Tom, * Tom Lane (t...@sss.pgh.pa.us) wrote: > chiru r writes: > > We are looking for User profiles in ope source PostgreSQL. > > For example, If a user password failed n+ times while login ,the user > > access has to be blocked few seconds. > > Please let us know, is there

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

chiru r writes: > We are looking for User profiles in ope source PostgreSQL. > For example, If a user password failed n+ times while login ,the user > access has to be blocked few seconds. > Please let us know, is there any plan to implement user profiles in feature >

Re: [GENERAL] [HACKERS] pgjdbc logical replication client throwing exception

Hi Vladimir, Ya, initially I was trying with withStatusInterval(20, TimeUnit.SECONDS), that didn't work so, then only I switched to .withStatusInterval(20, TimeUnit.MILLISECONDS) but it is not working as well. I am not aware of type of test cases that you are pointing. Could you please send me

Re: [GENERAL] [HACKERS] pgjdbc logical replication client throwing exception

On 2017-09-15 20:00:34 +, Vladimir Sitnikov wrote: > ++pgjdbc dev list. > > >I am facing unusual connection breakdown problem. Here is the simple code > that I am using to read WAL file: > > Does it always fails? > Can you create a test case? For instance, if you file a pull request with >

Re: [GENERAL] [HACKERS] pgjdbc logical replication client throwing exception

++pgjdbc dev list. >I am facing unusual connection breakdown problem. Here is the simple code that I am using to read WAL file: Does it always fails? Can you create a test case? For instance, if you file a pull request with the test, it will get automatically tested across various PG versions,

Re: [GENERAL] [HACKERS] SAP Application deployment on PostgreSQL

On 8 September 2017 at 15:34, chiru r wrote: > We have multiple SAP applications running on Oracle as backend and looking > for an opportunity to migrate from Oracle to PostgreSQL. Has anyone ever > deployed SAP on PostgreSQL community edition? > > Is PostgreSQL community

Re: [GENERAL] [HACKERS] How to change order sort of table in HashJoin

Thanks for reply, sir. On 11/21/2016 1:39 AM, Tom Lane wrote: Man writes: Additional information. In 9.6 the second table (lesser tuple) was choosen (the same testdata). There are something (cost estimation?) different in previous versions. I'd bet on different

Re: [GENERAL] [HACKERS] How to change order sort of table in HashJoin

Man writes: > Additional information. > In 9.6 the second table (lesser tuple) was choosen (the same testdata). > There are something (cost estimation?) different in previous versions. I'd bet on different statistics in the two installations (either you forgot to ANALYZE,

Re: [GENERAL] [HACKERS] How to change order sort of table in HashJoin

Thanks for response, sir. On 11/20/2016 1:18 AM, Tom Lane wrote: Man Trieu writes: As in the example below, i think the plan which hash table is created on testtbl2 (the fewer tuples) should be choosen. The planner usually prefers to hash on the table that has a flatter

Re: [GENERAL] [HACKERS] How to change order sort of table in HashJoin

Man Trieu writes: > As in the example below, i think the plan which hash table is created on > testtbl2 (the fewer tuples) should be choosen. The planner usually prefers to hash on the table that has a flatter MCV histogram, since a hash table with many key collisions will

Re: [GENERAL] [HACKERS] temporary table vs array performance

On Mon, Sep 26, 2016 at 9:18 AM, 邓彪 wrote: > we have to do dml in temp table,the CTE is not fit > > ​Moving this to -general only...​ ​Please direct all replies to the list. You are asking for help but not providing any context for what your requirements are. You are not

Re: [GENERAL] [HACKERS] temporary table vs array performance

2016-09-26 17:39 GMT+02:00 dby...@163.com : > test: > create type h3 as (id int,name char(10)); > > CREATE or replace FUNCTION proc17() > RETURNS SETOF h3 AS $$ > DECLARE > v_rec h3; > BEGIN > create temp table abc(id int,name varchar) on commit drop; > insert into abc

Re: [GENERAL] [HACKERS] temporary table vs array performance

Its considered bad form to post to multiple lists. Please pick the most relevant one - in this case I'd suggest -general. On Mon, Sep 26, 2016 at 8:39 AM, dby...@163.com wrote: > > Array is not convenient to use in function, whether > there are other methods can be replaced

Re: [GENERAL] [HACKERS] pg_dumping extensions having sequences with 9.6beta3

On Wed, Jul 27, 2016 at 2:24 AM, Michael Paquier wrote: > On Wed, Jul 27, 2016 at 8:07 AM, Stephen Frost wrote: >> That'd be great. It's definitely on my list of things to look into, but >> I'm extremely busy this week. I hope to look into it on

Re: [GENERAL] [HACKERS] Online DW

On Sat, 11 Jun 2016 09:59:59 +0530 Sridhar N Bamandlapally wrote: > Ok, let me put this way, > > I need every transaction coming from application sync with both > production and archive db, > but the transactions I do to clean old data(before 7 days) on > production db in

Re: [GENERAL] [HACKERS] Online DW

On 11 June 2016 at 12:29, Sridhar N Bamandlapally wrote: > Ok, let me put this way, > > I need every transaction coming from application sync with both production > and archive db, > but the transactions I do to clean old data(before 7 days) on production > db in daily

Re: [GENERAL] [HACKERS] Online DW

On Sat, 11 Jun 2016 09:59:59 +0530 Sridhar N Bamandlapally wrote: > Ok, let me put this way, > > I need every transaction coming from application sync with both > production and archive db, > but the transactions I do to clean old data(before 7 days) on > production db in

Re: [GENERAL] [HACKERS] Online DW

Ok, let me put this way, I need every transaction coming from application sync with both production and archive db, but the transactions I do to clean old data(before 7 days) on production db in daily maintenance window should not sync with archive db, Archive db need read-only, used for

Re: [GENERAL] [HACKERS] Online DW

> On Jun 10, 2016, at 9:27 AM, Sridhar N Bamandlapally > wrote: > > This is what I feel will give me solution to maintain production > (current+7days) and archive(current+history) without any etl/scheduler > > But there is no feature available in any database > >

Re: [GENERAL] [HACKERS] Online DW

On Fri, Jun 10, 2016 at 4:11 AM, Sridhar N Bamandlapally < sridhar@gmail.com> wrote: > Hi > > Is there any feature in PostgreSQL where online DW (Dataware housing) is > possible ? > > am looking for scenario like > > 1. Production DB will have CURRENT + LAST 7 DAYS data only > > 2. Archive/DW

Re: [GENERAL] [HACKERS] Online DW

On Fri, Jun 10, 2016 at 12:49 PM, Francisco Olarte wrote: > I may be wrong but ... > > On Fri, Jun 10, 2016 at 6:33 PM, Sridhar N Bamandlapally > wrote: > > One thing we can restrict to "begin noarchive" transaction block are > DELETE > > and

Re: [GENERAL] [HACKERS] Online DW

I may be wrong but ... On Fri, Jun 10, 2016 at 6:33 PM, Sridhar N Bamandlapally wrote: > One thing we can restrict to "begin noarchive" transaction block are DELETE > and SELECT only > On 10 Jun 2016 21:57, "Sridhar N Bamandlapally" > wrote: >> This

Re: [GENERAL] [HACKERS] Online DW

One thing we can restrict to "begin noarchive" transaction block are DELETE and SELECT only Sridhar Opentext On 10 Jun 2016 21:57, "Sridhar N Bamandlapally" wrote: > This is what I feel will give me solution to maintain production > (current+7days) and

Re: [GENERAL] [HACKERS] Online DW

This is what I feel will give me solution to maintain production (current+7days) and archive(current+history) without any etl/scheduler But there is no feature available in any database Sridhar Opentext On 10 Jun 2016 19:03, "Craig Ringer" wrote: > On 10 June 2016 at

Re: [GENERAL] [HACKERS] Online DW

On 10 June 2016 at 18:56, John R Pierce wrote: > On 6/10/2016 2:18 AM, Sridhar N Bamandlapally wrote: > >> This/These will be performed in Production to clean-up archive which will >> not be sync with Archive/DW DB only >> >> one heads-up is Archive/DW DB may need to build

Re: [GENERAL] [HACKERS] Online DW

On 6/10/2016 2:18 AM, Sridhar N Bamandlapally wrote: This/These will be performed in Production to clean-up archive which will not be sync with Archive/DW DB only one heads-up is Archive/DW DB may need to build WITHOUT CONSTRAINTS May need to introduce ARCHIVE system/tag in pg_hba.conf

Re: [GENERAL] [HACKERS] Online DW

One thing looks possible ( feature not available), just an idea example/syntax: BEGIN NOARCHIVE; --- transaction-1 --- transaction-2 . . --- transaction-N END; This/These will be performed in Production to clean-up archive which will not be sync with Archive/DW DB only one heads-up

Re: [GENERAL] [HACKERS] Online DW

On 10 June 2016 at 16:11, Sridhar N Bamandlapally wrote: > Hi > > Is there any feature in PostgreSQL where online DW (Dataware housing) is > possible ? > > am looking for scenario like > > 1. Production DB will have CURRENT + LAST 7 DAYS data only > > 2. Archive/DW DB will

Re: [GENERAL] [HACKERS] OUT parameter and RETURN table/setof

Existing application code written to call function in Oracle which return no.of rows in out parameter and return-values is cursor-result this need migrate to PostgreSQL, need help here example: (actual function declaration only) *Oracle:* CREATE OR REPLACE PROCEDURE sc_getapppermissionlist (

Re: [GENERAL] [HACKERS] OUT parameter and RETURN table/setof

On Mon, Jun 6, 2016 at 7:17 AM, Sridhar N Bamandlapally < sridhar@gmail.com> wrote: > Hi > > Is there any option in PGPLSQL which can RETURNS table or SETOF rows along > with an OUT parameter? > > ​No, there would be no point given the internals of how functions work. ​What is it you are

Re: [GENERAL] [HACKERS] Change in order of criteria - reg

On Wed, Jun 1, 2016 at 12:07 AM, sri harsha wrote: > > Hi, > > In PostgreSQL , does the order in which the criteria is given matter > ?? For example > > Query 1 : Select * from TABLE where a > 5 and b < 10; > > Query 2 : Select * from TABLE where b <10 and a > 5; > >

Re: [GENERAL] [HACKERS] Change in order of criteria - reg

On Wed, Jun 1, 2016 at 5:22 AM, Amit Langote wrote: > On 2016/06/01 13:07, sri harsha wrote: >> Hi, >> >> In PostgreSQL , does the order in which the criteria is given matter ?? >> For example >> >> Query 1 : Select * from TABLE where a > 5 and b < 10; >> >>

Re: [GENERAL] [HACKERS] Change in order of criteria - reg

On 2016/06/01 13:07, sri harsha wrote: > Hi, > > In PostgreSQL , does the order in which the criteria is given matter ?? > For example > > Query 1 : Select * from TABLE where a > 5 and b < 10; > > Query 2 : Select * from TABLE where b <10 and a > 5; > > Are query 1 and query 2 the same in

Re: [GENERAL] [HACKERS] NULL concatenation

Thanks Pavel Great !! I was thinking both || and CANCAT does same Thanks again - Sridhar OpenText On Thu, May 12, 2016 at 2:22 PM, Pavel Stehule wrote: > Hi > > 2016-05-12 10:47 GMT+02:00 Sridhar N Bamandlapally > : > >> Hi >> >> In

Re: [GENERAL] [HACKERS] NULL concatenation

Hi 2016-05-12 10:47 GMT+02:00 Sridhar N Bamandlapally : > Hi > > In migration, am facing issue with NULL concatenation in plpgsql, > by concatenating NULL between any where/position to Text / Varchar, the > total string result is setting value to NULL > > > *In Oracle:* >

Re: [GENERAL] [HACKERS] sign function with INTERVAL?

On Wed, Apr 13, 2016 at 3:48 PM, Daniel Lenski wrote: > On Wed, Apr 13, 2016 at 12:35 PM, Tom Lane wrote: > > Jim Nasby writes: > >> Actually, after looking at the code for interval_lt, all that needs to > >> happen to add this

Re: [GENERAL] [HACKERS] sign function with INTERVAL?

On Wed, Apr 13, 2016 at 12:35 PM, Tom Lane wrote: > Jim Nasby writes: >> Actually, after looking at the code for interval_lt, all that needs to >> happen to add this support is to expose interval_cmp_internal() as a >> strict function. It already

Re: [GENERAL] [HACKERS] sign function with INTERVAL?

Jim Nasby writes: > Actually, after looking at the code for interval_lt, all that needs to > happen to add this support is to expose interval_cmp_internal() as a > strict function. It already does exactly what you want. interval_cmp() is already SQL-accessible.

Re: [GENERAL] [HACKERS] sign function with INTERVAL?

On 4/13/16 1:36 PM, Daniel Lenski wrote: Hi all, Is there a good reason why the SIGN() function does not work with the INTERVAL type? (It is only defined for numeric types.) (http://www.postgresql.org/docs/9.5/static/functions-math.html) The only thing that comes to mind is you can get some

Re: [GENERAL] [HACKERS] Nested funtion

On Sun, Mar 27, 2016 at 9:14 PM, Sridhar N Bamandlapally < sridhar@gmail.com> wrote: > Hi > > Is there any way to create nested function? > > oracle to postgres migration required super function variable reference > into nested function without nested function parameter > > Oracle sample: >

Re: [GENERAL] [HACKERS] Nested funtion

Hi 2016-03-28 6:14 GMT+02:00 Sridhar N Bamandlapally : > Hi > > Is there any way to create nested function? > Some languages supports this feature, like plv8, but plpgsql doesn't support it, You have to use two function and some implementation of session variables.

Re: [GENERAL] [HACKERS] Request - repeat value of \pset title during \watch interations

Alvaro Herrera writes: > (I'll also use this opportunity to complain again about not being able > to use floating point sleep time.) That's not unreasonable either, though it seems like material for a separate patch. regards, tom lane -- Sent

Re: [GENERAL] [HACKERS] Request - repeat value of \pset title during \watch interations

"David G. Johnston" writes: > I'll admit it's awkward because it's abbreviated but if someone enters > \watch 5 and then sees (5s) in the title I think they can put two and two > together. Where I find this to be awkward is that the format is randomly different

Re: [GENERAL] [HACKERS] Threads in PostgreSQL

On Mon, Dec 21, 2015 at 11:51 AM, sri harsha wrote: > Hi, > >Is it possible to use threads in Postgresql ?? I am using threads in my > foreign data wrapper and i get the following error when i use the threads . > > *ERROR: stack depth limit exceeded* > *HINT:

Re: [GENERAL] [HACKERS] Threads in PostgreSQL

Hi, PostgreSQL is not using threads but it is possible to spawn thread in your PostgreSQL extensions. For example, I have used pool of threads in my IMCS extension. But you need to build your extension with -pthread: CUSTOM_COPT = -pthread Also, please take in account that many PostgreSQL

Re: [GENERAL] [HACKERS] optimization join on random value

On Mon, May 04, 2015 at 12:15:54AM +0300, Anton wrote: Hello guru of postgres, it's possoble to tune query with join on random string ? i know that it is not real life example, but i need it for tests. soe=# explain soe-# SELECT ADDRESS_ID, soe-# CUSTOMER_ID, soe-#

Re: [GENERAL] [HACKERS] optimization join on random value

Yahooo ! Many thanks ! soe=# explain EXECUTE test( random()*45000 ); QUERY PLAN - Index Scan using addresses_cust_ix on addresses (cost=0.43..16.48 rows=3 width=84)

Re: [GENERAL] [HACKERS] optimization join on random value

On 5/3/15 4:15 PM, Anton wrote: Hello guru of postgres, it's possoble to tune query with join on random string ? i know that it is not real life example, but i need it for tests. Moving to -general, which is the proper list for this. (BCC -hackers) soe-# WHERE customer_id = trunc(

Re: [GENERAL] [HACKERS] BDR Multiple database

Thank you so much for clarification about list room for discussion and suggestion Now I can do BDR multiple database with this configuration bdr.connections = 'bdrnode02db1, bdrnode02db2' bdr.bdrnode02db1 = 'dbname=db1 host=172.17.42.1 port=49319 user=postgres' bdr.bdrnode02db2 = 'dbname=db2

Re: [GENERAL] [HACKERS] Composite index and min()

On Thu, Feb 26, 2015 at 2:30 AM, Jim Nasby jim.na...@bluetreble.com wrote: On 2/26/15 1:34 AM, James Sewell wrote: Hello, The correct place for this is pgsql-general@. -hackers is for development of Postgres itself. I'm moving the discussion there. I have the following table: \d

Re: [GENERAL] [HACKERS] BDR Multiple database

Hi, Please note that hackers is not the right list for this; it's for development discussions. Please ask such questions on -general. On 2015-02-26 17:46:55 +0700, Jirayut Nimsaeng wrote: We want to use BDR with multiple database but now all the document didn't show any example how to config

Re: [GENERAL] [HACKERS] Composite index and min()

On 2/26/15 1:34 AM, James Sewell wrote: Hello, The correct place for this is pgsql-general@. -hackers is for development of Postgres itself. I'm moving the discussion there. I have the following table: \d a Table phxconfig.a Column | Type | Modifiers

Re: [GENERAL] [HACKERS] question on Postgres smart shutdown mode

On 2/12/15 5:46 PM, Bo Tian wrote: I have a question on PG smart shutdown mode. When shutdown Postgres by issuing /Smart Shutdown /mode (SIGTERM) request, is there a way for client to be notified of this shutdown event? I tried PG_NOTIFY, but I cannot get any notification events when this

Re: [GENERAL] [HACKERS] COPY TO returning empty result with parallel ALTER TABLE

Bernd Helmle maili...@oopsware.de writes: --On 3. November 2014 18:15:04 +0100 Sven Wegener sven.wege...@stealer.net wrote: I've check git master and 9.x and all show the same behaviour. I came up with the patch below, which is against curent git master. The patch modifies the COPY TO code

Re: [GENERAL] [HACKERS] Need guidance to startup

On Tue, Sep 16, 2014 at 11:16 AM, Tapan Halani tapanhalani...@gmail.com wrote: Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project or direct me in the right direction. Welcome! That's a

Re: [GENERAL] [HACKERS] using rpmbuild with PostgreSQL 9.2.6 source code

you need installed devel packages I tried to install these packages (uuid-devel and systemd-unit) but yum can not locate these packages. I tried to install selinux-policy but I found out that selinux-policy 3.7.19 is already installed and is the latest package available in Red Hat repository

Re: [GENERAL] [HACKERS] using rpmbuild with PostgreSQL 9.2.6 source code

Hi, On Mon, 2014-01-20 at 15:46 +0800, Sameer Kumar wrote: I have downloaded the tar source code of PostgreSQL and also the SPEC file. I am trying to use rpmbuild command but I always get below error: error: Failed build dependencies: uuid-devel is needed by

Re: [GENERAL] [HACKERS] using rpmbuild with PostgreSQL 9.2.6 source code

Hello you need installed devel packages Regards Pavel Stehule 2014/1/20 Sameer Kumar sameer.ku...@ashnik.com Hi, I have downloaded the tar source code of PostgreSQL and also the SPEC file. I am trying to use rpmbuild command but I always get below error: error: Failed build

[GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

Hi, I am trying to do a custom build (and generate binary and source RPM) package for PostgreSQL. I know community already has a RPM package, but I am trying to do a custom build. I am using attached SPEC file. But I am not able to get binary rpm. rpmbuild always gives me source rpm only. Is

Re: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

Sameer Kumar wrote: I am trying to do a custom build (and generate binary and source RPM) package for PostgreSQL. I know community already has a RPM package, but I am trying to do a custom build. I am using attached SPEC file. But I am not able to get binary rpm. rpmbuild always gives

Re: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

Hi, On Fri, 2013-12-06 at 10:30 +, Albe Laurenz wrote: Start looking here: http://yum.postgresql.org/srpms/9.3/redhat/rhel-6-x86_64/repoview/postgresql93.html The source RPMs contain the spec file. Also, http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/ is the SVN repo for 9.3

Re: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

That On Fri, Dec 6, 2013 at 7:08 PM, Sameer Kumar sameer.ku...@ashnik.comwrote: Hi, I am trying to do a custom build (and generate binary and source RPM) package for PostgreSQL. I know community already has a RPM package, but I am trying to do a custom build. I am using attached SPEC

Re: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

On Fri, Dec 6, 2013 at 6:30 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: Sameer Kumar wrote: I am trying to do a custom build (and generate binary and source RPM) package for PostgreSQL. I know community already has a RPM package, but I am trying to do a custom build. I am using

Re: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

Thanks everyone for helping. If I were you, I'd simply take the community spec and modify it for my needs, it is already really complete and contains automatic management of for example translation files, smth that is always a pain to maintain manually. I agree and that is why I asked for it

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

On Thu, Mar 21, 2013 at 01:42:55PM +0800, Craig Ringer wrote: On 03/19/2013 09:46 PM, Stephen Frost wrote: * Craig Ringer (cr...@2ndquadrant.com) wrote: As far as I'm concerned that's the immediate problem fixed. It may be worth adding a warning on startup if we find non-self-signed certs

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

(2013/10/02 18:57), Michael Paquier wrote: kondo.mitsum...@lab.ntt.co.jp wrote: Who is pgFoundery administrator or board member now? I would like to send e-mail them. At least, it does not have information and support page in pgFoundery homepage. Why don't you consider github as a potential

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

On Mon, Oct 21, 2013 at 5:27 AM, KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp wrote: (2013/10/02 18:57), Michael Paquier wrote: kondo.mitsum...@lab.ntt.co.jp wrote: Who is pgFoundery administrator or board member now? I would like to send e-mail them. At least, it does not have information

Re: [GENERAL] [HACKERS] Urgent Help Required

On 10/8/13 5:55 AM, shailesh singh wrote: HINT: To avoid a database shutdown, execute a full-database VACUUM in debug. ERROR: could not access status of transaction 449971277 DETAIL: could not open file pg_clog/01AD: No such file or directory Unless I'm mistaken, that missing CLOG file is

Re: [GENERAL] [HACKERS] Urgent Help Required

*Don't* VACUUM FULL. Just VACUUM. It's not the same thing. ...Robert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

Hi, I want to submit new project in pgFoundery project. I submitted new project which is WAL archive copy tool with directIO method in pgFoundery homepage 2 weeks ago, but it does not have approved and responded at all:-( Who is pgFoundery administrator or board member now? I would

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

On Wed, Oct 2, 2013 at 5:37 PM, KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp wrote: Who is pgFoundery administrator or board member now? I would like to send e-mail them. At least, it does not have information and support page in pgFoundery homepage. Why don't you consider github as a

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

On Wed, Oct 2, 2013 at 3:37 AM, KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp wrote: Hi, I want to submit new project in pgFoundery project. I submitted new project which is WAL archive copy tool with directIO method in pgFoundery homepage 2 weeks ago, but it does not have approved and

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

direct_cp project approved, sorry for delay … as to the the mailing list issue, where did you send it? can you resend it to me here? On 2013-10-02, at 6:46 , Merlin Moncure mmonc...@gmail.com wrote: On Wed, Oct 2, 2013 at 3:37 AM, KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp wrote: Hi,

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

Merlin == Merlin Moncure mmonc...@gmail.com writes: Who is pgFoundery administrator or board member now? I would like to send e-mail them. At least, it does not have information and support page in pgFoundery homepage. Merlin I have not been able to get in contact with Marc either to

Re: [GENERAL] [HACKERS] Who is pgFoundery administrator?

(2013/10/02 17:37), KONDO Mitsumasa wrote: I want to submit new project in pgFoundery project. Our new project was approved yesterday! Thanks very much for pgFoundery crew. Regards, -- Mitsumasa KONDO NTT Open Source Software Center -- Sent via pgsql-general mailing list

[GENERAL] [HACKERS] How to configer the pg_hba record which the database name with \n ?

Hi all, I've come across an issue within pg_hba configuration which it seems cannot not set the record of a database name where there is a newline(\n) in the name. I created the database whihin psql like this: create database ab cd; I have tried all the following records, but seems not to work:

Re: [GENERAL] [HACKERS] maintenance_work_mem and CREATE INDEX time

On Tue, Jul 23, 2013 at 10:56 PM, Amit Langote amitlangot...@gmail.com wrote: On Wed, Jul 24, 2013 at 3:20 AM, Jeff Janes jeff.ja...@gmail.com wrote: The heap structure used in external sorts is cache-unfriendly. The bigger the heap used, the more this unfriendliness becomes apparent. And

  1   2   3   4   5   6   >