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
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
24 matches
Mail list logo