better way is to use
the session_replication_role feature. See:
http://blog.endpoint.com/2015/01/postgres-sessionreplication-role.html
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201502271149
http://biglumbe
ased, not statement at all. It stores up
a list of affected rows, then COPYs those from the source databases
to the target ones. It's particularly strong when you have large
delays and many updates to the same row.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.end
ed, then try again. If you don't know which tables are being used,
I suggest storing that somewhere your class can find it, or moving away
from such a generic class.
There are other solutions (e.g. forcing conflicting processes to quit
and sleep a second), but the locking one seems the
uld be improved.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201507270953
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlW2OAEACgkQvJuQZxSWSsj1CgCeKU8QO2dEHgBV6Su9D2eJmIss
MT
so:
https://www.mediawiki.org/wiki/How_to_become_a_MediaWiki_hacker
https://phabricator.wikimedia.org/T2384 (Postgres support tracking)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201607191015
http://biglumber.com/x/web?pk=2529DF6AB8F79407E944
. :)
What really bites is the analyze afterwards. That's the part
that takes too long (yes, --in-stages helps some). Would love
to see progress made there.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 20160727222
by 1 limit
%s) TO STDOUT' | psql testdb -c 'COPY %I FROM STDIN' $$, table_name, 100,
table_name)
from information_schema.tables where table_schema = 'public' and
table_type = 'BASE TABLE';
psql> \q
$ sh dump.some.rows.sh
- --
Greg Sabino Mullane g...@turn
d envision some workarounds, but it
really depends on exactly what the OP is trying to achieve.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201610191401
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGI
cool to have it
> directly in Perl.
Well if you end up writing something, please throw it into CPAN so we
can all benefit. :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201701021822
http://biglumb
this same thing recently. I disagree that
it is a waste of time, but I'm happy if we get one, regardless
of different people's rationales for it.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201601051213
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B90671496
own.
Needed? I know part of a code of conduct is stating the obvious, but...
> 6. The CoC is not about Social Justice.
Really no need for this. Defensive, and introduces a loaded term.
Thanks, JD, for pushing this forward.
- --
Greg Sabino Mullane g...@tur
fforts in this.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201601181316
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAladLAkACgkQvJuQZxSWSsjOZwCgqKxe5Uw9ujJIwCzWj4YHfVm9
etQAmwa1R5P8iPONXCgV9OMDiAaaTu/5
=awg
ts. I think this may indeed be one of those times
that we do not attempt to "roll our own". Or at the very least, we should
strive to understand how other communities arrived at their Codes and
why it is working for them.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key
pearance of
nested loop *earlier* a few days.
Changing cpu_tuple_cost moves it forward a bit, but not enough to cover the
actual use case (now() - 1 month).
Leaving out the 'analyze' results in a much better plan, but having the tables
stay unanalyzed does not seem
like a
f this issue pops up anywhere else. Leaning towards the latter,
as I'm sure the planner *usually* does better with all options enabled. :)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
then you can use pg_dump | psql for the rest.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201605272040
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Which list is the most appropriate for proposing features
> and ideas for postgres ?
Generally, -general. If the proposal is very technically specific,
you might prefer -hackers instead.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
P
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Anyone have an implementation of the Jaro Winkler fuzzy string
> matching algo for Postgres?
I've not seen one, but it should be a Simple Matter of Programming
to whip something up in Perl or C.
- --
Greg Sabino Mullane [EMAI
27; => '2007-07-06 20:07:53.22277-04',
'query_start' => '2007-07-06 20:08:15.37116-04',
'client_port' => '-1',
'client_addr' =&
e this plperl example:
http://people.planetpostgresql.org/greg/index.php?/archives/2007/05/30.html
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200707070745
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIG
create a second one
by calling DBI->connect.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200707181533
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFGnmspvJuQZxSWSsgRAxjIAJ0TRN5bTs9s1/Z3/YC/
dn't use unsigned int or
unsigned long int here, both for ntups and the return value of the
function.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200707300937
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC
tica".
That name could be confusing - what about the people out there
who would be wondering if we'd support SQL or not? The name
should definitely be "HorizonticaSQL"
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200709081522
http://biglumber.com/x/web?pk=252
" sync (master-master). If the rows truly
do not overlap at all (by PK), you may also be able to set it up as a
dual "pushdelta" (master->slave both ways).
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200
and fire off the sync when asked to. You
could even run a single Bucardo instance on the home and toggle the
databases from "active" to "inactive" status in the bucardo.db table.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 2007101511
way to do it (we don't have finer-grained control than
the 'require' opcode), but we could probably dial back restrictions,
'use' it, and then reset the Safe container to its defaults. Not sure what
other problems that may cause, however. CCing to hackers for discussion
the
have two processes
sharing a handle.
Note also that InactiveDestroy should not be your first choice. Far
better to do the forking before the database connection whenever possible.
If they both need access, you can also disconnect, fork, and have both
reconnect afterwards.
- --
Greg Sabino M
thing like //i
shouldn't suddenly fail just because you added an accented
character. The other part of me says to just have people use plperlu.
At the very least, we should probably mention it in the docs as
a gotcha.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End P
re questions, bearing in mind that "replication" is
a fairly generic term with no one-size-fits-all solution.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200711160922
http://biglumber.com/x/web?pk=2529DF6AB8F79407E9444
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Just as a followup, I reported this as a bug and it is
being looked at and discussed:
http://rt.perl.org/rt3//Public/Bug/Display.html?id=47576
Appears there is no easy resolution yet.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key
essage. It got caught
up in a rule which prevents mail with subjects such as "subscribe"
or "help" from being sent to the main list without moderation.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200711291651
http://biglumber.com/x/web?pk=2529DF6AB8F79407E
uing Oracle and Microsoft because of their products, and companies have
no expectation of doing so. It might be nice if they did, and some theorize
it would lead to better and more secure products, but the reality is that
with software, you are on your own. Any company telling you otherwise as
a re
ntuitive. I think having
psql recognize /^help/i would be a nice first step. Hmm, off to
write a quick patch...
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200801201225
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B9067149
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I now want to have this database or all tables capable of read-only.
ALTER DATABASE foo SET default_transaction_read_only = true;
Easy to work around, but may be good enough for your purposes.
- --
Greg Sabino Mullane g...@turnstep.
es or simply increment the values in the table itself
like a version control number).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201012100942
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94
n for
this is that the pg_controldata check is "good enough". Certainly,
that's what we are using for many clients via check_postgres, and
it's been very good at detecting when the replica has problems. Good
enough that I've never worried about writing a different method
at
already exists, not the xtmp_changed_ids TABLE. If it was the
table, we'd presumably see the ERROR appear before the
NOTICE (as the table is created first, and then the indexes).
Thus, make sure you don't have an index named xtmp_changed_ids
somewhere already: \di xtmp_c
#x27;s going on. Feel free to forward me those headers
(offlist) and I'll try to get you unsubscribed.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201012221216
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906
list the first bloated table and stop.
No, it will show all tables over the given threshhold. However, the
statement "the other tables must be OK" is definitely not a given,
as the bloat calculation used by check_postgres is a very rough one.
- --
Greg Sabino Mullane g
id this fail? This should absolutely disable all
triggers for you, unless you've mucked with the triggers
and set them to replica.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201102171053
http:/
iple transactions.
If this is a script you are feeding directly to psql, you can
also add a BEGIN; at the top or just use the -1 argument.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 2011021715
:';
INSERT INTO def(b) VALUES (1);
SET session_replication_role = replica;
SELECT 'No error:';
INSERT INTO def(b) VALUES (2);
SELECT * FROM def;
ROLLBACK;
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key
happening.
Most likely session_replication_role is not getting set or
is getting reset somewhere.
- --
Greg Sabino Mullane g...@endpoint.com g...@turnstep.com
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 201102172155
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC
SELECT * FROM def;
ROLLBACK;
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201102180938
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1ehJEACgkQvJuQZxSWSsj
narrowed:
> INSERT 0 1
This shows the session_replication_role is working as it should. Double
check where and how you are setting it; your foreign key problems
will go away once it is set correctly.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.co
ase could be very bad.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201102181408
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1ew9MACgkQvJuQZxSWSshETwCg2oE
replica;
> pro-# \o db.out
> pro-# \i dump.txt
This is a database set, not a psql on, so you do not want the
backslash before the "set".
SET session_replication_role = replica;
I'd recommend adding a:
SHOW session_replication_role;
to the dump.txt as a sanity check.
- --
(CPAN bug #61713) [GSM]
- Fix failing test when run as non-superuser [GSM] (CPAN bug #61534)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgp7dOKYW9uya.pgp
Description: PGP signature
ur
layout, usage pattern, network speeds, etc.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201408240939
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlP5/9
lly given the tradeoff
in complexity. Still, if the majority of the time is spent moving old
data from one or more tables, you could exclude those from the pg_dump
with -T, then copy over some small subset of the table with a pair of
COPY commands from prod to dev.
- --
Greg Sabino
binK_rPgnIklP.bin
Description: charset
little
more involved. See:
http://www.postgresql.org/docs/9.2/static/plperl-under-the-hood.html
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201303271036
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906
d if you have a dump from 9.1 or older, you can use this script
to divide it up into the same sections:
http://bucardo.org/wiki/Split_postgres_dump
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201304081134
ser functions some brains, such that
they will not execute when session_replication_role is set to 'local', for
example.
While I do think session_replication_role needs some more granularity, it's
also a little hard to say more without knowing your exact requirements.
- --
Greg Sabi
numwords(int)
> returns text
> language plperlu
> immutable
> as '
> use Lingua::EN::Inflect qw( NUMWORDS );
> return NUMWORDS(shift);
> ';
> eot
CREATE FUNCTION
$ psql -tc 'select numwords(1234)'
one thousand, two hundred and thirty-four
o from Postgres to Oracle.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201308262157
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlIcB6AACgkQvJuQZx
ical copy
of the affected tables (i.e. with indexes) but just a data-only copy:
create table dev.users as select * from public.users;
pg_dump herokudb --schema-only | psql devdb
pg_dump herokudb --data-only -T public.users | psql devdb
psql devdb -c 'insert into public.users select * from dev.user
d skills
to get a new release out (myself, Andrew D., Peter E., probably others).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201710150923
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
--
er of rows deleted, you should also:
vacuum full bucardo.syncrun;
The data in that table is not critical to Bucardo running - it is mostly
used for the output of "bucardo status" and for auditing of past syncs.
P.S. Bucardo has its own mailing list: bucardo-gene...@bucardo.org,
which in gener
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Alvaro Herrera asked:
> Is there an existing Postgres group?
Yes, this one:
http://www.linkedin.com/e/gis/41621/0F3C7A53CCD6
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200802032251
http://biglumber.com/x/web
- Fix bad PG_INTEGER example in docs, thanks to Xavi Drudis Ferran.
(CPAN bug #31545) [GSM]
- Fix META.yml file. (CPAN bug #25759) [GSM]
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200802111802
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BE
mention that we are disabling all the triggers on
> a given table only done during a transaction; thus, it affects no
> one else.
Be careful: if you are directly manipulating the system tables,
you still run the risk of problems as the system tables are
not completely MVCC safe unless you lock them.
l, it /is/ problematic, especially for those that don't know Perl well,
but doc patches are welcome. :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 20080336
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN
but does not need perl_setup().
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200803121042
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkfX6+0ACgkQvJuQZxSWSsiFdQCg4WGmB4+InrL7E+7c8Tq82lFy
TFcAn2lQfSXJwO8LUQ9vZPf9ZStLdVHW
a TODO to figure out some cleaner way of handling this sort
> of thing ...
I think I smell a GSOC project
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200803121533
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B9
break at some future major version with lots of prior warning.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200803271839
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkfsIosACgkQvJuQZxSWSshqnQCg0s7YAnxtF6qbOEiYYBifCR
; "proper" way to do this.
See the new new session_replication option:
http://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-SESSION-REPLICATION-ROLE
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200804022021
ht
s (I'm converting from 7.4.19 to 8.3.1),
> so apparently I'm missing something.
You want: SET session_replication_role to 'replica';
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200804091058
http://biglumber.com/x/web?pk=2529DF6AB8F79407E944
CE: I am trigger two
psql:trig.example:53: NOTICE: I am trigger three
UPDATE 1
ALTER TABLE
ALTER TABLE
psql:trig.example:59: NOTICE: I am trigger one
psql:trig.example:59: NOTICE: I am trigger three
UPDATE 1
SET
psql:trig.example:63: NOTICE: I am trigger one
psql:trig.example:63: NOTICE: I a
.
http://www.bucardo.org/bucardo.html#BucardoConflictHandling
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200804161143
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkgGHogACgkQvJuQZxSWSshdAACg6
wikimedia.org/enter_bug.cgi?product=MediaWiki
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200805301532
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkhAVk0ACgkQvJuQZxSWSshAQwCeOKq4OHXrCPbjC6ATtfncA7Wq
v2oAnR9k/ME
h the
tsearch2 compatibility stuff. I'm creating some workarounds, and
will report back. Doing a --data-only dump and creating the schema
anew from maintenance/postgres/tables.sql should work, although
not if you've made any schema changes, obviously.
- --
Greg Sabino Mullane [EMAIL PROTEC
/Manual:Upgrading_Postgres
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200806041024
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkhGpcAACgkQvJuQZxSWSsgcPACgqDlcqt4dxfgwRfyehMuBy0lZ
b9sAnjBax4Na
ally good master-multislave) you
can evaluate (and get support for) Bucardo:
http://bucardo.org
As with all replication systems, there are some things it does better
than other systems (i.e. MySQL's), and some things it does worse.
- --
Greg Sabino Mullane g...@turnstep.com
End Poin
(and creating a savepoint for every execute
attempt), and silently encouraging SQL that will fail when fed to Postgres
through any other interface.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200907141125
http://biglumber.com/x/web?pk=2529DF6AB8F
uncer, spread the
tables and indexes across different tablespaces, and other tricks. If
money is tight, you might look into using something like EC2.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200907141552
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B
so. Perhaps you can attack
this from another angle, such as using some sort of filter or script
to grab every X lines from the logs and discard the rest while in
full logging mode. That would have the advantage of being fully
backwards-compatible and usable today.
- --
Greg Sabino Mullane
replication sense, but
if you have sites that are flaky, you might want to look at Bucardo:
http://bucardo.org/
It does master->slave (like Slony), but also does master<->master if
you need it.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8
sequence is
getting near its maxvalue, and thus have an idea of when it is about
to cycle. The check_postgres program can do this for you:
http://bucardo.org/check_postgres/check_postgres.pl.html#sequence
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 2009
e a real
crash, you should do a real crash. In this case, kill -9 the backend(s).
A server crash is a pretty rare event in the Postgres world, so I
would not spend too many cycles on this...
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200908
at some EDB people - did that ever happen?
I seem to recall we fixed that particular problem as well
during the codeathon at OpenSQL Camp.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200909102039
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B9067
for a flag to pg_dump to
exhibit the behavior you want. It has a small chance of being accepted,
but a much greater chance than changing the default behavior.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200910251638
http://biglumbe
ies".
Bucardo and Slony are both table-based and trigger-driven.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201312100859
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
ce or SystemTap.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201402081451
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlL2itEACgkQvJuQZxSWSshlIgCgo+jkIYojwc23O4jw
e request
for 10,000 rows to libpq rather than call PQgetResult 10,000 times, but
we'll move ahead with implementing RowCacheSize via PQsetSingleRowMode.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201404021428
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC
d
in such a bug.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201404171231
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlNQAe8ACgkQvJuQZxSWSshObwCglozBhwT4ddf7XacITK
hen the
postgresql.conf is created via initdb.)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201404181453
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlNRdVkACgkQv
an't promise it will work with recent versions
of MediaWiki, but should be enough to get you started testing.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201104261344
http://biglumber.com/x/web?pk=2529DF6AB8F79407E944
nsions
is hit or miss because MediaWiki was a MySQL only shop for so long
(and Wikimedia still uses it, and they influence a lot of the MW
development).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201104261505
der verison of ExtUtils::MakeMaker.
DBD::Pg 1.49 is pretty old, but the good news is that nearly every
other repo in the world has a newer version, and that it has very
few dependencies if you want to install it manually.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201105
, no?
> [1] The code is still hanging around somewhere, I think, mostly
> as an example of what not to do.
Heh, I gotta look that up someday.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201105082255
http://biglumber.com/x/
rks just fine, as long as you are not expecting the
servers to give the exact same answer at the exact same time. But certainly
transactions are "valid".
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 20110508
he child creator and the parent deleter receive back a "ok commit". If you
have a very large async response time, and your application has a very tight
control over things, it may cause a problem, but in real life the syncing
happens quite quickly, and the window for even catc
n do this easily in trusted perl:
CREATE OR REPLACE FUNCTION findos()
RETURNS TEXT
LANGUAGE plperl
AS $$
return $^O;
$$;
SELECT findos();
findos
- ----
linux
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106130831
http://big
o LISTEN
that said "I only want to hear notices coming from superusers"?
Or perhaps an option that says "I only want to hear notices
coming from me (same role)"? This would not affect notifications
at all, but would simply act as a quick filter on incoming
notice
C or just a weird entry on an existing one,
like ssl_renogiation_limit = 543210).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106211944
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
--
er exposed to anyone else. Thanks, I think
that neatly solved the problem. (which wasn't too much of a problem,
more an idle thought).
- --
Greg Sabino Mullane g...@endpoint.com g...@turnstep.com
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 2
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> You mean I don't get my money back if I don't like it??? :-)
Are you kidding? You get *twice* your money back, and you
get to keep the product!
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endp
ly if you are using psql in
interactive mode. In other words, we already have an elegant and
lightweight approach to the described problem.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201206191146
ht
s against our
philosophy of being safe, careful, and correct.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201206200945
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEY
1 - 100 of 276 matches
Mail list logo
