R: [GENERAL] CachedPlan logs until full disk

Dear Tom, thank you for the reply. Tonight this problem happened again: >> CachedPlan: 1024 total in 1 blocks; 640 free (0 chunks); 384 used >> CachedPlanSource: 1024 total in 1 blocks; 336 free (0 chunks); 688 used >> SPI Plan: 1024 total in 1 blocks; 912 free (0 chunks); 112 used >>

Re: [GENERAL] Moving pg_xlog

2016-12-02 17:10 GMT+13:00 Michael Paquier : > On Fri, Dec 2, 2016 at 1:04 PM, Melvin Davidson > wrote: > > Well, while the location of pg_xlog is not currently configurable, on > Linux system the way to do it is to: > > 1. stop PostgreSQL > >

Re: [GENERAL] Moving pg_xlog

On Fri, Dec 2, 2016 at 1:04 PM, Melvin Davidson wrote: > Well, while the location of pg_xlog is not currently configurable, on Linux > system the way to do it is to: > 1. stop PostgreSQL > 2. move the pg_xlog directory to a separate partition > 3. create a symbolic

Re: [GENERAL] Moving pg_xlog

On Thu, Dec 1, 2016 at 10:17 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Dec 1, 2016 at 7:59 PM, Jeff Janes wrote: > >> On Thu, Dec 1, 2016 at 5:55 AM, Robert Inder >> wrote: >> >>> >>> I'd really like to read an explicit

Re: [GENERAL] Moving pg_xlog

On Thu, Dec 1, 2016 at 7:59 PM, Jeff Janes wrote: > On Thu, Dec 1, 2016 at 5:55 AM, Robert Inder > wrote: > >> >> I'd really like to read an explicit discussion of this in the official >> documentation, rather than just glean what I can from

Re: [GENERAL] Moving pg_xlog

On Thu, Dec 1, 2016 at 5:55 AM, Robert Inder wrote: > I'm running Postgres9.4 in master/hot-standby mode on a few pairs of > servers. > > While recovering from A Bit Of Bother last week, I came across a > posting saying that pg_xlog should be on a separate partition. >

Re: [GENERAL] Overwrite pg_catalog?

On Thu, Dec 01, 2016 at 01:07:09PM +0100, Francisco Olarte wrote: > Juliano: > > On Thu, Dec 1, 2016 at 12:16 PM, Juliano wrote: > > I tried to restore pg_catalog to my new database, but the existing > > pg_catalog can't be overwritten or dropped, and postgres auto

Re: [GENERAL] Moving pg_xlog

On Thu, Dec 01, 2016 at 05:48:51PM +0200, Achilleas Mantzios wrote: > On 01/12/2016 15:55, Robert Inder wrote: > > I'm running Postgres9.4 in master/hot-standby mode on a few pairs of > > servers. > > > > While recovering from A Bit Of Bother last week, I came across a > > posting saying that

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

Hi, Adrian, On Thu, Dec 1, 2016 at 7:30 PM, Adrian Klaver wrote: > On 12/01/2016 04:21 PM, Igor Korot wrote: >> >> Hi, guys, >> I downloaded the latest sources, but the configure failed. >> I have OSX 10.8 here. >> >> Which version of the driver is compatible? > > >

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

On 12/01/2016 04:21 PM, Igor Korot wrote: Hi, guys, I downloaded the latest sources, but the configure failed. I have OSX 10.8 here. Which version of the driver is compatible? That is going to need more information: 1) What are version of Postgres are you trying to connect to? 2) Do you

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

Hi, guys, I downloaded the latest sources, but the configure failed. I have OSX 10.8 here. Which version of the driver is compatible? [code] Igors-MacBook-Air:buildMac igorkorot$ ../configure --with-iodbc=/Library/Frameworks/iODBC.framework/iODBC checking for a BSD-compatible install...

[GENERAL] Re: [GENERAL] [GENERAL] Replication between différent versions of the same OS.

