Tom,
Did you ever find a solution to this without updating ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 21 September 2017 at 13:01, Dave Cramer <p...@fastcrypt.com> wrote:
> Too late I just stumbled over this as well!
>
> Dave Cramer
>
> d
Too late I just stumbled over this as well!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 20 September 2017 at 14:34, Tom Lane <t...@sss.pgh.pa.us> wrote:
> It seems to install some libraries that depend on
> /usr/lib/system/libsystem_darwin.dylib, which doesn't exist
encourage them to do so.
>>>>>
>>>>
>>>> I have added this as an open item because we will have to wait to see
>>>> where we are with driver support as the release gets closer.
>>>>
>>>
>>> With the release near, I'm promo
869>
Thanks,
Dave Cramer
log
when log_replication_commands is enabled. Passing database as the value
instructs walsender to connect to the database specified in the dbname
parameter, which will allow the connection to be used for logical
replication from that database.
Dave Cramer
You have to turn it on using the autosave parameter. it's not on by
default, and apparently not documented
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 7 March 2017 at 17:15, legrand legrand <legrand_legr...@hotmail.com>
wrote:
> Thanks !
>
> that's a very good
llback-explained.html
>
> JDBC has it since 9.4.1210 (2016-09-07), unless I am mistaken:
>
> https://github.com/pgjdbc/pgjdbc/commit/adc08d57d2a9726309ea80d574b1db
> 835396c1c8
I thought he meant we have to play with savepoints.
Yes, we do it for you now
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
bc, npgsql CCed).
>
> Currently PGPASS is in the users home directory Many JDBC applications are
in much larger apps such as tomcat, etal
this concept is a bit foreign to JDBC. That being said I don't think it's
difficult to implement. Just somewhat harder to specify
for us. psql is rather limited being a command line app which is *usually*
evoked directly from the command line.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Not sure you can get the exec. We are working on producing the BT from
Travis-CI or I will build and run the test locally and get the trace
Dave Cramer
On 19 January 2017 at 15:31, Craig Ringer <craig.rin...@2ndquadrant.com>
wrote:
>
>
> On 20 Jan. 2017 04:13, "Ro
= 140728909791233, hash = 0x7ffe96960d58,
match = 0x16da2d1, keycopy = 0x7ffe96960d58, alloc = 0x1703af0,
hcxt = 0x16da2d0, hctl = 0x0}
max_table_size = 117899280
requestSize =
found = 0 '\000'
Dave Cramer
On 19 January 2017 at 12:05, Dave Cramer <dave
I'll try to get the stack trace from the core dump, have to build master
first
Dave Cramer
On 19 January 2017 at 12:01, Jorge Solórzano <jor...@gmail.com> wrote:
> Robert, the logs I get from postgres (at least the section that matters)
> is here:
> If you need somethin
The travis job https://travis-ci.org/pgjdbc/pgjdbc/jobs/192517342 is seeing
a segfault when we are testing against HEAD with REPLICATION turned on.
Logs can be found here
https://drive.google.com/drive/folders/0B-Heg5ZYCWbreEE4Uk5LdnJ5eWM?usp=sharing
Regards,
Dave Cramer
with, and ultimately outlast, venture-funded startups.
>
Thanks for your hard work. PostgreSQL has come a long way since then!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
That will teach me to copy and paste a config from somewhere ...
Thanks
Dave Cramer
On 9 December 2016 at 10:43, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Dave Cramer <davecra...@gmail.com> writes:
> > Looking at src/port/pg_strong_random.c this would be a bug in autoconf
&
--with-libraries=/usr/local/opt/openssl/lib
--with-includes=/usr/local/opt/openssl/include/ --no-create --no-recursion
I am using openssl-1.0.2j
Regards,
Dave Cramer
On 27 November 2016 at 11:29, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Dave Cramer <davecra...@gmail.com> writes:
> > We are proposing changing the JDBC version from
> > 9.4. to 42.x.x
>
> > We have two issues we are trying to address here.
>
> &g
and they see no problems.
Please speak up now if you foresee any issues with this idea.
FYI, 42 was more or less chosen at random. But it is large enough to avoid
any future conflicts with the server, and greater than 9 to avoid issues
with maven requesting things like > 9
Dave Cramer
t think it would be too painful to adjust existing
>> application.
>>
>> We could continue to accept a Python list for a plain composite type,
>> this would only affect arrays of composite types.
>>
>> I don't use PL/python much myself, so I don't feel qualified to make the
>> call, though. Any 3rd opinions?
>
>
Can't you determine the correct output based on the function output
definition ?
For instance if the function output was an array type then we would return
the list as an array
if the function output was a set of then we return tuples ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 27 September 2016 at 14:58, Heikki Linnakangas <hlinn...@iki.fi> wrote:
> On 09/27/2016 02:04 PM, Dave Cramer wrote:
>
>> On 26 September 2016 at 14:52, Dave Cramer <p...@fastcrypt.com> wrote:
>>
>>> This crashes with arrays with non-default lower bou
On 26 September 2016 at 14:52, Dave Cramer <p...@fastcrypt.com> wrote:
>
>
>
>>
>> This crashes with arrays with non-default lower bounds:
>>
>> postgres=# SELECT * FROM test_type_conversion_array_int
>> 4('[2:4]={1,2,3}');
>> INFO: ([1, 2
"inner" and "outer" dimensions? I wonder
> if that would be easier to read, if it was written in a recursive-style,
> rather than iterative with stacks for the dimensions.
>
> Yes, it is fairly convoluted.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 18 September 2016 at 09:27, Dave Cramer <p...@fastcrypt.com> wrote:
>
> On 10 August 2016 at 01:53, Pavel Stehule <pavel.steh...@gmail.com> wrote:
>
>> Hi
>>
>> 2016-08-03 13:54 GMT+02:00 Alexey Grishchenko <agrishche...@pivotal.io>:
>>
>
Yes, this should be closed as it is contained in
https://commitfest.postgresql.org/10/697/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
t; I am sending review of this patch:
>
> 1. The implemented functionality is clearly benefit - passing MD arrays,
> pretty faster passing bigger arrays
> 2. I was able to use this patch cleanly without any errors or warnings
> 3. There is no any error or warning
> 4. All tests passed - I tested Python 2.7 and Python 3.5
> 5. The code is well commented and clean
> 6. For this new functionality the documentation is not necessary
>
> 7. I invite more regress tests for both directions (Python <-> Postgres)
> for more than two dimensions
>
> My only one objection is not enough regress tests - after fixing this
> patch will be ready for commiters.
>
> Good work, Alexey
>
> Thank you
>
> Regards
>
> Pavel
>
>
>> --
>> Best regards,
>> Alexey Grishchenko
>>
>
>
Pavel,
I will pick this up.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Pavel,
I will pick these up.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ight not have been the best thing to do in
> a green field, but given the precedent ...
>
> regards, tom lane
>
>
> seems to me that it should report 10 for the major and whatever comes
after the . for the minor ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
that both JDBC and ODBC are not exclusively
PostgreSQL drivers and as such we sometimes have to jump through hoops to
provide the semantics requested by the API.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
u're doing
> something very different - not necessarily wrong - and not attempt to
> impose your ideas on everyone as if it's the only true way to write a db
> driver.
>
A number of other drivers default to this behaviour, including at least
MS-SQL and Oracle. psqlODBC
> 3) Add build badge to the readme (link to travis ci build) for simplified
> navigation to test results.
>
> Here's the commit: https://github.com/vlsi/postgres/commit/
> 4841f8bc00b7c6717d91f51c98979ce84b4f7df3
> Here's how test results look like: https://travis-ci.org/vlsi/postgres
>
>
Nice work +!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
tests every time a PR is created on github, but I don't
think there are any animals running the JDBC test suite
We can add tests, what exactly do we want to test. Then setting up an
animal to run the tests would be fairly straight forward.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
; calling jvm from sql or vice-versa is not really possible.
I do like the idea of the background worker and shared memory though.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Does anyone else have a Windows 7 installation we can test this on ?
This
https://github.com/postgres-plr/plr/files/191013/plr-8.3.0.16-pg9.5-win32.zip
is actually a 64 bit version built on windows 10. I've had one confirmation
that it works.
Dave
Dave Cramer
da...@postgresintl.com
ON with no inserted whitespace.
>
> As I mentioned to Sehrope on IRC, at least for my 2c, if you want a
> compact JSON format to reduce the amount of traffic over the wire or to
> do things with on the client side, we should probably come up with a
> binary format, rather than just ha
On 3 April 2016 at 22:20, Stephen Frost <sfr...@snowman.net> wrote:
> * Craig Ringer (cr...@2ndquadrant.com) wrote:
> > On 4 April 2016 at 10:13, Dave Cramer <p...@fastcrypt.com> wrote:
> > > Async notification is the easier part, I wasn't aware that the ssl
&g
On 3 April 2016 at 21:56, Stephen Frost <sfr...@snowman.net> wrote:
> Dave,
>
> * Dave Cramer (p...@fastcrypt.com) wrote:
> > On 3 April 2016 at 15:35, Stephen Frost <sfr...@snowman.net> wrote:
> > > Not generally much of a JDBC user myself, but the inabili
On 3 April 2016 at 12:18, Igal @ Lucee.org <i...@lucee.org> wrote:
> On 4/3/2016 8:21 AM, Dave Cramer wrote:
>
>
> On 9 March 2016 at 20:49, Craig Ringer <cr...@2ndquadrant.com> wrote:
>
>> On 3/8/2016 5:12 PM, Craig Ringer wrote:
>>
>>>
>>
On 3 April 2016 at 15:35, Stephen Frost <sfr...@snowman.net> wrote:
> * Dave Cramer (p...@fastcrypt.com) wrote:
> > On 9 March 2016 at 20:49, Craig Ringer <cr...@2ndquadrant.com> wrote:
> >
> > > On 10 March 2016 at 00:41, Igal @ Lucee.org <i...@lucee.org&g
to turn this question around. Are there good reasons to use -ng
over pgjdbc ?
As to your question, you may be interested to know that pgjdbc is more
performant than ng.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Getting lots of POSTGRESQL_TRACE_... undefined.
Any hints ?
Dave Cramer
here.
There is an impedance mismatch between the java ecosystem and distros.
We have moved to maven as have most other java projects.
As Craig said, if you want to build it, patch it out, and create a
ant/Makefile to make the jar.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
We have an interesting problem, and the reporter has been kind enough to
provide logs for which we can't explain.
I'd be interested to hear any plausible explanations for a prepared plan
suddenly going from 2ms to 60ms for the same input values ?
Dave Cramer
da...@postgresintl.com
Hi Marko,
Interesting so why would it choose a worse plan at that point ? Why would
it change at all if the current plan is working well ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 12 January 2016 at 07:15, Marko Tiikkaja <ma...@joh.to> wrote:
> On 12/01/16 13:00, Da
Add
DriverManager.setLogWriter(new PrintWriter(System.out));
below the setLogLevel and it will
I'll fix this though
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 22:35, Tatsuo Ishii <is...@postgresql.org> wrote:
> Unfortunately it doesn't work (no de
No, I need to provide you with a 41 version.
I just happened to have java 1.8 on my machine.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 21:31, Tatsuo Ishii <is...@postgresql.org> wrote:
> Dave,
>
> Thanks for the quick response. Unfortunately
This should work better
https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc41-SNAPSHOT/
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 21:32, Dave Cramer <p...@fastcrypt.com> wrote:
> No, I need to pr
Tatsuo,
Can you confirm it is fixed in this snapshot
https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 19:00, Dave Cramer <p...@fastcrypt.com>
Tatsuo,
posting to jdbc list
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 18:28, Tatsuo Ishii <is...@postgresql.org> wrote:
> It seems
> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does
> not work anymore in the newer JDBC dri
noticed this one thought was to create duplicate operators
specifically for the use of the JDBC driver.
I had dismissed this at the time, now I'm not so sure
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
custom
operators is a separate discussion.
David J.
It would seem that choosing ? for operators was ill advised; I'm not
convinced that deprecating them is a bad idea. If we start now, in 5 years
they should be all but gone
Agreed a patch would be the first place to start
Dave Cramer
be faster than what's there now (when the option was not
set). Some operators would look a little funny in Java string
literals, but that's not so bad.
Perhaps reviewing https://github.com/pgjdbc/pgjdbc/pull/187 might help
understand why we chose ??
Dave Cramer
dave.cramer(at)credativ(dot)ca
http
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 19 May 2015 at 13:15, Mike Blackwell mike.blackw...@rrd.com wrote:
A Google search suggests Oracle 9.x supports a unary '?' operator (fuzzy
match), so the use of '?' in an operator name is not without precedent
connector expected to follow both?
Currently pull requests are the easiest to deal with so most discussion is
on github.
I guess updating the JDBC web page would be in order.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 19 May 2015 at 15:02, Tom Lane t...@sss.pgh.pa.us wrote:
Greg Sabino Mullane g...@turnstep.com writes:
Dave Cramer opined:
It would seem that choosing ? for operators was ill advised; I'm not
convinced that deprecating them is a bad idea. If we start now, in 5
years
they should
Not sure what the point of this is: as you indicated the ship has sailed so
to speak
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 15 May 2015 at 15:14, Bruno Harbulot br...@distributedmatter.net wrote:
Hello,
I've been trying to use the new JSONB format using JDBC
On 15 May 2015 at 16:41, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:38 PM, Dave Cramer p...@fastcrypt.com wrote:
I don't really want to take a violently strong position on this
without understanding what's really going on here.
Well our solution was to use
On 15 May 2015 at 16:21, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:13 PM, Dave Cramer p...@fastcrypt.com wrote:
Not sure what the point of this is: as you indicated the ship has sailed
so
to speak
Well, if we were to agree this was a problem, we could introduce
On 15 May 2015 at 16:35, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:23 PM, Dave Cramer p...@fastcrypt.com wrote:
Well, if we were to agree this was a problem, we could introduce new,
less-problematic operator names and then eventually deprecate the old
ones
On 15 May 2015 at 16:44, Dave Cramer p...@fastcrypt.com wrote:
On 15 May 2015 at 16:41, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:38 PM, Dave Cramer p...@fastcrypt.com wrote:
I don't really want to take a violently strong position on this
without understanding
On 16 January 2015 at 01:33, Noah Misch n...@leadboat.com wrote:
On Thu, Jan 15, 2015 at 09:24:01AM -0500, Robert Haas wrote:
On Thu, Jan 15, 2015 at 1:04 AM, Noah Misch n...@leadboat.com wrote:
On Wed, Jan 14, 2015 at 04:48:53PM -0500, Peter Eisentraut wrote:
What I'm seeing now is that
Since we already do escape processing much like c that might not be so
complex. However I haven't looked at the code, so I could be way off base.
The question I would pose is how palatable is it to use ? In other words is
it worth pursuing ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http
happens prior to bind
parameter detection so I'm not sure what a good patch would really look
like, but given the feedback provided here, it's worth investigating.
Kris Jurka
Would this be an postgresql specific escape sequence ? I don't think the
spec allows for this does it ?
Dave Cramer
That would seem to be the implication. JDBC wouldn't really know anything
about hstore.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Feb 8, 2013 at 12:51 PM, Andrew Dunstan and...@dunslane.net wrote:
On 02/08/2013 12:41 PM, Kris Jurka wrote:
On Fri, 8 Feb
On Tue, Apr 10, 2012 at 11:25 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
... We have to invoke java and there
are two basic ways to tie into the java runtime: one is to jump
through SPI via the SQL executor. The other is JNI into the pl/java
jvm which I
How will the user access this? Will it be a normal query through the
existing API ? Will it be a private postgresql API ?
How will they set it up ? It appears complicated as you have to setup
PL/Java as well
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Apr 9
On Mon, Apr 9, 2012 at 11:55 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Apr 9, 2012 at 10:47 AM, Dave Cramer p...@fastcrypt.com wrote:
How will the user access this? Will it be a normal query through the
existing API ? Will it be a private postgresql API ?
How will they set it up
On Mon, Apr 9, 2012 at 12:45 PM, Andrew Dunstan and...@dunslane.net wrote:
On 04/09/2012 12:14 PM, Dave Cramer wrote:
So I'm confused, once they link a file to an FDW can't you just read
it with an normal select ?
What additional functionality will this provide ?
I'm confused about
Hi Atri,
Is there some JDBC API that supports this in newer versions of the API ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Sat, Apr 7, 2012 at 7:07 AM, Atri Sharma atri.j...@gmail.com wrote:
Hi All,
I submitted a GSoc application yesterday. Please review
Someone has approached the JDBC list to do some work on the driver as
a GSOC project.
I need to know what is involved in mentoring and how to get the
project approved
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers
benefits
in some workload, so we are interesting in development.
Regards,
Oleg
So where do we go from here ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, 6 Jan 2012, Andrew Dunstan wrote:
On 01/06/2012 12:32 PM, Dave Cramer wrote:
I've been asked by someone
Well I've sent Teodor a personal email asking him if he was interested
and so far no response, so I interpret that as he no longer has
interest in the project.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Jan 6, 2012 at 12:40 PM, Andrew Dunstan and...@dunslane.net
I've been asked by someone to support pgshpere.
It would appear that the two project owners are MIA. If anyone knows
different can they let me know ?
Does anyone have any objection to me taking over the project?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via
I've been asked by someone to support pgshpere.
It would appear that the two project owners are MIA. If anyone knows
different can they let me know ?
Does anyone have any objection to me taking over the project?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via
I have a need to test timeouts in JDBC, is there a query that is
guaranteed not to return ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Get the following error
configure:3274: ccache gcc -V 5
llvm-gcc-4.2: argument to `-V' is missing
should be
ccache gcc -v 5
Dave
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On Wed, Sep 7, 2011 at 11:16 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
Get the following error
configure:3274: ccache gcc -V 5
llvm-gcc-4.2: argument to `-V' is missing
should be
ccache gcc -v 5
That's not an error, that's normal behavior.
Mind you, I
On Wed, Sep 7, 2011 at 11:32 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
Well the problem is that buildfarm can't build HEAD on OS X 10.7.1
HEAD builds fine on my 10.7.1 laptop. If you're referring to orangutan,
it's not failing on that, it's failing here
. Will be even better if we get all clients using it.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
data from the information_schema ?
2) If so why doesn't psql use these tables ?
Ultimately my ulterior motive is to make sure the information schema
is actually useful and ensure that it maintains that status.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql
Marc,
Please just send a cvs context diff from HEAD to the JDBC list.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
2011/5/17 Marc-André Laverdière marc-an...@atc.tcs.com:
Hello developers,
My project had a requirement to use certificate authentication to the PG
the client encoding is unicode.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, Apr 18, 2011 at 11:14 AM, Mike Fowler m...@mlfowler.com wrote:
On 18/04/11 15:57, Tom Lane wrote:
Bernd Helmlemaili...@oopsware.de writes:
If i am reading it correct, it reads UTF8 from the backend, while
expecting UNICODE only. Not sure what change has caused this,
though.
I am
On Mon, Apr 18, 2011 at 11:24 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
On Mon, Apr 18, 2011 at 10:57 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I wasn't aware that JDBC would fail on that. It's pretty annoying that
it does, but maybe we should grin and bear
as seen below create tablespace does not throw an error or appear to
do anything other than register the tablespace.
postg...@db01:~ less /opt/pg/data/jnj_indexes/PG_VERSION
8.4
postg...@db01:~ /opt/pg91/bin/psql -p 5433
psql (9.0.1)
Type help for help.
postgres=# select version();
On Mon, Oct 18, 2010 at 11:37 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
as seen below create tablespace does not throw an error or appear to
do anything other than register the tablespace.
I suspect this behavior is partially intentional, because tablespace
On Mon, Oct 18, 2010 at 2:20 PM, Bruce Momjian br...@momjian.us wrote:
Alvaro Herrera wrote:
Hi Dave,
Excerpts from Dave Cramer's message of lun oct 18 12:23:40 -0300 2010:
as seen below create tablespace does not throw an error or appear to
do anything other than register the tablespace.
On Mon, Oct 18, 2010 at 2:39 PM, Bruce Momjian br...@momjian.us wrote:
Dave Cramer wrote:
On Mon, Oct 18, 2010 at 2:20 PM, Bruce Momjian br...@momjian.us wrote:
Alvaro Herrera wrote:
Hi Dave,
Excerpts from Dave Cramer's message of lun oct 18 12:23:40 -0300 2010:
as seen below create
On Mon, Jun 7, 2010 at 8:30 PM, Takahiro Itagaki
itagaki.takah...@oss.ntt.co.jp wrote:
Dave Cramer p...@fastcrypt.com wrote:
I noted on line 169 that max_avail is still an int ? Where else would
it be having problems ?
It should not a problem because the local variable only stores byte
I noted on line 169 that max_avail is still an int ? Where else would
it be having problems ?
Dave
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Tom Lane wrote:
Dave Cramer p...@fastcrypt.com writes:
Recently openssl has been patched to not renegotiate keys.
http://www.links.org/?p=780
After a certain amount of data has gone through a postgresql connection
the server will attempt to switch session keys.
What is the workaround
On Fri, Nov 27, 2009 at 4:58 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
Tom Lane wrote:
The discussion I saw suggested that you need such a patch at both ends.
and likely requires a restart of both postgresql and slony afterwards...
Actually,
Recently openssl has been patched to not renegotiate keys.
http://www.links.org/?p=780
After a certain amount of data has gone through a postgresql connection
the server will attempt to switch session keys.
What is the workaround (if any ) to avoid this in postgresql ?
Dave
--
Sent via
Tom Lane wrote:
Dave Cramer p...@fastcrypt.com writes:
Recently openssl has been patched to not renegotiate keys.
http://www.links.org/?p=780
After a certain amount of data has gone through a postgresql connection
the server will attempt to switch session keys.
What is the workaround
I am trying to move a db from one machine to another.
pg_standby applies all the logs fine, then I trigger it and this
happens ???
2008-11-05 11:43:45 EST [14853] LOG: restored log file
000316ED007E from archive
2008-11-05 11:43:45 EST [14853] LOG: selected new timeline
Tom,
On 5-Nov-08, at 12:21 PM, Tom Lane wrote:
nvalid argument?? On the platforms I have handy, the only documented
reason for open(2) to fail with EINVAL is illegal value of the flags
argument, which should be impossible. What platform is this and what
wal_sync_method are you using?
Red
On 5-Nov-08, at 1:00 PM, Tom Lane wrote:
I wrote:
Huh, is it possible that Linux rejects O_SYNC for a file on ramdisk?
I found this in the Fedora 9 manpage for open(2):
O_DIRECT support was added under Linux in kernel version
2.4.10. Older
Linux kernels simply ignore this
I have a client who mistakenly gave the postgres user on a windows
machine admin privileges.
This mistake results in the service being unable to start up due to
postgres refusing to start with admin privileges.
The error message from pg_ctl start -D bindir is PG_CTL..could not
locate
On 21-Oct-08, at 5:24 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
I have a client who mistakenly gave the postgres user on a windows
machine admin privileges.
This mistake results in the service being unable to start up due to
postgres refusing to start with admin privileges
After terminating recovery mode by creating a trigger file postgres
starts up and complains about missing WAL files in pg_xlog; The last
two which were replayed. Is this normal ?
Dave
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Mon, Aug 25, 2008 at 1:07 PM, Dave Cramer [EMAIL PROTECTED] wrote:
On 25-Aug-08, at 10:43 AM, Alvaro Herrera wrote:
Dave Cramer wrote:
Well, I go the extra mile and kill any remaing autovac procs
Here are the logs
2008-08-25 04:00:01 EDT [32276] LOG: autovacuum launcher shutting
On Tue, Aug 26, 2008 at 9:37 AM, Alvaro Herrera
[EMAIL PROTECTED]wrote:
Dave Cramer wrote:
Ok, here are the logs from last night
2008-08-26 04:00:02 EDT [25407] LOG: received SIGHUP, reloading
configuration files
2008-08-26 04:00:02 EDT [22649] LOG: autovacuum launcher shutting
1 - 100 of 365 matches
Mail list logo