Re: [GENERAL] postgresql "init script" for postgres 9.2.15

On 07/13/2016 02:35 PM, Steve Langlois wrote: Thank you but in our appliance, we are not running postgres as a service, we are running it programatically with this script, call postmaster to start it for instance instead of using the service framework. Is there an equivalent in 9.x or does it

Re: [GENERAL] pg_restore out of memory

I wrote: > I'm still suspicious that this might be some sort of NOTICE-processing- > related buffer bloat. Could you try loading the data with the server's > log_min_messages level cranked down to NOTICE, so you can see from the > postmaster log whether any NOTICEs are being issued to the

[GENERAL] Tracking IO Queries

Hi all, I got some IO spikes on my master server. But the point is that I was unable to find the query that caused that, because the query didn't take more than 300ms to run (300ms is the time that my alerts are settled)... Is there any way to track those queries? Maybe with pg_stat_statement?

[GENERAL] FTS with more than one language in body and with unknown query language?

Hi, I have a text corpus which contains either German or English docs and I expect queries where I don't know if it's German or English. So I'd like e.g. that a query "forest" matches "forest" in body_en but also "Wald" in body_de. I created a table with attributes body_en and body_de (type

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Steve Langlois writes: > Thank you but in our appliance, we are not running postgres as a service, we > are running it programatically with this script, call postmaster to start it > for instance instead of using the service framework. Is there an equivalent > in 9.x

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Please don't top-post. On Wed, Jul 13, 2016 at 5:35 PM, Steve Langlois wrote: > Thank you but in our appliance, we are not running postgres as a service, > we are running it programatically with this script, call postmaster to > start it for instance instead of using

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Thank you but in our appliance, we are not running postgres as a service, we are running it programatically with this script, call postmaster to start it for instance instead of using the service framework. Is there an equivalent in 9.x or does it now have to run as a service. I was able to

Re: [GENERAL] pg_restore out of memory

On 7/13/2016 2:11 PM, Miguel Ramos wrote: Yes. Both 9.1.8, I checked right now. 9.1 is up to 9.1.22, thats a lot of bug fixes you're missing. 9.1.8 was released 2013-02-07, 9.1.22 in 2016-05-12 -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list

Re: [GENERAL] pg_restore out of memory

Miguel Ramos writes: > So, what does this mean? > Was it the client that aborted? I think I saw that "unexpected message > type 0x58" on other types of interruptions. Yeah, 0x58 is ASCII 'X' which is a Terminate message. Between that and the unexpected-EOF

Re: [GENERAL] pg_restore out of memory

On 07/13/2016 01:51 PM, Miguel Ramos wrote: Finally, here are the log messages at the moment of the error. It is clearly not while building indices. The table in question is a big one, 111GB. Fields latitude, longitude and height are arrays of length around 500- 700 on each row (double and

Re: [GENERAL] pg_restore out of memory

Yes. Both 9.1.8, I checked right now. -- Miguel A Qua, 13-07-2016 às 13:59 -0700, John R Pierce escreveu: > On 7/13/2016 1:51 PM, Miguel Ramos wrote: > > Finally, here are the log messages at the moment of the error. > > It is clearly not while building indices. > > > > The table in question

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

On 07/13/2016 01:56 PM, Steve Langlois wrote: Hi, I've been searching for a 9.2.15 version of the postgresql script for "init script for starting up the PostgreSQL". I have managed to find older versions than what we are currently using, 8.2.5 but haven't had any luck finding a new version in

Re: [GENERAL] pg_restore out of memory

A Ter, 12-07-2016 às 13:08 +, Sameer Kumar escreveu: > On Tue, 12 Jul 2016, 7:25 p.m. Miguel Ramos, > wrote: > > I found two relevant threads on the mailing-lists. > > The most recent one sugested that postgresql was being configured > > to use > > more

Re: [GENERAL] pg_restore out of memory

On 7/13/2016 1:51 PM, Miguel Ramos wrote: Finally, here are the log messages at the moment of the error. It is clearly not while building indices. The table in question is a big one, 111GB. Fields latitude, longitude and height are arrays of length around 500- 700 on each row (double and real).

[GENERAL] postgresql "init script" for postgres 9.2.15

Hi, I've been searching for a 9.2.15 version of the postgresql script for "init script for starting up the PostgreSQL". I have managed to find older versions than what we are currently using, 8.2.5 but haven't had any luck finding a new version in the postgres 9.2.15 rpms. We are moving from

Re: [GENERAL] pg_restore out of memory

Finally, here are the log messages at the moment of the error. It is clearly not while building indices. The table in question is a big one, 111GB. Fields latitude, longitude and height are arrays of length around 500- 700 on each row (double and real). So, what does this mean? Was it the

[GENERAL] Database Architect - Voleon Capital Management LP

Database Architect Berkeley IT Full-time The Voleon Group is a technology-driven investment firm employing cutting-edge machine learning techniques seeks an exceptionally capable Database Architect. Your responsibilities will include making technical decisions with respect to relational database

Re: [GENERAL] pglogical cascading replication (chaining replication)

On 07/12/2016 07:20 AM, Nick Babadzhanian wrote: I apologize if this is wrong place to ask the question. A quote from pglogical FAQ: Q. Does pglogical support cascaded replication? Subscribers can be configured as publishers as well thus cascaded replication can be achieved by

Re: [GENERAL] pglogical cascading replication (chaining replication)

After checking logs I noticed this error on p3-node: >ERROR: cache lookup failed for replication origin >'pgl_test_node_p1_provider_sub_p1_t06410f8' pgl_test_node_p1_provider_sub_p1_t06410f8 is origin for p1-node. Here are the logs from all three server (this happens every time I insert

Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

Hi, On Fri, 2016-06-17 at 13:29 +0200, Job wrote: > i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with > Postgresql 9.5. > If i use a previous version of Psql it compile and works. I just built and pushed 3.1.9 packages to yum repo for CentOS 5. They will sync to master

Re: [GENERAL] jdbc 9.4-1208 driver for PostgreSQL 9.5?

Joek Hondius wrote: > (I hope i am on the right list) pgsql-jdbc would have been the perfect list. > jdbc.postgresql.org lists version 9.4 build 1208 as the lastest. > Is this the correct version to use with PostgreSQL 9.5 (or even 9.6-beta)? > I cannot find info on this elsewhere. Yes, you

[GENERAL] jdbc 9.4-1208 driver for PostgreSQL 9.5?

Hi, (I hope i am on the right list) jdbc.postgresql.org lists version 9.4 build 1208 as the lastest. Is this the correct version to use with PostgreSQL 9.5 (or even 9.6-beta)? I cannot find info on this elsewhere. https://jdbc.postgresql.org/download.html Greetings Joek -- Sent via

Re: [GENERAL] pg_restore out of memory

On Tue, Jul 12, 2016 at 12:25:08PM +0100, Miguel Ramos wrote: > > # pg_restore -d recovery /mnt/paysdeloire2013_convertida2.1.dump > > pg_restore: [custom archiver] out of memory > > 12:09:56.58 9446.593u+1218.508s 24.3% 167+2589k 6+0io 0pf+0sw 6968822cs ... > I suspect that the restore fails

Re: [GENERAL] Slow SQL?

On Tue, 12 Jul 2016 14:34:50 +0200 hubert depesz lubaczewski wrote: > On Tue, Jul 12, 2016 at 10:23:24AM +0200, Bjørn T Johansen wrote: > > I am trying to move a small system from Oracle to PostgreSQL and > > I have come upon a sql that runs really slow compared to on the