Hello Tom, Adrian
Thank you for your help and the patch. Things works nicely for me now :-).
Leif
- Original Message -
> Adrian Klaver writes:
> > On 05/08/2014 07:19 AM, Tom Lane wrote:
> >> 9.3 patch is here:
> >> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff
Where to get this fix in binary form for Windows 32-bit ?
Here, but you will need to wait until 9.3.5 is out:
http://www.postgresql.org/download/windows/.
When 9.3.5 or Windows x32 nightly build or test build will be out ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
I've build OpenSSL with zlib (perl Configure VC-WIN32 no-asm zlib-dynamic
--prefix=...) and now compression works correctly.
After executing:
SELECT lpad('', 1024*1024, 'A')
there is only about 13kB of TCP transfer instead of ~1MB.
Thanks again!
However I'm still curious why windows build doesn'
Thanks Sim, a very usefull information.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sim Zacks
Sent: Wednesday, May 07, 2014 7:33 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Crosstab function
What I have done in the past
On Fri, May 9, 2014 at 2:37 AM, Andrus wrote:
> Where to get this fix in binary form for Windows 32-bit ?
Here, but you will need to wait until 9.3.5 is out:
http://www.postgresql.org/download/windows/.
If you are in a hurry, you can still compile manually pg_dump and
deploy it where you need it..
> Hi all,
>
> If I turn use_watchdog = off in the pgpool.conf file, then in spite of the
> system being configured as master-slave, a socket file is created in /tmp,
> and everything starts normally with no errors. If, however, I set
> use_watchdog = on, pgpool will abort on startup with the follo
On 05/08/2014 03:11 PM, Vincent de Phily wrote:
On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote:
On 05/08/2014 04:09 AM, Vincent de Phily wrote:
Hello,
DO_LOOP is tested in a few places where we can make a clean exit. A cronjob
will restart the process if it is not or badly running.
On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote:
> On 05/08/2014 04:09 AM, Vincent de Phily wrote:
> > Hello,
> >
> > I'm processing records in batches using PG 9.1.12, python 2.7, and psycopg
>
> > 2.5.2 :
> Comments in the code below:
> > def enqueue_loop(q):
> > curs = DB_HANDLER.cur
We use symmetricDS for this. Works pretty well.
http://www.symmetricds.org/
From: Serge Fonville mailto:serge.fonvi...@gmail.com>>
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee mailto:geoff.mon...@gmail.com>>
Cc: Sameer Kumar mailto:sameer.ku...@ashnik.com>>,
PostgreSQL General Discu
Stuart,
thanks for your reply.
On 05/08/2014 12:47 AM, Stuart Bishop wrote:
> recovery.conf goes into $DATADIR, which is
> /var/lib/postgresql/9.1/main in your case. I rationalize this by
> considering it database state, rather than configuration, since
> commands like 'pg_ctl promote' or using a
Jay at Verizon wrote
> Hi all,
>
> If I turn use_watchdog = off in the pgpool.conf file, then in spite of the
> system being configured as master-slave, a socket file is created in /tmp,
> and everything starts normally with no errors. If, however, I set
> use_watchdog = on, pgpool will abort on s
Hi all,
If I turn use_watchdog = off in the pgpool.conf file, then in spite of the
system being configured as master-slave, a socket file is created in /tmp,
and everything starts normally with no errors. If, however, I set
use_watchdog = on, pgpool will abort on startup with the following errors:
Thanks! That would make sense why it doesn't work on Windows.
Do you know why PG build for Windows ships zlib support enabled for PG
(mostly pg_dump/pg_restore) but disabled for OpenSSL?
Best regards,
Krystian Bigaj
On 8 May 2014 17:28, Terence Ferraro wrote:
> You mentioned you are using the
But I wouldn't
call that a reliable fix. You'd be better off applying the patch.
Where to get this fix in binary form for Windows 32-bit ?
pg_dump.exe uses files below [1]. Is it sufficient to replace libpq.dll file
?
Where to get its compiled version or how to compile it in Windows ?
[1]
l
"Andrus" writes:
>> I looked back at the previous thread you mentioned (bug #7914) and was
>> reminded that we never did understand what was going on in that report.
>> I'm not sure if you are seeing the same thing though. That user reported
>> that he was able to see pg_dump's memory consumption
I looked back at the previous thread you mentioned (bug #7914) and was
reminded that we never did understand what was going on in that report.
I'm not sure if you are seeing the same thing though. That user reported
that he was able to see pg_dump's memory consumption bloating well beyond
what it
You can test with SymmetricDS (www.*symmetricds*.org)
On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh wrote:
> You can test with SymmetricDS (www.*symmetricds*.org)
>
>
> On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar wrote:
>
>>
>> Thanks alot everyone!
>>
>> I guess I will be exploring more on o
You mentioned you are using the Windows version; unless something has
changed recently in their build process, the included openssl library is
not linked against zlib and therefore compression is not possible unless
you recompile the Windows version yourself.
*Terence J. Ferraro*
On Thu, May 8,
On 05/08/2014 07:43 AM, Tom Lane wrote:
Adrian Klaver writes:
On 05/08/2014 07:19 AM, Tom Lane wrote:
9.3 patch is here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349c28167794eadaf
Alright, so I obviously linked to the wrong patch because I poi
Adrian Klaver writes:
> On 05/08/2014 07:19 AM, Tom Lane wrote:
>> 9.3 patch is here:
>> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349c28167794eadaf
> Alright, so I obviously linked to the wrong patch because I pointed at
> HEAD and not REL9_3_STABL
On 05/08/2014 07:19 AM, Tom Lane wrote:
Leif Jensen writes:
I already compiled postgreSQL myself and now using 9.3.4, so I would very
much like a patch. Where can I find that ?
9.3 patch is here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349
On 05/08/2014 06:59 AM, Leif Jensen wrote:
Hi Tom,
I already compiled postgreSQL myself and now using 9.3.4, so I would very
much like a patch. Where can I find that ?
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=04e5025be8bbe572e12b19c4ba9e2a8360b8ffe5
Leif
--
Leif Jensen writes:
>I already compiled postgreSQL myself and now using 9.3.4, so I would very
> much like a patch. Where can I find that ?
9.3 patch is here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349c28167794eadaf
r
Hi Tom,
I already compiled postgreSQL myself and now using 9.3.4, so I would very
much like a patch. Where can I find that ?
Leif
- Original Message -
> Leif Jensen writes:
> >Could it be related to the OFFSET part of the statement ? I have
> >another query on the same
On 05/08/2014 01:22 AM, Krystian Bigaj wrote:
Hi,
I'm wondering how, and if SSL compression works correctly.
Here is how I tested it:
- PostgreSQL 9.3.4 x86 on Windows 7 x64
- .crt/.key files by openssl, and placed in database cluster folder
- postgres.exe ran with: --ssl="on" --ssl_cert_file="
On 05/08/2014 04:09 AM, Vincent de Phily wrote:
Hello,
I'm processing records in batches using PG 9.1.12, python 2.7, and psycopg
2.5.2 :
Comments in the code below:
def enqueue_loop(q):
curs = DB_HANDLER.cursor()
query = """UPDATE foo SET processing = 't' WHERE id IN
On 5/8/2014 7:07 AM, Paul Ramsey wrote:
Roxanne, you seem to have isolated the problem to a particular
geometry column, which speaks to this being a PostGIS problem.
ok - wrong list - sorry!
Since the analyze code was re-written in 2.1, and your issue is coming
up in a 2.0>2.1 upgrade, that fur
On 05/08/2014 02:09 PM, Vincent de
Phily wrote:
The problem is that sometimes (once every few days at about 2-300K queries per
day) I get many more rows than the max 5000 I asked for (I've seen up to 25k).
And I'm getting timeouts and other problems as a result.
On Thu, May 8, 2014 at 5:02 PM, Aqz wrote:
> I have devel package installed.
>
> Centos postgresql package adds file to /etc/ld.so.conf.d with path to
> pgsql libraries directory (/usr/pgsql-9.3/lib/) so I don't think that is
> the problem.
> As you can see in my first message ldconfig -p lists l
On Thu, 8 May 2014 14:02:01 +0200
Aqz wrote:
> I have devel package installed.
>
> Centos postgresql package adds file to /etc/ld.so.conf.d with path to pgsql
> libraries directory (/usr/pgsql-9.3/lib/) so I don't think that is the
> problem.
So, it seems "ldconfig" searches in ld.so.conf.d pat
I have devel package installed.
Centos postgresql package adds file to /etc/ld.so.conf.d with path to pgsql
libraries directory (/usr/pgsql-9.3/lib/) so I don't think that is the
problem.
As you can see in my first message ldconfig -p lists libpq library among
others..
Also :
$ LD_LIBRARY_PATH="/u
On 05/08/2014 02:54 AM, Aqz wrote:
Hi.
I'm not sure if I should write here, or on a Centos mailing list...
I have fresh, vanilla Centos 6.5 with postgresql yum repository added.
I've successfully installed postgresql93 and postgresql93-libs packages, but
still :
$ ld -lpq
ld: cannot find -lpq
Hi,
Yes. It seems that /usr/pgsql-9.3/lib is not in linker default library
search path. You may either require to provide it explicitly via -L option
while linking or add /usr/pgsql-9.3/lib to the default library search path.
As suggested by Alberto, for development work related devel package is
Hello,
I'm processing records in batches using PG 9.1.12, python 2.7, and psycopg
2.5.2 :
def enqueue_loop(q):
curs = DB_HANDLER.cursor()
query = """UPDATE foo SET processing = 't' WHERE id IN
Roxanne, you seem to have isolated the problem to a particular geometry column,
which speaks to this being a PostGIS problem. Since the analyze code was
re-written in 2.1, and your issue is coming up in a 2.0>2.1 upgrade, that
further points to the issue potentially being a PostGIS problem. Unle
On 2 May 2014 01:40, Stephan Fabel wrote:
> All,
>
> apologies if this has been addressed somewhere already. I don't have a
> lot of experience in PostgreSQL; this is my first setup where I'm trying
> to scale and provide some of the more advanced features (like WAL
> shipping, master-slave sync,
Hi,
I'm wondering how, and if SSL compression works correctly.
Here is how I tested it:
- PostgreSQL 9.3.4 x86 on Windows 7 x64
- .crt/.key files by openssl, and placed in database cluster folder
- postgres.exe ran with: --ssl="on" --ssl_cert_file="test.crt"
--ssl_key_file="test.key"
- connection
On Thu, 8 May 2014 08:54:44 +0200
Aqz wrote:
> Hi.
>
> I'm not sure if I should write here, or on a Centos mailing list...
>
> I have fresh, vanilla Centos 6.5 with postgresql yum repository added.
> I've successfully installed postgresql93 and postgresql93-libs packages,
> but still :
>
> $ l
38 matches
Mail list logo
