Slowly Changing Dimension implementation

Hi all I am not aware of a database based solution for the implementation of SCDs (https://en.wikipedia.org/wiki/Slowly_changing_dimension) be it 0, 1 or 2 - I consider all other only as implementation specifications of type 2. However, I am considering to implement a trigger based soluti

Re: I do not get the point of the information_schema

You might find Aquameta's meta module helpful, it reimplements information_schema in a more normalized layout, as updatable views: http://blog.aquameta.com/2015/08/29/intro-meta/ https://github.com/aquametalabs/aquameta/tree/master/core/000-meta Best, Eric On Mon, Feb 12, 2018 at 2:02 PM Thiemo

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

Dear David, > > > Thanks for update. > I have also checked in postgres 9.3.21 and 9.5.x version. But this is same > as 9.3.6 postres version. > Some one please let me know below points. It will really helpful to > understand postgres behavior. > 1. When this folder pg_multixact/members folder size

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

Dear David, Thanks for update. I have also checked in postgres 9.3.21 and 9.5.x version. But this is same as 9.3.6 postres version. Regards, Yogesh On Wednesday, February 14, 2018, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Feb 14, 2018 at 9:06 AM, Yogesh Sharma > wrote

Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?

Thanks. Indeed pgBouncer is the usual candidate in front of postgres streaming replication, together with pgpool. Take care that your link on pgBouncer dates back from 2008 !.  I had a look at pgBouncer in the past, but it was not actively maintained at that time. So I settled on a combination o

Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?

On Wed, Feb 14, 2018 at 2:27 PM, Pierre Timmermans wrote: > pgpool does just that: it enables you to use the standby database as a > read only while other queries are sent to the primary database only ( > http://www.pgpool.net/). Good product and good support (on the list° > > This looks a very i

Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?

pgpool does just that: it enables you to use the standby database as a read only while other queries are sent to the primary database only (http://www.pgpool.net/). Good product and good support (on the list° This looks a very interesting possibility, although it is more related to automated fai

Re: Windows 10 Pro issue

On 02/14/2018 09:28 AM, Dale Seaburg wrote: CCing list so more eyes can see this Is the pg_hba.conf file actually there? Yes, the pg_hba.conf is in the "proper path" - C:\Program Files (x86)\PostgreSQL\8.4\data Footnote: at the user level or system level I do not see any environment variab

Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype

Yep!! Today I tested with triggers instead rules and the sequence goings well. Thanks for your help!! - Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

On Wed, Feb 14, 2018 at 9:06 AM, Yogesh Sharma wrote: > I am using postgres 9.3.6 version and i am using multiple INSERT/UPDATE > SQL commands with explicit share lock. > ​[...]​ > 4. I Want older postgres behavior in newer versions. So how to set this > behavior through postgres parameters? >

Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

Dear All, Thanks for your support and guidance. I am using postgres 9.3.6 version and i am using multiple INSERT/UPDATE SQL commands with explicit share lock. I know pg_multixact/members folder contains transactions of share lock. But these files are continuously increases. I have checked Postgre

Re: postgres connection with port option in shell script

On Wed, Feb 14, 2018 at 8:21 AM, Abhra Kar wrote: > Hi, > > I want to get postgres connection in script file. I am executing > below command and successfully getting connected --- > > > psql postgresql://$USER:$PASSWORD@$HOST/$DATABASE < > > If all you are going to do is substitute environm

Re: postgres connection with port option in shell script

Am 14.02.2018 um 16:21 schrieb Abhra Kar: Hi,       I want to get postgres connection in script file. I am executing below command and successfully getting connected --- psql postgresql://$USER:$PASSWORD@$HOST/$DATABASE

postgres connection with port option in shell script

Hi, I want to get postgres connection in script file. I am executing below command and successfully getting connected --- psql postgresql://$USER:$PASSWORD@$HOST/$DATABASE <

Re: Upgrading from Postgresql 9.1 to 10

On Wed, Feb 14, 2018 at 10:04 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > > > On Wednesday, February 14, 2018, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wednesday, February 14, 2018, pavan95 >> wrote: >> >>> Hi all, >>> >>> Is it possible to upgrade an exis

Re: Upgrading from Postgresql 9.1 to 10

Yeah David, Even I'm thinking the same Regards, Pavan On Feb 14, 2018 8:34 PM, "David G. Johnston" wrote: > > > On Wednesday, February 14, 2018, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wednesday, February 14, 2018, pavan95 >> wrote: >> >>> Hi all, >>> >>> Is it possib

Re: Upgrading from Postgresql 9.1 to 10

On Wednesday, February 14, 2018, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, February 14, 2018, pavan95 > wrote: > >> Hi all, >> >> Is it possible to upgrade an existing postgresql 9.1 production system to >> latest Postgres 10.0 version? >> >> The main requirement is t

Re: Upgrading from Postgresql 9.1 to 10

Thank you for your timely response 😊 On Feb 14, 2018 8:18 PM, "Melvin Davidson" wrote: > > > On Wed, Feb 14, 2018 at 9:42 AM, pavan95 > wrote: > >> Hi all, >> >> Is it possible to upgrade an existing postgresql 9.1 production system to >> latest Postgres 10.0 version? >> >> The main requirement

Re: Upgrading from Postgresql 9.1 to 10

On Wed, Feb 14, 2018 at 9:42 AM, pavan95 wrote: > Hi all, > > Is it possible to upgrade an existing postgresql 9.1 production system to > latest Postgres 10.0 version? > > The main requirement is to get rid of downtime. Please help me out! > > Thanks in Advance. > > Regards, > Pavan > > > > -- >

Re: Upgrading from Postgresql 9.1 to 10

On Wednesday, February 14, 2018, pavan95 wrote: > Hi all, > > Is it possible to upgrade an existing postgresql 9.1 production system to > latest Postgres 10.0 version? > > The main requirement is to get rid of downtime. Please help me out! > Zero downtime is only possible by standing up a hot-st

Upgrading from Postgresql 9.1 to 10

Hi all, Is it possible to upgrade an existing postgresql 9.1 production system to latest Postgres 10.0 version? The main requirement is to get rid of downtime. Please help me out! Thanks in Advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.ht

Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?

Hi, I am also trying to split read and write queries, where reads should go to the slave server (streaming replication) and writes to the master server. Any tool available to perform this activity instead of two connection pool? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general

RE: Barman 2.3 errors

Hi, Just to say that i cannot using replication streaming but ssh shipping wal works … I’m trying barman product like that. Thanks nico De : GALLIANO Nicolas Envoyé : mardi 13 février 2018 10:15 À : Ahmed, Nawaz ; pgsql-gene...@postgresql.org Objet : RE: Barman 2.3 errors Hi 1/ thanks for your

Re: execute block like Firebird does

Em 11/02/2018 03:57, PegoraroF10 escreveu: We are migrating our databases from Firebird to PostGres. A useful feature Firebird has is Execute Block. What it does is just return a record set from that dynamic SQL, just like a PostGres function, but without creating it. It sound like ... execute bl

Using standby for read-only queries in production and DML operations on primary.

Hello! There is a problem connected with using standby for read-only queries in production and DML operations on primary. On primary we use alter table command with statement_timeout and deadlock_timeout values about 10 - 50 ms with rertry until it would successfully be executed. But the same lock

Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype

> On 14 Feb 2018, at 2:48, DrakoRod wrote: > CREATE OR REPLACE RULE inserts_customer_part1 > AS ON INSERT TO customers > WHERE new.id < 1 > DO INSTEAD INSERT INTO customers_part1 SELECT NEW.*; > > CREATE OR REPLACE RULE inserts_customer_part2 > AS ON INSERT TO customers > WHERE new.id >= 1