1 PDT LOG: record with zero length at 1C5/95D2FE00
Now I'm running Ubuntu 12.04 LTS (Precise) with openssl 1.0.1, and I
think all the known renegotiation issues have been dealt with. I still
get failures, but they are less informative:
2013-03-15 03:55:12 UTC LOG: SSL
renegotiation f
we need is for pg_dumpall to _not_ output those handlers.
Or pick it up in the check stage and make the user resolve the
problem. If I shot myself in the foot in some particularly obtuse way,
it might not be sane to bend over backwards making pg_upgrade repair
things.
--
Stuart Bishop
http://
pm or 7pm depending on the policical edicts.
If you are only storing past events, its not normally an issue but
timezone information does occasionally get changed retroactively if
errors are discovered.
--
Stuart Bishop
http://www.stuartbishop.net/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
hose keys being reused by accounts that
shouldn't be reusing them. Please don't deprecate it unless there is
an alternative. And if you are a pg_pool or pgbouncer maintainer,
please consider adding support :)
--
Stuart Bishop
http://www.stuartbishop.net/
--
Sent via pgsql-hackers mai
s). There was some flak but
we are still here.
I personally suspect PostgreSQL would want a 1 year cycle for major
releases while a full dump/reload is required for upgrades. When this
changes, 6 or even 4 months might actually be a good fit.
--
Stuart Bishop
http://www.stuartbishop.net/
might end up to a similar process to GNU
Bazaar except with yearly major releases and 2 month development
releases, documented at
http://doc.bazaar-vcs.org/latest/developers/cycle.html. This is a
smaller project, but had to address a number of similar concerns that
PostgreSQL would have to so may b
ain(pg, i):
return i
$python$;
Thoughts? [...it still has a *long* ways to go =]
I tend to dislike magic function names, but perhaps it is the most usable
solution.
--
Stuart Bishop
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
ption to be raised personally.
> I'm ok with returning NULLs as well, but returning zeroes doesn't feel
> right.
--
Stuart Bishop
http://www.stuartbishop.net/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
return zeroes (or perhaps
> nulls?). Neither one is tremendously appetizing. The former would
> be especially unhelpful if someone tried to write a query to apply
> pgstattuple across all pg_class entries, which I kinda suspect is
> what Stuart did.
This is exactly what happened, and tempo
Thank you, I'm also curious as to whether the data folder is already in some
way encrypted and if so, what encryption/obfuscation is being used. There
doesn't seem to be anything about this on the web.
I am setting up a postgres database on a standalone system with a randomized
text password. However, the db will contain very sensitive data and my boss
is worried about the possibility of someone being able to crack the db data
if they stole the machine. Can anyone point me to information about ho
tgres -22 -2 4896K4K mclpl 0:11 0.00% 0.00%
I'm not convinced this is a postgresql bug (state=mclpl concerns me),
but it's the first time I've seen it. I suppose it could be:
http://www.netbsd.org/cgi-bin/query-pr-single.pl?number=35224.
Anything I can do whi
applied the patch and have started my test again, it takes a
little while to fill up so I should have the results sometime tomorrow.
Thanks for the quick response.
Stuart
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
From: Alvaro Herrera
> Decibel! wrote:
> > Moving to -hackers.
> >
> > On Jul 27, 2007, at 1:22 PM, Stuart wrote:
> >> Does Postgresql have a function like ascii() that will
> >> return the unicode codepoint value for a utf8 character?
> >> (And
t;
> There is a pg_backend_pid() function, even if it's not documented with
> the other functions (it's in the stats function stuff for some reason).
eh. No worries - my safeguard is just a comment saying 'don't connect to the
same database you are
Tom Lane wrote:
> Stuart Bishop <[EMAIL PROTECTED]> writes:
>> After a test is run, the test harness kills any outstanding connections so
>> we can drop the test database. Without this, a failing test could leave open
>> connections dangling causing the drop database to
Mark Shuttleworth wrote:
> Tom Lane wrote:
>> (1) something (still not sure what --- Martin and Mark, I'd really like
>> to know) was issuing random SIGTERMs to various postgres processes
>> including autovacuum.
>>
>
> This may be a misfeature in our te
same purpose, to force
thing to disk when we consume enough RAM.
---
Bruce Momjian wrote:
Stuart, were are on this patch? Seems we need GUC additions, though I
can do that for you, and changes to write the head to disk. Was
Also I've noticed that there is an fd.h which has file routines which I
should be using rather than the stdio routines.
I will also clean up those errors.
Thank you,
- Stuart
---(end of broadcast)---
TIP 6: Have you searched o
Title: RE: [CYGWIN] command
Florian Litot wrote:
> what is the command to launch a sql script not in psql thanks
>
>
psql is used to execute sql scripts as follows:
psql -f
hth,
- Stuart
Title: RE: [HACKERS] tell Bugtraq about 7.2.2
oops, sorry your correct.
- Stuart
> -Original Message-
> From: Gavin Sherry [mailto:[EMAIL PROTECTED]]
> Sent: 28 August 2002 15:57
> To: Marc G. Fournier
> Cc: Henshall, Stuart - WCP; '[EMAIL PROTECTED]'
>
Title: RE: [HACKERS] tell Bugtraq about 7.2.2
No idea sorry :(
- Stuart
> -Original Message-
> From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
> Sent: 28 August 2002 15:36
> To: Henshall, Stuart - WCP
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: [HACKE
Title: tell Bugtraq about 7.2.2
Does someone from core want to inform bugtraq about 7.2.2?
Cheers,
- Stuart
Westcountry Design & Print,
Heron Road, Sowton, Exeter.
EX2 7NF - also at -
17 Brest Road, Derriford,
Plymouth. PL6 5AA
England
www.westcountry-design-print.co.uk
x27;d know the primary key already existed and if rc=1 then it
would have inserted succesfully
- Stuart
"Haoldo Stenger" wrote:
> "Matthew T. O'Connor" wrote:
> >
> > > A solution, could be to query for the existance of the PK, just before
> the
>
ervice. There's a slight hiccup
on shutdown meaning that the postmaster.pid file gets left. This is due to
sighup being sent by windows shutdown. I think current cygwin snapshots
might cure this, otherwise there is a patch some where that causes SIGHUP to
be ignored. I *think* the pre-built binary already has this patch applied.
- Stuart
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ld have to be
placed into the OID in all places it could be referenced (for WHERE
clauses,etc...). It'd only work on those tables that had int4 priamary keys,
but I suspect thats a fair few. I don't know wether this'd be worth while,
but was rather throwing it out for thought.
- Stuart
Would it be possible to offer an option for the OID column to get its value
from an int4 primary key (settable on a per table basis maybe)?
- Stuart
> -Original Message-
> From: Hiroshi Inoue [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, July 21, 2001 7:31 AM
> To: Zeugswette
Don't know about JDBC, but couldn't you just use UPDATE SET
= WHERE xmin= AND primarykey= and
get the number of altered records? (if its zero then you know somethings
wrong and can investigate further)
- Stuart
> -Original Message-
> From: Dave Cramer [SMTP:[EMAIL PR
Apologises if I've missed something, but isn't that the same xmin that ODBC
uses for row versioning?
- Stuart
> Currently, the XMIN/XMAX command counters are used only by the current
> transaction, and they are useless once the transaction finishes and take
>
n the download directory it was not
imediatly obvious there was one main tarball and the rest where a split
version rather than a main one with optional stuff (which is not my favoured
option).
This is all just in my opinion of course.
- Stuart
---(end of broa
30 matches
Mail list logo