On 28.01.2016 20:36, Wolfgang Winkler wrote:
I'm using 9.4.5 as well and I used exactly the same iconv lines as you
postes below.
Are there any encoding options that have to be set right? The database
encoding is set to UTF8.
ww
What output does the command show:
-> SHOW LC_CTYPE;
?
Did yo
Am 2016-01-29 um 10:21 schrieb Artur Zakirov:
On 28.01.2016 20:36, Wolfgang Winkler wrote:
I'm using 9.4.5 as well and I used exactly the same iconv lines as you
postes below.
Are there any encoding options that have to be set right? The database
encoding is set to UTF8.
ww
What output does
Hello,
Is there any way to specify priority for replication. or any parameter
which guarantees something about replication (speed at which it replicates,
number of minimum replicas to write).
Does BDR has a configuration for differentiated services in replication. I
want to categorize my data tha
2016-01-28 16:33 GMT-02:00 Igor Neyman :
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Felipe Santos
> *Sent:* Thursday, January 28, 2016 1:17 PM
> *To:* Joshua D. Drake
> *Cc:* Melvin Davidson ; David Rowley <
> david.row...@2ndqua
On 1/29/2016 2:27 AM, Nikhil wrote:
Is there any way to specify priority for replication. or any parameter
which guarantees something about replication (speed at which it
replicates, number of minimum replicas to write).
Does BDR has a configuration for differentiated services in
replicatio
On 01/28/2016 08:02 PM, John R Pierce wrote:
> I go to read the repmgr quickstart and get a 404?
> https://github.com/2ndQuadrant/repmgr/blob/master/QUICKSTART.md
>
> I was on this page yesterday and it was fine.
The documentation was refactored and everything was put in the README.
https://githu
Hi,
I am following http://bdr-project.org/docs/stable/index.html to setup BDR
for postgresql version 9.5 as per
[root@ip-172-31-1-17 9.5]# cat /etc/redhat-release
*Red Hat Enterprise Linux Server release 6.6 (Santiago)*
[root@ip-172-31-1-17 9.5]# rpm -qa | grep postgre
postgresql95-libs-9.5.0-2PG
>From the Packt book "Postgresql Server Programming"
"you can have a similar environment in your Python development
environment using the plpy module.
Just put the module in your path and do import plpy before you try
running your prospective PL/PythonU functions in an ordinary
interpreter."
I'v
>> From the above, may I presume that it is best to cluster (or sort), the
>> table based on the intended
>> BRIN column(s) before actually creating the index to insure the pages are
>> adjacent? If so, should
>> that not be included in the documentation, instead of implied?
The same question is
Emre Hasegeli wrote:
> >> From the above, may I presume that it is best to cluster (or sort), the
> >> table based on the intended
> >> BRIN column(s) before actually creating the index to insure the pages are
> >> adjacent? If so, should
> >> that not be included in the documentation, instead of
Hello,
Trying to get pg_repack built for Postgresql 9.4 and it appears there
are no 9.4 versions of libpq-dev and libpq5 available in the trusty
repo.
pg_repack will not build with the latest and greatest versions. I ran
into exactly the same issue with Debian Squeeze, but in that case the
9.4 ve
Hello,
the ICU patch isn’t ready for PostgreSQL on FreeBSD.
Is there any risk (more than 0) in executing the initdb without ICU
support and recompiling PostgreSQL later when the ICU patch is ready? I
mean any risk without making a dump and import before the switch.
If this is okay for su
I've set statement timeout in postgresql.conf to 300s.
Now, I have a schema update procedure at application startup I would
like to run without timeout, or with significant larger timeout (let's
say, 1s).
It is possible to change statement timeout at runtime before issuing the
command (fo
On 01/29/2016 06:17 AM, Leonard B wrote:
Hello,
Trying to get pg_repack built for Postgresql 9.4 and it appears there
are no 9.4 versions of libpq-dev and libpq5 available in the trusty
repo.
pg_repack will not build with the latest and greatest versions. I ran
into exactly the same issue with
On Thu, Jan 28, 2016 at 9:07 PM, Michael Paquier
wrote:
>
>
> On Fri, Jan 29, 2016 at 1:55 AM, David G. Johnston wrote:
> > Could you run the following and post the result, please? I have yet to
> > setup a compiled-from-source installation...
> >
> > \pset title 'This is a medium length title'
On Sun, Jan 24, 2016 at 11:12 PM, drum.lu...@gmail.com
wrote:
> So, I made a SELECT to get some data, to see where's the issue:
>
> SELECT * FROM integrations.accounts WHERE qb_settings IS NULL OR
> xero_settings IS NULL OR freshbooks_settings IS NULL OR myob_settings IS
> NULL OR ppy_settings IS
On 29/01/2016 16:46, Maeldron T. wrote:
Hello,
the ICU patch isn’t ready for PostgreSQL on FreeBSD.
https://people.freebsd.org/~girgen/postgresql-icu/readme.html
Is there any risk (more than 0) in executing the initdb without ICU
support and recompiling PostgreSQL later when the IC
On 01/29/2016 04:13 AM, Kent Tenney wrote:
From the Packt book "Postgresql Server Programming"
"you can have a similar environment in your Python development
environment using the plpy module.
Just put the module in your path and do import plpy before you try
running your prospective PL/Python
On 01/29/2016 07:00 AM, Edson Richter wrote:
I've set statement timeout in postgresql.conf to 300s.
Now, I have a schema update procedure at application startup I would
like to run without timeout, or with significant larger timeout (let's
say, 1s).
It is possible to change statement timeout
On Fri, Jan 29, 2016 at 5:46 PM, Maeldron T. wrote:
> Hello,
>
> the ICU patch isn’t ready for PostgreSQL on FreeBSD.
>
> Is there any risk (more than 0) in executing the initdb without ICU
> support and recompiling PostgreSQL later when the ICU patch is ready? I
> mean any risk without m
On Sat, Jan 30, 2016 at 4:39 AM, Achilleas Mantzios
wrote:
> On 29/01/2016 16:46, Maeldron T. wrote:
>>
>> Hello,
>>
>> the ICU patch isn’t ready for PostgreSQL on FreeBSD.
>
>
> https://people.freebsd.org/~girgen/postgresql-icu/readme.html
If the goal is to get Unicode collation support
On 01/29/2016 11:19 AM, Leonard B wrote:
Ccing list
On Fri, Jan 29, 2016 at 10:29 AM, Adrian Klaver
wrote:
On 01/29/2016 06:17 AM, Leonard B wrote:
Hello,
Trying to get pg_repack built for Postgresql 9.4 and it appears there
are no 9.4 versions of libpq-dev and libpq5 available in the trusty
Hello,
I googled "plpgsql debugger" and eventually ended up at
http://pgfoundry.org/projects/edb-debugger/, where the latest release is
almost 8 years old. I am aware that this is not an EDB forum but given that
I sent them an e-mail at 9AM EST and I haven't received a response yet I
figured it ca
Hi
2016-01-29 21:52 GMT+01:00 Dane Foster :
> Hello,
>
> I googled "plpgsql debugger" and eventually ended up at
> http://pgfoundry.org/projects/edb-debugger/, where the latest release is
> almost 8 years old. I am aware that this is not an EDB forum but given that
> I sent them an e-mail at 9AM
You did not indicate which O/S you are using, but here are the detailed
instructions for Windows.
http://blog.databasepatterns.com/2014/01/installing-debugger-for-pgadmin-on.html
Note that the most important part is to load the .dll in postgresql.conf.
shared_preload_libraries = '$libdir/plugin_
On Fri, Jan 29, 2016 at 4:22 PM, Melvin Davidson
wrote:
> You did not indicate which O/S you are using, but here are the detailed
> instructions for Windows.
>
>
> http://blog.databasepatterns.com/2014/01/installing-debugger-for-pgadmin-on.html
>
> Note that the most important part is to load the
Hello,
I am trying to install PostGIS on a CentOS Linux release 7.2.1511 (Core).
I installed PostGreSQL successfully. But when I try to install PostGIS
using
yum install postgres2_93
I get transaction conflict errors (2 of many are posted below):
file /usr/share/mysql/charsets/README from ins
On 1/29/2016 2:59 PM, Augori wrote:
I get transaction conflict errors (2 of many are posted below):
file /usr/share/mysql/charsets/README from install of
mariadb-libs-1:5.5.44-2.el7.centos.x86_64 conflicts with file from
package MySQL55-server-5.5.47-1.cp1148.x86_64
where is this MySQL55-
On 01/29/2016 02:59 PM, Augori wrote:
Hello,
I am trying to install PostGIS on a CentOS Linux release 7.2.1511
(Core). I installed PostGreSQL successfully. But when I try to install
PostGIS using
yum install postgres2_93
The above should be postgis2_93, correct?
I get transaction conflict
Hi John,
I don't know the answer to your question. I was assuming it has to do with
the MYSQL server that's installed on this machine. I should clarify that
I'm just one of a number of people who are trying to work together on this
machine, so most of what's been done to this machine was not don
Yes, I should have said, postgis2_93.
I guess it may be unrelated, but I'm not sure how to find out.
Yes, thanks, I took a good look at that page which gives instructions for
how to fix a different error.
On Fri, Jan 29, 2016 at 6:20 PM, Adrian Klaver
wrote:
> On 01/29/2016 02:59 PM, Augori wr
On 1/29/2016 6:49 PM, Augori wrote:
I don't know the answer to your question. I was assuming it has to do
with the MYSQL server that's installed on this machine. I should
clarify that I'm just one of a number of people who are trying to work
together on this machine, so most of what's been
Okay thanks, John. I will inquire about that.
On Fri, Jan 29, 2016 at 10:11 PM, John R Pierce wrote:
> On 1/29/2016 6:49 PM, Augori wrote:
>
>>
>> I don't know the answer to your question. I was assuming it has to do
>> with the MYSQL server that's installed on this machine. I should clarify
33 matches
Mail list logo
