Re: [GENERAL] Question about jsonb and data structures

On 21/06/2017 01:01, Emilie Laffray wrote: Hello, I have been playing with Postgresql recently with a large table and I have started looking at reducing the number of rows in that table. One idea to reduce the actual size, I thought I would "compress" the data structure into a JSON object

Re: [GENERAL] Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)

Thanks for the answer, that already helped me enough. Best, Sari On 06/16/2017 09:45 AM, Christofer C. Bell wrote: > On Fri, Jun 16, 2017 at 1:03 AM, Sari Thiele > wrote: > > Hi, > > it would be really great, if someone can

[GENERAL] Invalidation of cached plans for stored procedures ?

Hi On our production database, we had a small hiccup when playing a SQL migration. We write them to be as smooth as possible, trying not to interfere with running services, but this time, we got a batch of failures. I diagnosed the situation, and found out that we were hit by a known "feature"

Re: [GENERAL] Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)

Hi, On Tue, 2017-06-13 at 10:32 +0200, Sari Thiele wrote: > it looks like that the folder 'rhel-6Workstation-x86_64' does not exist > any more for 9.6 (redhat). > > Is this intentional or has this folder just been forgotten? > > Is it possible that someone can create this? Done. They will

Re: [GENERAL] Invalidation of cached plans for stored procedures ?

On 06/21/2017 04:28 AM, Pierre Ducroquet wrote: > Hi > > On our production database, we had a small hiccup when playing a SQL > migration. > We write them to be as smooth as possible, trying not to interfere with > running services, but this time, we got a batch of failures. > I diagnosed the

[GENERAL] PostgreSQL Source Control Integration

Hi, I work on PostgreSQL 9.6 and I'm looking for a source code control tool. Is there anyone who give a suggest about that? Best Regards, -- Gunce Kaya Linkedin - Twitter - Blog

Re: [GENERAL] PostgreSQL Source Control Integration

On 06/21/2017 05:08 AM, Günce Kaya wrote: Hi, I work on PostgreSQL 9.6 and I'm looking for a source code control tool. Is there anyone who give a suggest about that? http://sqitch.org/ Best Regards, -- Gunce Kaya -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general

Re: [GENERAL] PostgreSQL Source Control Integration

Hello Adrian, Thank you for your suggest, I'll examine and decide to use it. Regards, Gunce On Wed, Jun 21, 2017 at 3:45 PM, Adrian Klaver wrote: > On 06/21/2017 05:08 AM, Günce Kaya wrote: > >> Hi, >> >> I work on PostgreSQL 9.6 and I'm looking for a source code

Re: [GENERAL] Invalidation of cached plans for stored procedures ?

On 06/21/2017 06:06 AM, Pierre Ducroquet wrote: Please reply to list also. Ccing list. On Wednesday, June 21, 2017 5:49:29 AM CEST you wrote: On 06/21/2017 04:28 AM, Pierre Ducroquet wrote: Hi I found a workaround using event triggers to rewrite every function when an alter occurs on

Re: [GENERAL] Error when building new db using pg_restore

On 06/21/2017 05:06 PM, Jim Longwill wrote: On 06/21/2017 01:21 PM, David G. Johnston wrote: On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill wrote: rdev1=# \dd Object descriptions Schema | Name | Object | Description +--++- (0

Re: [GENERAL] Error when building new db using pg_restore

On 06/21/2017 01:21 PM, David G. Johnston wrote: On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill wrote: rdev1=# \dd Object descriptions Schema | Name | Object | Description +--++- (0 rows) Nothing user created has comments by

Re: [GENERAL] Error when building new db using pg_restore

