nprintable
> characters
> as question marks or something?
Not to my knowledge, although I'd expect the terminal driver to have
control over this, no?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
wise to store the
string with a language tag so that you can apply the right rules later
on. See RFC 5646 (http://www.rfc-editor.org/rfc/rfc5646.txt) for some
pointers. If just "stripping accents" is good enough for you, then
the unaccent dictionary will probably be good enough.
A
--
the table remains static
> between vacuums), but we're still too busy for that right now
> (unless you tell me I'm going to see a night-and-day difference
> regarding this particular issue).
I think it might be more "dusk and day", but I have had very
impress
er things in the disk cache. In
the second example, though, with a lot of read-only activity all the
time, the things that are most popular are likely to remain in a
(modern) disk cache most of the time because they're called so often
that the vacuumed page doesn't end up being enou
sted in funny ways in Win 7.)
Because all wire protocols from the IETF use UTF-8 for Unicode
encoding, your best bet is still UTF-8 for maximal portability, so
your point about needing to make the database encoding and client
locale UTF-8 is correct.
Best,
A
--
Andrew Sullivan
a...@crankycanuc
your choice. If you want an
editor that knows more about what you want than you do, I think you
will find it is spelled "emacs".
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s the very
first record. See the discussion of windowing functions in the manual
for how to do this.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ause the kind of pressure we were
under at the time was pretty much exactly as you're describing.
Good luck.
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
r it more suitable for the
embedded market.
The Gartner report itself was controversial: ISC, who also promised to
use PostgreSQL for its back end, got a lower grade on the back end
than did Afilias.
Anyway, this is all an amusing walk down memory lane. Thanks for the
reminder!
Best,
A
--
A
unless Afilias has changed their
implementation very dramatically (and I've no reason to believe they
have), you could not get to any web site ending in .org (or, for that
matter, .info, .in, .aero, .mobi, and a number of others) without the
services of PostgreSQL.
Best,
A
--
Andrew
did not buy UltraDNS. Neustar, who run .biz and .us, bought
Ultra. Afilias does not use any Ultra servers in its systems, and
hasn't since before I quit working for Afilias.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
mentation of the IP layer appears to give you an IPv6 address
from one perspective and not from another. The application (Postgres
in this case) can't fix this.
Best,
A
--
Andrew Sullivan
a...@anvilwalrusden.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
h 5 years' Postgres experience, well, come to this list
:) The shallow pool of qualified Postgres admins remains one of the
costs of using Postgres today: you add cost to your administration. I
think the cost is worth it, note.
Hope this is helpful. Good luck,
A
--
Andrew Sullivan
a...@cra
nstance?
If not, then you're not really language unaware, but instead
constrained by a subset of languages. That is a more tractable
problem (for instance, you may not have to worry about direction
changes, which vastly simplifies the problem).
Best,
A
--
Andrew Sullivan
a...@crankycanuck
rk. If not, well,
"internationalization is hard." :-/
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
le have
rough ideas of what they're entering, and they need an exact match.
You have the good fortune of being able to provide them with a hint!
I wish I were in your shoes.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
der if you want one.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
derlying details require
more work on the part of the person using the general-purpose
software. That's what optimizing for general cases buys you.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
INTO sale $bunch of stuff;
INSERT INTO xact_log $stuff-with-money-deducted;
UPDATE account SET balance = balance-?COST WHERE customer_id = ?ID;
---ERROR here for no permission
COMMIT;
Or anyway, that's how I look at it.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql
do it?
> Let's assume you are not using any features in the
> newer version.
> Say from 9.2 to 9.1.
>
> Thanks
>
> H.F.
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
I'm firmly in the camp that says you can write
lousy code in any language.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
sequence.
You can't do that. The ability to specify multiple -t switches came
in 8.2.
You can work around this if you have a custom dump format, by just
restoring the tables you want using pg_restore. This is a pretty
hideous workaround, though.
A
--
Andrew Sullivan
[EMAIL PROTECT
y be in a separate package on Debian.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
erience with a cluster and Slony versus Skytools) is my
> recommendation.
This is probably good advice. For simple cases, Slony's sort of a
pain in the neck.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing
er some time.
You don't even show any evidence here that Postgres is using the
memory. How do you know that?
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
PEs, I'm happy to answer.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
port EDNS0, it's possible you're going
to find that some users can't resolve your names in the near future.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
using the TXT
RRTYPE wasn't such a hot idea. I think it's now 5 years since the DNS
folks pointed out that TXT was going to cause headaches later. Sigh.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing
out of luck
with them. Bert is hostile to it.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ll the data again. You do
need to run pg_dump -s, of course.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
rsonal
experience trying it.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Aug 27, 2008 at 10:40:41PM +0800, Phoenix Kiula wrote:
> Thanks. But there seems to be a tangible slowdown of DB operations
> during the time that pg_dump is running.
Yes. Pg_dump copies all the data out, so it puts load on your
database and disks.
A
--
Andrew Sullivan
ch?
> What am I not doing right?
My bet is that you did initdb on one system with a locale of C and on
another with a locale of utf-8 (somehow). You can use pg_controldata
to find out: run it against the data areas on each system.
If I'm right, then you probably want to run initidb again o
a is utf8-ed, how can I bring it home and have a
> mirror of the db.
If you run iconv on the data dump before you load it, then it should
work. This is not a trivial job, however.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql
hing has to come off
the disk. Does iostat seem to confirm that? Are you swapping, by any
chance?
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
utovacuum. But that's just a guess at the moment.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ast one of the
> vacuums it's working when I see the weekly drop of disk ocupation.
It actually bloats your index and hurts you. Don't do that. If the
number of tuples in your various tables is staying about the same,
your size on disk should stabilise. That's the thing you want
is UTF-8.
What's the database encoding?
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the database encoding is UTF-8, then it's
supposed to be _impossible_ that you get non-UTF-8 data in there.
That's the whole point of having the database encoding.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general
ested? I have no idea if
it's relevant here, but give it a whack. Other than that, I'm not
sure. You might want to troll the release notes to see if there was
an encoding bug fixed in the intermediate releases between
8.2.whatever-you-converted-on and 8.2.current.
A
--
Andrew Sulliva
can't remember whether the client encoding is going to be affected
by this during dump and restore, and whether in these versions that is
captured in the dump file.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general
t LANG
[other stuff]
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
comes with Postgres
(and a release of Postgres well over a year old, at that).
I didn't get any further in reading the claims, because it's obviously
nothing more than a marketing effort using the principle that deriding
everyone else will make them look better. Whether they ha
sons. but you could see for yourself whether the claim is true
that way.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ding" is not automatically necessary to get more
than one processor to work on a single query. But at the moment,
Postgres doesn't do that either.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing l
database product, for instance, has
been struggling for the last several years to turn itself into a
full-featured, high-volume, safe transactional system. But the seams
keep showing, because it just wasn't designed for this workload in the
first place. But it sure is fast out of the
On Tue, Sep 09, 2008 at 05:42:50PM -0400, Greg Smith wrote:
>
> While some of the MonetDB bashing in this thread was unwarranted,
What bashing? I didn't see any bashing of them.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sen
y. They're the sort of thing
that would make auditors happy, and for that reason they might be
worth implementing. So far, I don't believe anyone's had an itch of
this sort strong enough to scratch.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandp
conf file.
Otherwise, Postgres will try to bind to all the sockets. There's
something hinkey about the IPv6 support in AIX, IIRC, so that you end
up with this symptom.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-genera
On Tue, Sep 23, 2008 at 03:36:51PM -0500, Jason Long wrote:
> From what I read Longiste is easy to set up while I got a quote for Slony
> setup for 5-10k.
I can set up Slony for way less than that, FWIW. But Londiste is
intended to be easier to set up than Slony.
A
--
Andrew Sullivan
rs, "compliled C code" is probably good
enough. (Of course, clever non-C code is probably also enough, in my
opinion, but obviously others disagree.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mai
we don't care,
but let's at least be honest that changing the culture of such
database shops is not something we're going to achieve quickly.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-ge
On Thu, Sep 25, 2008 at 01:25:25PM -0700, Casey Allen Shobe wrote:
> Gee, I wonder why companies that support these antics grow to insane
> sizes of employees?
Meetings. Lots and lots of meetings.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprom
On Mon, Sep 29, 2008 at 06:41:33AM -0700, [EMAIL PROTECTED] wrote:
> On 16 sep, 23:04, [EMAIL PROTECTED] (Andrew Sullivan) wrote:
> > Specify the specific TCP/IP interfaces in the postmaster.conf file.
> I have the same pb. I have looked for a postmaster.conf file but there
Doh!
ly that way.
Please note that these are _not_ for production use, and almost
certainly have bugs. They may not be the very latest, either.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
ist headers, which were standardized many years ago. Then you
"reply to list". Mutt has done this for at least a few years now. I
don't know about other MUAs.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general m
in the rules about origin fields and in the potential for
lost functionality. Given the project's goal of SQL conformance, why
would we blow off SMTP standards?
(Anyway, I agree with Tom, so I'm saying nothing more in this thread.)
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 45
here a way of getting around it without going all over
> again and remain with 8.3.1 database where I have already put alot of
> important data.
Why don't you use the latest 8.3.x release? You don't need a dump and
restore to go from 8.3.1 to 8.3.latest.
A
--
Andrew Sullivan
[EMAIL
On Thu, Oct 23, 2008 at 08:24:12PM +0300, Otandeka Simon Peter wrote:
> Upgraded to 8.3.4 but am still getting the same error
So it isn't an error in 8.3.1. But my bet is this:
>
> On Thu, Oct 23, 2008 at 4:35 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote
> >>
ngling has gone on this year alone
over whether the "ß" character (LATIN SMALL LETTER SHARP S) should or
should not be allowed into internationalized domain names.
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list
On Tue, Oct 28, 2008 at 02:25:05PM +0400, Mohd Alkhaldi wrote:
> I've postgres 7.4.21 , is there is any way to archive WAL , I've tried
No.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (
ORAGE with
better granularity.
Indeed, it seems to me that in some ways, the big databases are only
catching up with Postgres now on this front. That alone oughta be
news :)
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing li
his 5 minute delay. There is very little
> concurrency--only a couple of open sessions--when the COMMIT PREPARED
> is issued.
You could be I/O bound. Have a look at iostat and sar.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
2PC is a heavyweight and
expensive system. :-(
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mforting, that.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s will permanently corrupt the data.
I know this partly because of experience with a "failover" system
whose interlocks failed. Two postmasters, one data area, and no
recoverable data.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgre
On Wed, Dec 03, 2008 at 04:23:15PM -0500, Jaime Casanova wrote:
>
> is this true even if one of the server just send SELECTs?
Yep.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On Sun, Dec 07, 2008 at 02:36:56PM -0500, Jaime Casanova wrote:
> Hi,
>
> any one has doing this... is there a good tutorial o directions for it?
The answer to this is highly dependent on the system you're using.
What is it?
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via
rg/docs/9.1/interactive/app-postgres.html
I suspect the line you want is, "To cancel a running query, send the
SIGINT signal to the process running that command."
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
arched a lot didn't find anything related to this, some users
> doing this via trigger like "rubyrep".
>
> is there an easy way to do this? thanks!
Why not adjust the underlying sequences to have different start values
and to advance by 2?
A
--
Andrew Sullivan
a...@cra
efinitely need an ORDER BY category
here, too. Does that make a difference?
You might also want to look at your collation. Sort orders are
notorious for being surprising across collations. What's this one?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgs
retty bad. I
suspect that COPY is going to be your friend here.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
egal advice you get on a mailing
list is in any case worth what you paid for it.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ou are holding a lock on something someone
else needs, your low nice score is going to cause them problems. It
could make things worse rather than better. (This suggestion comes up
a lot, by the way, so there's been a lot of discussion of it
historically.)
--
Andrew Sullivan
a...@crankyc
going to have 'integrated' replication that does x, y,
and z," was the right one, despite the fact that it undermined the
momentum of other interesting projects (and ones better suited to some
environments). Sometimes, it's better to cut off options.
Best,
A
--
Andrew Su
is year in a system that was designed to mimic a
complicated Oracle mutli-user set up. I used a number of schemas, the
search_path, and a lot of GRANTs to make everything work reliably in
the cases where there was shared data across the users. It seemed to
work for me.
A
--
Andre
is year in a system that was designed to mimic a
complicated Oracle mutli-user set up. I used a number of schemas, the
search_path, and a lot of GRANTs to make everything work reliably in
the cases where there was shared data across the users. It seemed to
work for me.
A
--
Andre
S higher for that column and do
the analyse. Have you tried that?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
table. (It sounds like what you really want is a primary key,
however, and that's going to be faster if you build the unique index
after the data's all loaded.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
eed
on the table. You're changing the schema of the table, and you need
to lock it while you do that. Probably you're not getting the lock
you need granted and therefore it seems like it's taking a long time.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-genera
er that the
reason there's no locking overhead is because there's no lock;
basically, if you're joining a lot, you're thrown back on
old-fashioned locks of some sort. They also don't permit
in-transaction round trips to the application, so that source of lock
contention is
of SQL was even stranger than
Oracle's so it was hard to move away from MySQL.
At least, that's my explanation for its popularity. As a disclaimer,
however, I will note that explaining the popularity of products is
almost always unsatisfying. Consumer behaviour, whatever a certain
strain
mes in that registry: if you register
example.info, Afilias has nothing to do with what software you use.
I'm sure to this audience that is self-evident, but having just
returned from an ICANN meeting I am not at all sure it is self-evident
to everyone in the world.
Best,
A
--
Andrew Sullivan
a...@c
be included in this
list. New vulnerabilities in these versions are no longer patched."
See http://www.postgresql.org/support/security/. I'd plan to upgrade
soon.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
ike it might not be impossible that way.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rfect, but it has
been useful to me.
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
bandwidth or that
they need to integrate vacuuming some tables with their program.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jan 29, 2009 at 09:51:42AM -0800, Joshua D. Drake wrote:
> It should be pg_backup and that is it, with a nice -R flag for restore.
I suppose you think that ssh_add -D is an intuitive interface too? ;-)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing l
part of your
problem.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
l lists.)
Actually, I don't think this _is_ a JDBC issue. AIUI, The problem
bites you with Slony because its triggers use SPI. So the reference
to the oid is to the trigger's oid, which you won't lose until the
back ends are all recyled.
A
--
Andrew Sullivan | [EMAIL PROTECT
pping support in Slony 1 (HEAD right
now) or the approach outlined at OSCON last year (anonymous file
shipping based on dbmirror -- mighty cool) is something closeish to
what you'll need.
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that vi
ime, the
locks are maintained.
In any case, the answer probably is still to kill -2 the offending
back end.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun
--
.
If you connect to the local IP (i.e. not 127.0.0.1 but some other
interface), does the same thing happen? (This would tell you whether
the problem lies in some sort of special problem routing localhost,
or whether it's something else.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact t
lem, however, and I can think of a nifty way to attempt this with
the currently-beta Slony-I software.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away from concreteness.
--George Orwell
---(end of broadcast)
velopment. We
use it for the .info and .org top level domains, among other systems.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of
; just that
it's important to realise that additional features come at the cost
of additional complexity. My bet is that anyone really needing high
availability will end up needing some of those additional features.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I
method used by pg_dump so the only throttle will be the network.
Not quite, because your schema needs to be complete on the target
system (in particular, you need your unique keys to stay, although
you can get rid of some other indexes to speed things up).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
e used to
decide what would satisfy our requirements, you can see Jan's concept
paper; it's at
<http://developer.postgresql.org/~wieck/slony1/Slony-I-concept.pdf>.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and im
a
sequence won't "roll back" in some really bad case, if you fail over
to the target? Figuring out how to do that was one of Jan's homework
projects, IIRC. ;-)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly wha
On Mon, May 09, 2005 at 12:58:06PM -0700, Dann Corbit wrote:
> Temp tables go away after the transaction completes.
Connection, actually, no?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
401 - 500 of 733 matches
Mail list logo