Thanks a lot. That s what I was looking for ;) Yes, I was trying to avoid logical replication. I guess it s time for me to delve into it...

Re: [GENERAL] [GENERAL] Replication between différent versions of the same OS.

On Thu, 1 Dec 2016 20:11:06 +0100 Benoit Lobréau wrote: > Hi, > > Is it possible to use the built in replication to replicate between two > PostgreSQL in the same version but in different version of the same OS (Say > Pg 9.1 Ubuntu 12 to Pg 9.1 Ubuntu 14) > > I think

[GENERAL] [GENERAL] Replication between différent versions of the same OS.

Hi, Is it possible to use the built in replication to replicate between two PostgreSQL in the same version but in different version of the same OS (Say Pg 9.1 Ubuntu 12 to Pg 9.1 Ubuntu 14) I think I read in Hackers that since PostgreSQL uses the OS libraries for encoding. It could cause silent

Re: [GENERAL] Index is not used for "IN (non-correlated subquery)"

George writes: > On Thu, Dec 1, 2016 at 6:58 PM, Tom Lane wrote: >> What >> do you get for >> select * from pg_stats where tablename = 'wg3ppbm_userpartner'; >> and likewise for wg3ppbm_partner? > It is a wide table. Do you want me to dump csv here?

Re: [GENERAL] Index is not used for "IN (non-correlated subquery)"