Jim Longwill writes: > We have a (Linux CentOS) server, and one Postgres installation (v9.5). > > We have long been experiencing an error when doing a 'pg_restore' > database build from a tar > file. Our procedure is as follows (err. is just after start of > restoring our

[GENERAL] Error when building new db using pg_restore

We have a (Linux CentOS) server, and one Postgres installation (v9.5). We have long been experiencing an error when doing a 'pg_restore' database build from a tar file. Our procedure is as follows (err. is just after start of restoring our schema 'rradmin'): First, an export is done to a

Re: [GENERAL] Error when building new db using pg_restore

On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill wrote: > Given this, I wonder how we can avoid this 'error' situation .. short of > giving SUPERUSER > role to rradmin? I tried just removing the '-v' flag from pg_restore, > but the error is > still put in the log file

Re: [GENERAL] Error when building new db using pg_restore

On 06/21/2017 11:05 AM, Jerry Sievers wrote: Jim Longwill writes: We have a (Linux CentOS) server, and one Postgres installation (v9.5). We have long been experiencing an error when doing a 'pg_restore' database build from a tar file. Our procedure is as follows (err.

Re: [GENERAL] Error when building new db using pg_restore

On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill wrote: > rdev1=# \dd > Object descriptions > Schema | Name | Object | Description > +--++- > (0 rows) Nothing user created has comments by default. \dd only shows a very limited subset

Re: [GENERAL] Question about jsonb and data structures

On Wed, Jun 21, 2017 at 09:37:20AM -0700, Emilie Laffray wrote: > Date: Wed, 21 Jun 2017 09:37:20 -0700 > From: Emilie Laffray > To: Achilleas Mantzios > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Question about jsonb and

Re: [GENERAL] current postgresql logfile being written to?

> On 22 Jun 2017, at 4:06 AM, Lucas Possamai wrote: > > > > 2017-06-22 13:54 GMT+12:00 hvjunk >: > Hi there, > > I was hoping for a method (like archive_command) to handle logfile > processing/archiving/compression, but

Re: Fwd: [GENERAL] Streaming replication bandwith per table

On 6/21/17 22:04, Maeldron T. wrote: > * Logical replication is in 10.0 Beta 1. I might be oldschool but I > would install 10.1 or maybe 10.0.2 into production There are also other logical replication options such as pglogical and londiste. -- Peter Eisentraut

[GENERAL] current postgresql logfile being written to?

Hi there, I was hoping for a method (like archive_command) to handle logfile processing/archiving/compression, but unless doing it the logrotate way, I don’t see anything that postgresql provides. Is that correct? The closest I could find is: pg_rotate_logfile()… but here my question is where

Re: [GENERAL] current postgresql logfile being written to?

2017-06-22 14:16 GMT+12:00 hvjunk : > > On 22 Jun 2017, at 4:06 AM, Lucas Possamai wrote: > > > > 2017-06-22 13:54 GMT+12:00 hvjunk : > >> Hi there, >> >> I was hoping for a method (like archive_command) to handle logfile >>

Fwd: [GENERAL] Streaming replication bandwith per table

On Tue, Jun 20, 2017 at 3:06 AM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > > Not easily. You could play around with pg_xlogdump to see what's going > on in the WAL. But even if you figure it out, there is not much you can > do about it. > I could do a lot. For example, if I

Re: [GENERAL] current postgresql logfile being written to?

2017-06-22 13:54 GMT+12:00 hvjunk : > Hi there, > > I was hoping for a method (like archive_command) to handle logfile > processing/archiving/compression, but unless doing it the logrotate way, > I don’t see anything that postgresql provides. Is that correct? > > The closest I

[GENERAL] Cookbook for doing installation and configuration of PostgreSQL on Redhat

Hi All, I am new to chef concept, can anyone provide me a cookbook for doing installation and configuration of PostgreSQL on Redhat. I have checked so many cookbooks in the supermarket. -Pawan

Re: [GENERAL] Cookbook for doing installation and configuration of PostgreSQL on Redhat

On Wed, Jun 21, 2017 at 8:47 AM, PAWAN SHARMA wrote: > Hi All, > > I am new to chef concept, can anyone provide me a cookbook for doing > installation and configuration of PostgreSQL on Redhat. > I have checked so many cookbooks in the supermarket. What do you want

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

Adam Sjøgren wrote: > Meanwhile, I can report that I have upgraded from 9.3.14 to 9.3.17 and > the errors keep appearing the log. Just a quick update with more observations: All the errors in the postgres.log from one of the tables are triggered by a stored procedure that

Re: [GENERAL] "joining" table records

On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo wrote: > I have this table > > rec_code | rec_date | int1 | int2 | > 10 2014-07-21 3 4 > 11 2014-07-21 5 > 10 2015-01-04 1 2 > 11 2016-02-05 6 > > That's the result I need

Re: [GENERAL] Question about jsonb and data structures

Hello Achilleas, I fail to see how it would solve my problem here. I already have a structure that is packed and nested. Your example is on a simple key/value pair structure and effectively you can address the ids very simply. In my case, I would need to return only a subset of the json data.

Re: [GENERAL] Cookbook for doing installation and configuration of PostgreSQL on Redhat

https://github.com/sous-chefs/postgresql How is that? Lewis From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of PAWAN SHARMA Sent: 21 June 2017 16:47 To: pgsql-general@postgresql.org >> PG-General Mailing List

[GENERAL] "joining" table records

I have this table rec_code | rec_date | int1 | int2 | 10 2014-07-21 3 4 11 2014-07-21 5 10 2015-01-04 1 2 11 2016-02-05 6 That's the result I need to get from a SELECT statement rec_date | int1 | int2 | tempvalue 2014-07-21 3 4

Re: [GENERAL] Cookbook for doing installation and configuration of PostgreSQL on Redhat

I am new to chef concept, can anyone provide me a cookbook for doing installation and configuration of PostgreSQL on Redhat. Hi Pawan, I have always used the standard "postgresql" cookbook, which has recipes to install a server. In a Berksfile you just say: cookbook "postgresql" The