On 11/21/2016 11:28 PM, Mark Anns wrote:
Where I am missing? How can I do it? It needs CUDA also I think.
did you read the installation instructions? it says nothing about
netbeans, it says to use make and gcc etc.
http://strom.kaigai.gr.jp/install.html#install-os
don't ask me any questio
Nope. I am not asking about installation instructions. I have installed it.
And I know how to run it from command line.
I just wanted to compile it in netbeans.
--
View this message in context:
http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p59
We would like to have a master(read/write) version of a database (or a
schema or two) on one server and a readonly version of of the same
database. The only changed on the second one may be to duplicate changes
to views, materialized_views and indexes that also happened on the first
one.
We work
So, the question here is while I apply update on Slave, how do I know
if if it will be able to catch up or I need Wal archive? Is there a
way I can determine this? In my case, while applying update on slave,
the db process will be stopped, so the query, even if it gives correct
value, won't help. C
John,
Can you explain the Wal Archive procedure, how it can be setup so that
the slave never goes out of sync, even if master deletes the WAL
files?
On Tue, Nov 22, 2016 at 4:04 PM, Subhankar Chattopadhyay
wrote:
> So, the question here is while I apply update on Slave, how do I know
> if if it
Hi,
I did a series of test to see the WAL size impact of enabling data
checksums/wal_log_hints on our databases (so that we can use pg_rewind
to fix split brain situations). Having a set of servers available the
last few days I did a few tests. Here are the results:
No data checksums and wal
On Tue, Nov 22, 2016 at 9:40 PM, wrote:
> Am I doing something wrong? Would tweaking some checkpoint parameters help
> reduce the WAL volume?
The answer to this question is likely yes. wal_log_hints enforces a
FPW for the first modification of a page even if that's for some hint
bits. This gener
I think I understand.
When I use this in my code I get
"undefined reference to `PQexecParms'
when compiling.
references in main is
const char *conninfo; /* connection string to the database */
PGconn *conn; /* connection to the database */
PGresult *res; /* result of sql query */
int nFields;
Poul Kristensen writes:
> When I use this in my code I get
> "undefined reference to `PQexecParms'
> when compiling.
IIRC, it's PQexecParams not PQexecParms
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 11/21/2016 03:34 PM, Fran ... wrote:
Hi Adrian,
I followed you link and I had again errors:
What was the command you used?
/pg_restore: [archiver (db)] Error from TOC entry 4368; 2606 151317 FK
CONSTRAINT type_id_3940becf ownersuser/
/pg_restore: [archiver (db)] could not execute query
On Tue, Nov 22, 2016 at 8:22 AM, Poul Kristensen wrote:
> I think I understand.
> When I use this in my code I get
> "undefined reference to `PQexecParms'
>
The correct name is PQexecParams (note the last "a"). Sorry I missed that
when first looking. Also, just to be sure, did you include the
On 11/22/2016 12:29 AM, Mark Anns wrote:
Nope. I am not asking about installation instructions. I have installed it.
And I know how to run it from command line.
I just wanted to compile it in netbeans.
netbeans is a java-centric tool. if you can get it to run the make
files, it should work.
On 11/22/2016 2:34 AM, Subhankar Chattopadhyay wrote:
So, the question here is while I apply update on Slave, how do I know
if if it will be able to catch up or I need Wal archive? Is there a
way I can determine this? In my case, while applying update on slave,
the db process will be stopped, so
On 11/22/2016 3:41 AM, Subhankar Chattopadhyay wrote:
John,
Can you explain the Wal Archive procedure, how it can be setup so that
the slave never goes out of sync, even if master deletes the WAL
files?
The WAL archive will typically be a separate file server that both the
master and slave ca
On Nov 18, 2016, at 5:48 AM, Jehan-Guillaume de Rorthais wrote:
>
> On Thu, 17 Nov 2016 08:26:59 -0900
> Israel Brewster mailto:isr...@ravnalaska.net>> wrote:
>
>>> On Nov 16, 2016, at 4:24 PM, Adrian Klaver
>>> wrote:
>>>
>>> On 11/16/2016 04:51 PM, Israel Brewster wrote:
I've been pla
Thanks John, Well that clarifies about archive a lot!
On 22 Nov 2016 22:22, "John R Pierce" wrote:
On 11/22/2016 3:41 AM, Subhankar Chattopadhyay wrote:
> John,
>
> Can you explain the Wal Archive procedure, how it can be setup so that
> the slave never goes out of sync, even if master deletes
Hello
We are using PostgreSQL 9.3.10 on RedHat (probably 6.x).
The database is hosted by an internal service provider and we have
superuser access to it over a PG client, e.g. psql, but not to the OS.
For that reason we only have access to the log files indirectly using
some of the built in syste
Hi,
I am a bit confused about min_wal_size and max_wal_size. Previously, there
was this formula to estimate the max number of WAL segment files in
pg_xlog/ (https://www.postgresql.org/docs/9.4/static/wal-configuration.html
):
(2 + checkpoint_completion_target) * checkpoint_segments + 1 or
check
On 11/22/2016 12:51 PM, Torsten Förtsch wrote:
Hi,
I am a bit confused about min_wal_size and max_wal_size. Previously,
there was this formula to estimate the max number of WAL segment files
in pg_xlog/
(https://www.postgresql.org/docs/9.4/static/wal-configuration.html):
(2 + checkpoint_compl
On Tue, Nov 22, 2016 at 12:48 PM, Charles Clavadetscher
wrote:
> We are using PostgreSQL 9.3.10 on RedHat (probably 6.x).
Is it possible to upgrade? You are missing over a year's worth of
fixes for serious bugs and security vulnerabilities.
https://www.postgresql.org/support/versioning/
> Amo
Hi guys,
I currently have a slave02 server that is replicating from another slave01
via Cascading replication. The master01 server is shipping wal_files (via
ssh) to both slaves.
I'm doing some tests on slave02 to test the recovery via wal_files... The
goal here is to stop postgres, wait few min
On Wed, Nov 23, 2016 at 1:03 PM, Patrick B wrote:
> Hi guys,
>
> I currently have a slave02 server that is replicating from another slave01
> via Cascading replication. The master01 server is shipping wal_files (via
> ssh) to both slaves.
>
>
> I'm doing some tests on slave02 to test the recovery
2016-11-23 15:55 GMT+13:00 Venkata B Nagothi :
>
>
> On Wed, Nov 23, 2016 at 1:03 PM, Patrick B
> wrote:
>
>> Hi guys,
>>
>> I currently have a slave02 server that is replicating from another
>> slave01 via Cascading replication. The master01 server is shipping
>> wal_files (via ssh) to both slav
On Wed, Nov 23, 2016 at 1:59 PM, Patrick B wrote:
>
>
> 2016-11-23 15:55 GMT+13:00 Venkata B Nagothi :
>
>>
>>
>> On Wed, Nov 23, 2016 at 1:03 PM, Patrick B
>> wrote:
>>
>>> Hi guys,
>>>
>>> I currently have a slave02 server that is replicating from another
>>> slave01 via Cascading replication.
Yes making the file is the problem. If you read my topic again, then you may
know about what is the exact question
--
View this message in context:
http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p5931594.html
Sent from the PostgreSQL - general m
Greetings!
I'm using postgres version 9.5.5 on a ubuntu 16.04.1 server
installation which was installed through apt-get.
I have a query which if run alone usually completes in about 300ms.
When run in my application this query constantly locks up and bogs
down all connections of the connection po
26 matches
Mail list logo
