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
$ ldconfig -p
libpq.so.5
On Thu, 8 May 2014 08:54:44 +0200
Aqz poc...@aquaz.eu 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 :
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 made
On 2 May 2014 01:40, Stephan Fabel sfa...@hawaii.edu 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,
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.02.1 upgrade, that
further points to the issue potentially being a PostGIS problem.
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
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
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
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 :
$
On Thu, 8 May 2014 14:02:01 +0200
Aqz poc...@aquaz.eu 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
On Thu, May 8, 2014 at 5:02 PM, Aqz poc...@aquaz.eu 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
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 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.02.1 upgrade, that
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 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
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 l...@crysberg.dk writes:
Could it be related to the OFFSET part of the statement ? I have
another query
Leif Jensen l...@crysberg.dk 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
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
On 05/08/2014 07:19 AM, Tom Lane wrote:
Leif Jensen l...@crysberg.dk 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:
Adrian Klaver adrian.kla...@aklaver.com 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
On 05/08/2014 07:43 AM, Tom Lane wrote:
Adrian Klaver adrian.kla...@aklaver.com 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
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,
You can test with SymmetricDS (www.*symmetricds*.org)
On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh hatua...@gmail.com wrote:
You can test with SymmetricDS (www.*symmetricds*.org)
On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar sameer.ku...@ashnik.comwrote:
Thanks alot everyone!
I guess
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
Andrus kobrule...@hot.ee 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
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]
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 terencejferr...@gmail.com wrote:
You
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
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
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
We use symmetricDS for this. Works pretty well.
http://www.symmetricds.org/
From: Serge Fonville serge.fonvi...@gmail.commailto:serge.fonvi...@gmail.com
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee geoff.mon...@gmail.commailto:geoff.mon...@gmail.com
Cc: Sameer Kumar
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.cursor()
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.
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
On Fri, May 9, 2014 at 2:37 AM, Andrus kobrule...@hot.ee 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
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
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
37 matches
Mail list logo