On Thu, Dec 1, 2016 at 6:58 PM, Tom Lane wrote: > George writes: >> explain analyze select * >> from wg3ppbm_transaction where partner_uuid in ( >> select p.uuid >> from wg3ppbm_userpartner up >> join wg3ppbm_partner

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

On 12/01/2016 08:41 AM, Igor Korot wrote: Adrian, On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver wrote: On 12/01/2016 08:01 AM, Igor Korot wrote: Hi, ALL, This is my first post here. I have actually 2 questions which are kind of related. 1. Is there an OSX

Re: [GENERAL] Index is not used for "IN (non-correlated subquery)"

George writes: > explain analyze select * > from wg3ppbm_transaction where partner_uuid in ( > select p.uuid > from wg3ppbm_userpartner up > join wg3ppbm_partner p on p.id = up.partner_id > ); > "Hash Semi Join (cost=2.07..65628.14

Re: [GENERAL] Overwrite pg_catalog?

On 12/01/2016 03:16 AM, Juliano wrote: Hi everyone, I tried to restore pg_catalog to my new database, but the existing pg_catalog can't be overwritten or dropped, and postgres auto creates pg_catalog when I create a new DB. So, there is a way to restore the pg_catalog to a new database? Why

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

On 12/01/2016 08:41 AM, Igor Korot wrote: Adrian, On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver wrote: On 12/01/2016 08:01 AM, Igor Korot wrote: Hi, ALL, This is my first post here. I have actually 2 questions which are kind of related. 1. Is there an OSX

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

Adrian, On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver wrote: > On 12/01/2016 08:01 AM, Igor Korot wrote: >> >> Hi, ALL, >> This is my first post here. >> I have actually 2 questions which are kind of related. >> >> 1. Is there an OSX version of the ODBC PostgreSQL

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

On 12/01/2016 08:01 AM, Igor Korot wrote: Hi, ALL, This is my first post here. I have actually 2 questions which are kind of related. 1. Is there an OSX version of the ODBC PostgreSQL driver? 1a. If there is none - is there an instructions on how to build and install it?

[GENERAL] PostgreSQL ODBC driver for OSX 10.8

Hi, ALL, This is my first post here. I have actually 2 questions which are kind of related. 1. Is there an OSX version of the ODBC PostgreSQL driver? 1a. If there is none - is there an instructions on how to build and install it? 2. Is PostgreSQL ODBC driver works with iODBC? Thank you. --

Re: [GENERAL] Moving pg_xlog

On 01/12/2016 15:55, Robert Inder wrote: I'm running Postgres9.4 in master/hot-standby mode on a few pairs of servers. While recovering from A Bit Of Bother last week, I came across a posting saying that pg_xlog should be on a separate partition. I tried to find out more about this, by

Re: [GENERAL] Overwrite pg_catalog?

On Thu, Dec 1, 2016 at 4:16 AM, Juliano wrote: > Hi everyone, > > I tried to restore pg_catalog to my new database, but the existing > pg_catalog can't be overwritten or dropped, and postgres auto creates > pg_catalog when I create a new DB. > > So, there is a way to

Re: [GENERAL] issue with host name lookup in PQconnectdb

dharani kumar writes: > The problem i am facing is that PQconnectdb is blocking even though i > specified connect_timeout=10. My observation is below. > 1. To simulate this issue, i stopped the postgreSQL-x64-9.4 service and > executed my application. > 2.

Re: [GENERAL] Overwrite pg_catalog?

On Thu, Dec 1, 2016 at 7:07 AM, Francisco Olarte wrote: > Juliano: > > On Thu, Dec 1, 2016 at 12:16 PM, Juliano wrote: > > I tried to restore pg_catalog to my new database, but the existing > > pg_catalog can't be overwritten or dropped, and

[GENERAL] Moving pg_xlog

I'm running Postgres9.4 in master/hot-standby mode on a few pairs of servers. While recovering from A Bit Of Bother last week, I came across a posting saying that pg_xlog should be on a separate partition. I tried to find out more about this, by consulting the PostgresQL documentation (i.e.

[GENERAL] issue with host name lookup in PQconnectdb

The problem i am facing is that PQconnectdb is blocking even though i specified connect_timeout=10. My observation is below. 1. To simulate this issue, i stopped the postgreSQL-x64-9.4 service and executed my application. 2. host=localhost is used, database present in the same machine. 3. I have a

Re: [GENERAL] About the MONEY type

My two cents . . . On Wed, 2016-11-30 at 13:35 -0800, John R Pierce wrote: > On 11/30/2016 12:16 PM, John McKown wrote: > > Speaking generically, I guess maybe MONEY needs to be somewhat > > like a TIMESTAMP. At least in PostgreSQL, a TIMESTAMP can contain > > a TIMEZONE. I guess a MONEY type

Re: [GENERAL] btree gist indices, null and open-ended tsranges

Hi Chris: On Thu, Dec 1, 2016 at 12:56 PM, Chris Withers wrote: > So, first observation: if I make room nullable, the exclude constraint does > not apply for rows that have a room of null. I guess that's to be expected, > right? I would expect it, given: n=> select

Re: [GENERAL] Overwrite pg_catalog?

Juliano: On Thu, Dec 1, 2016 at 12:16 PM, Juliano wrote: > I tried to restore pg_catalog to my new database, but the existing > pg_catalog can't be overwritten or dropped, and postgres auto creates > pg_catalog when I create a new DB. This is because, in general,

[GENERAL] btree gist indices, null and open-ended tsranges

Hi All, Working with the exclude constraint example from https://www.postgresql.org/docs/current/static/rangetypes.html: CREATE EXTENSION btree_gist; CREATE TABLE room_reservation ( room text, during tsrange, EXCLUDE USING GIST (room WITH =, during WITH &&) ); So, first

[GENERAL] Overwrite pg_catalog?

Hi everyone, I tried to restore pg_catalog to my new database, but the existing pg_catalog can't be overwritten or dropped, and postgres auto creates pg_catalog when I create a new DB. So, there is a way to restore the pg_catalog to a new database? Regards, Juliano

Re: [GENERAL] Index is not used for "IN (non-correlated subquery)"

On Wed, Nov 30, 2016 at 10:08 PM, George wrote: > On Wed, Nov 30, 2016 at 8:44 PM, Tom Lane wrote: >> Merlin Moncure writes: >>> On Wed, Nov 30, 2016 at 11:05 AM, George wrote: So there is definitely