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 no
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 pg_resto
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?
I
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 "text
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 or does it now have to run
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 the service framework. Is th
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 mod
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 (pgsql-g
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 report, it's quite clear that the clien
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 rea
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 is
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 th
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 memory than what's available.
> > The
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).
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 Ce
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 clien
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 t
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 forwarding/chai
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
somet
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
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 shou
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 pgsql-g
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
23 matches
Mail list logo
