Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-11 Thread Andrew Sullivan
don't know whether Bucardo or Londiste (two alternative systems that work on roughly the same principle) have this functionality, but I kind of doubt it since both were designed to get rid of several of the complexities that Slony presented. (Slony had all those complexities because it w

Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-11 Thread Andrew Sullivan
ure it does the thing requested in this case. 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

Re: [GENERAL] Reg: PostgreSQL Server "base/data" recovery

2015-03-19 Thread Andrew Sullivan
corruption fixes since 9.0.4. You should always try to stay on the latest minor release of your version of Postgres. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.p

Re: [GENERAL] 9.4+ partial log-shipping possible?

2015-03-27 Thread Andrew Sullivan
ring and are > consuming by far the most disk space (still somewhat expensive on SSD)! This doesn't actually solve your problem, but you could mitigate the cost by putting those tables on spinning-rust disks using tablespaces or symlinks or whatever. Best regards, A -- Andrew Sullivan

Re: [GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Andrew Sullivan
systems to move all the data from one to the other. Depending on your uptime requirements and the size of the database, this approach can either be a life saver or a total waste of time and will to live. More often the latter, please be aware. A -- Andrew Sullivan a...@crankycanuck.ca -- Sen

Re: [GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Andrew Sullivan
b from the old machine and restore locally, you could do pg_dump -U postgres -h 192.0.2.1 -C egdb | psql -U postgres I recommend reading the pg_dump (and if you like, pg_dumpall) manuals before proceeding. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list

Please not on this list (was Re: [GENERAL] Fwd: [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA)

2015-05-06 Thread Andrew Sullivan
ty's time with crowdsourced editing of job postings is in any way appropriate for the pgsql-general list. Best regards, 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

Re: [GENERAL] odbc to emulate mysql for end programs

2015-06-02 Thread Andrew Sullivan
onvention. This case is no different. 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

Re: [GENERAL] advocating LTS release and feature-train release cycles

2015-06-02 Thread Andrew Sullivan
emed developer claimed something and maybe should have relinquished sooner given his workload. That happens; nobody's perfect. It's frustrating, but this is not the only community to have had that issue (cf. Linux kernel, for an approximately infinite series of examples of this). I am not su

Re: [GENERAL] Error prone compilation of stored procedure

2015-07-06 Thread Andrew Sullivan
st, I found that to be useful when talking to Oracle partisans. 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

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-23 Thread Andrew Sullivan
e all the data in the table. I don't know what rewriting such a query would mean. Best regards, 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

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-23 Thread Andrew Sullivan
ut you asked what was behind the design decision and I told you. But in general, the experience seems to be that triggers are easier to get right (novice or no, _pace_ section 38.7). Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-24 Thread Andrew Sullivan
lly sure why you think the manual is misleading. Best regards, 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

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Andrew Sullivan
hacks, but if you need a bugfix prior to a real solution they'd give you a path. 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

Re: [GENERAL] Where do I enter commands?

2015-10-24 Thread Andrew Sullivan
I. But do consider trying out the command line. You'll be surprised at the power you get once the initial learning curve is over. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] Where do I enter commands?

2015-10-25 Thread Andrew Sullivan
m MySQL already. Consistency and rigour are the changes ;-) 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

Re: [GENERAL] MediaWiki + PostgreSQL is not ready for production?

2016-07-19 Thread Andrew Sullivan
s to MySQL, MySQL always wins, what you teach them is "Postgres performance sucks." Best regards, 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

Re: [GENERAL] MediaWiki + PostgreSQL is not ready for production?

2016-07-19 Thread Andrew Sullivan
this mysql2pgsql conversion rather than N dedicated small teams for > every mysql client out there. …I don't think anyone is telling you, "Don't build this." You should do what you like with your time :) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailin

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Andrew Sullivan
27;t deserve while > they treat customers and employees with similar levels of arrogance. Nothin' for nothin', but I don't think it helps Postgres to attack others' business plans -- whatever one thinks of them -- as part of an argument about why Postgres is the right tool fo

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Andrew Sullivan
mpatibility historically was the basis for something becoming a major version upgrade. (I can recall a couple bugs where you had to tickle the catalogues, so it's not exactly true that they're never incompatible, but it's incredibly rare.) Best regards, A -- Andrew Sullivan a...@crankycanu

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Andrew Sullivan
m. But one has to face the critique in its own terms. 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

pg_upgrade and not working (was Re: [GENERAL] Uber migrated from Postgres to MySQL)

2016-07-27 Thread Andrew Sullivan
ason we're still using 9.2. -- 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

Re: [GENERAL] fun fact about temp tables

2016-08-05 Thread Andrew Sullivan
to some other place later, and it'd suck if the transaction failed half way through because it turns out there's nowhere to put the data I've just staged. 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

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread Andrew Sullivan
ssibly be exfiltrated, you need to know the state of all of it. For realistic cases, I expect that deleted data is usually more important than updated data. But a threat modeller needs to understand all these variables anyway. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-g

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread Andrew Sullivan
metimes people delete data from a system because it's been archived somewhere else or something like that -- not all databases have the totality of all the relevant data in them, but can often represent just "current" data. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread Andrew Sullivan
al risk to be mitigated is. It might, sure. The security profiler would still need to make a list of this fact and then ask how countermeasures mitigate it. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Loggingt psql meta-commands

2015-12-10 Thread Andrew Sullivan
uditor, this might be enough to satisfy the condition. Also, of course, there is the application_name (string) parameter. In principle, you ought to be able to filter on this. Again, won't help you if your application login is somehow compromised. I agree that all of this depends on logging

Re: [GENERAL] Practical Application

2015-12-14 Thread Andrew Sullivan
e you can! There are also some firms that can help with migration if you like. Best regards, 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

Re: [GENERAL] Session Identifiers

2015-12-20 Thread Andrew Sullivan
losing the shell so that the session hangs around). Eventually, the Postgres backend will try to talk to the session and discover it isn't there, and you'll get a termination logged (assuming you have loging turned up that high). A -- Andrew Sullivan a...@crankycanuck.ca -- Sent

What another group does (was Re: [GENERAL] Code of Conduct: Is it time?)

2016-01-06 Thread Andrew Sullivan
urage those who think there is a problem to be solved to make a scratch proposal and see whether it flies. It's always easier to discuss a concrete proposal than to try to figure out whether something is a good idea in the abstract. The shorter and easier to understand the proposal is, I

Re: [GENERAL] Code of Conduct: Is it time?

2016-01-10 Thread Andrew Sullivan
children of slaves. If someone did that, it would fall under (2), no? (I note that a recent RFC, of which I am a co-author, about DNS terminology did say that "primary" and "secondary" were to be preferred over "master" and "slave". I didn't personally

Things to notice (was Re: [GENERAL] Code of Conduct: Is it time?, broken thread I hope)

2016-01-10 Thread Andrew Sullivan
an we can do something about it by writing down rules. Still, the exercise of writing down rules may help to notice things one wouldn't say to a friend. And I hope we're all friends here. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list

Re: Things to notice (was Re: [GENERAL] Code of Conduct: Is it time?, broken thread I hope)

2016-01-11 Thread Andrew Sullivan
tended in the generic sense. I apologise in case that wasn't clear. > It is the perceived intention of what one says that is important, not what > one actually says! I think that is perhaps a false dichotomy. But I also think I have said enough on this topic, so I shall stop now. B

Re: [GENERAL] Auotmated postgres failover

2016-01-21 Thread Andrew Sullivan
that you actually want to fail over. I've seen an awful lot of people want automatic failover who also can't afford for the already-committed transactions on the master to be lost. Unless you're running synchronous, be sure you have the workload that can actually accept lost w

Re: [GENERAL] Let's Do the CoC Right

2016-01-22 Thread Andrew Sullivan
at stuff about what the IETF does some while ago. There is definitely more than one way to do this. Best regards, 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

Re: [GENERAL] Catalog bloat (again)

2016-01-27 Thread Andrew Sullivan
at can be done about it? You may end up taking an outage in effect, because you need to compact them at least once. If you can flip to a replica, that is the easiest way to fix it. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] database corruption

2016-02-12 Thread Andrew Sullivan
to recover after a restart. It may not be the hardware. Depending on how vmware is configured, it could just be a setting. Also, something in the OP's message made me think that this was _actually_ a network-attached disk, which can also have such problems. (But in general, I agree.) A

Re: [GENERAL] regarding table migration from sql to postgres with runmtk.sh

2016-03-09 Thread Andrew Sullivan
fork. But … > Exception in thread "main" java.lang.NoClassDefFoundError: > org/postgresql/Driver … since it can't find the driver, I'd bet that your classpath doesn't contain /opt/postgresplus/edbmtk/lib. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca

Re: [GENERAL] enum bug

2016-03-14 Thread Andrew Sullivan
Best regards, 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

Re: [GENERAL] How to Qualifying or quantify risk of loss in asynchronous replication

2016-03-19 Thread Andrew Sullivan
receive a message that data is committed before any replication of the data has commenced," would that help? Best regards, 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

Re: [GENERAL] Proper relational database?

2016-04-23 Thread Andrew Sullivan
card number gets lost in an eventually-consistent system, and people suddenly understand viscerally why transactions semantics are so hard. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

On the right tool (was Re: [GENERAL] Proper relational database?)

2016-04-23 Thread Andrew Sullivan
hors intended. Doesn't matter for these purposes! :) [2] Apparently, Marshall McLuhan didn't say this; instead, his tribune John Culkin, SJ said it. It's still an excellent point, whoever made it. Best regards, 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

Re: [GENERAL] How to manually force a transaction wraparound

2016-04-29 Thread Andrew Sullivan
t I've been in the sort of long, boring speculative conversation that could have been shut down quickly with this kind of data.) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread Andrew Sullivan
re's something that we're going to have to accept, however, and that's that there are way more application coders than there are people who really get database systems. Fixing this problem requires years of efforts. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent vi

Re: [GENERAL] createdb.exe prompting for password on Vista

2007-05-28 Thread Andrew Sullivan
> so why does it ask me for a password? You must have password authentication enabled. You'd have to change it to "trust", I guess. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. Tha

Re: [GENERAL] why postgresql over other RDBMS

2007-05-28 Thread Andrew Sullivan
ome time. And there are a lot of grotty corners to IPv6 for which there are no analogies in IPv4. Uh, scoped addresses, anyone ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schn

Re: [GENERAL] createdb.exe prompting for password on Vista

2007-05-28 Thread Andrew Sullivan
s, so if there's some Windows-specific tricks, you may need to know that. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 3:

Re: [GENERAL] createdb.exe prompting for password on Vista

2007-05-28 Thread Andrew Sullivan
t it will work > for now. You could perhaps set up a .pgpass just for you at the beginning as well; but in general, yes, if you have to rely on someone else managing the permissions to the back end, then you also have to be able to cope with the authentication mechanisms. A -- Andrew Sulliv

Re: [GENERAL] Limiting number of rows returned at a time in select query

2007-05-28 Thread Andrew Sullivan
7;m not looking at the docs right now). Anyway, if it _is_ doing a cursor for you behind the scenes, that's almost certainly what you want. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November. --

Re: [GENERAL] Monitoring Tool

2007-05-29 Thread Andrew Sullivan
cts, and see if your component could be included. (It seems to me there are already three or four monitoring tools there. Search for "monitor".) A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need no

Re: [GENERAL] postgres access - pg_hba.conf

2007-05-30 Thread Andrew Sullivan
correctly. It must not be what you think it is. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland

Re: [GENERAL] Inheritance question

2007-05-30 Thread Andrew Sullivan
null). But in general, my impression is that you don't want inheritance here. What you probably want is better normalization of your data on the way in. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace.

Re: [GENERAL] 8.3

2007-05-30 Thread Andrew Sullivan
Bruce, at the current rate of patch review, beta won't happen before Sept. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast)-

Re: [GENERAL] 8.3

2007-05-30 Thread Andrew Sullivan
On Wed, May 30, 2007 at 08:04:19AM -0700, Joshua D. Drake wrote: > I would like to submit that, that is likely not true at all. Possibly. I was just pointing out that the last estimate any developer gave was "beta in Sept." A -- Andrew Sullivan | [EMAIL PROTECTED] The whol

Re: [GENERAL] REMOTE CONNECTION

2007-05-30 Thread Andrew Sullivan
On Wed, May 30, 2007 at 06:28:17PM -0400, ABHANG RANE wrote: > client. Please may I know what other parameters need to be tweaked. I To begin with, please show us exactly what you're doing. I don't know what it is yet. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was

multimaster (was: [GENERAL] Slightly OT.)

2007-06-01 Thread Andrew Sullivan
s, is actually probably good enough for most cases, assuming it is implemented correctly (see recent discussion on this topic). So the availability piece is mostly solved. What else do you want? A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What

Re: multimaster (was: [GENERAL] Slightly OT.)

2007-06-01 Thread Andrew Sullivan
n fact build a Postgres system that does the same things today, though. These are all different solutions to different problems, so it's not surprising that they look different. This was the reason I asked, "What is the problem you are trying to solve?" A -- Andrew Sul

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
But that was undesirable for the reason I note above. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland -

Re: multimaster (was: [GENERAL] Slightly OT.)

2007-06-01 Thread Andrew Sullivan
On Fri, Jun 01, 2007 at 08:40:13PM +0200, Alexander Staubo wrote: > On 6/1/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > >These are all different solutions to different problems, so it's not > >surprising that they look different. This was the reason I asked, >

Re: [GENERAL] multimaster

2007-06-01 Thread Andrew Sullivan
don't want to do it without thinking hard about what the compromises might be, and figuring out which ones to make. "Breaks transactional model", for instance, is right out :) A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exa

Re: [GENERAL] Continuous PITR (was Re: multimaster)

2007-06-01 Thread Andrew Sullivan
it already.) > This then begs the question: are CREATE|ALTER TABLESPACE commands > stored in the xlogs? (I'll spare the rant about begging the question.) Since they're transactional, they must be, no? A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alte

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
work on the system. But just as a teaser: what do you do if your DDL on the local node has succeeded, and you added additional data in the same transaction, but the DDL fails for some reason on a remote node? Note that this one isn't even one of the actually tricky cases. A -- Andrew Sulli

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
difficult on the part of those who have worked on the system. DDL changes require that every node have the new schema before any of the node-affecting data gets there. We have _enough_ problems with DDL failing on target systems without increasing this problem tenfold by doing it automat

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
lity attempts in order to depend on some new back end features -- putting this entirely in user space turns out to be awful. It's how we got the monstrous catalog corruption hack. This is getting pretty Slony specific, though, so if we're to continue this thread, I suggest we do

Re: One last Slony question (was Re: [GENERAL] Slightly OT.)

2007-06-02 Thread Andrew Sullivan
ways_ 30 minutes behind, as a sort of poor-person's fast-recovery PITR, then you lose that functionality if you have to perform DDL on the replica at the same time as on the origin, because you have to catch up first. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimat

Re: [GENERAL] Slightly OT.

2007-06-02 Thread Andrew Sullivan
f cases doesn't lead to complete breakage in others. (I had to be exposed to the multimaster MS SQL stuff, years ago, and I have to say that it was great when it worked; but when things went south, boy did your life suck. Whether it is better now, I don't know.) A -- Andrew Sullivan

Re: [Fwd: Re: [GENERAL] Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

2007-06-04 Thread Andrew Sullivan
es too late, but you don't need VACUUM FULL for that. VACUUM FULL _does not_ mean "vacuum everything"! A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it get

Re: [GENERAL] High-availability

2007-06-04 Thread Andrew Sullivan
On Sun, Jun 03, 2007 at 01:35:49PM -0400, Lew wrote: > How much data do you put in the DB? Oracle has a free version, but it has > size limits. AFAIK, Oracle's free version doesn't include RAC, which is what would be needed to satisfy the request anyway. A -- Andrew Su

Re: NULLS and User Input WAS Re: [GENERAL] multimaster

2007-06-04 Thread Andrew Sullivan
we have. If you happen to want to use NULL to mean something specific in some context, go ahead, but you shouldn't generalise that to "usually means" anything. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane

Re: NULLS and User Input WAS Re: [GENERAL] multimaster

2007-06-04 Thread Andrew Sullivan
uot;) See, this is what happens when you study the wrong things in school. You start to think that logic and metaphysics are somehow related to one another. :-/ A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace.

Re: [Fwd: Re: [GENERAL] Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

2007-06-04 Thread Andrew Sullivan
m full). Several people have been bitten by the misunderstanding that "VACUUM FULL" means "VACUUM ALL TABLES" (e.g. vaccum full database). A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them

Re: [GENERAL] Database design wisdom needed

2007-06-05 Thread Andrew Sullivan
7;d suspect vacuum issues. Oh, one other thing. I noted you're storing the player's IP address. You do know that maps very poorly to actual individuals on the other end, right? A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful th

Re: [GENERAL] Encrypted column

2007-06-05 Thread Andrew Sullivan
data stored online with simple reversible encryption. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 9: In versions below 8.0, the

Re: Creditcard Number Security was Re: [GENERAL] Encrypted column

2007-06-05 Thread Andrew Sullivan
sign is really a good idea.) A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] Auto Vacuum question?

2007-06-07 Thread Andrew Sullivan
ou have at least one long-running transaction that is perhaps doing nothing, but that is preventing VACUUM from recovering space. What does ps -auxww | grep postgres (or something equivalant) show you? A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy a

Re: [GENERAL] Limitations on 7.0.3?

2007-06-07 Thread Andrew Sullivan
t 7.0 is pre-WAL. Are you running with the -F switch turned on, for performance? It could well be that you are running into data corruption that crashes the database. (The lack of WAL is not the only reason you might be running into that. 7.0 is a long time ago, and there are a lot of bugs that

Re: [GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Andrew Sullivan
vacuuming correctly? If you had xid wraparound, your data could disappear. 2. Malice or pilot error: are you sure nobody has issued TRUNCATE on the table? A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy and hard to use, but at least the

Re: [GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Andrew Sullivan
#x27;d not be able to see anything in the table. When you went to insert to the table, though, you'd get errors, so unless you're dropping the table and rebuilding from scratch, I'd expect you to get an error when you reloaded the data. A -- Andrew Sullivan | [EMAIL PROTECTED]

Re: [GENERAL] how to speed up query

2007-06-08 Thread Andrew Sullivan
On Fri, Jun 08, 2007 at 11:29:12AM +0300, Andrus wrote: > How to speed up the query We don't know. You don't tell us what version you're running, show us any EXPLAIN ANALYSE output, tell us about the data. . . A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reforma

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
is a way of saying, "You didn't tell us anything that would allow us to help.") A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernis

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
emory than you actually have? After two years, I'd expect the data to be larger, which might mean you have reached some threshold where an optimisation you made that wasn't actually right is now really wrong. If you're swapping, the CPU time is probably going to bringing some data

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
27;re doing regular VACUUM. That hasn't been a problem since 7.2. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast)--

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
aybe have (e.g.) work_mem set too high, and that's what is causing your problem? Or shared buffers too big? This is a common error, and on a smaller set of data, it won't hurt; but when the data gets to a point, you lose. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain descriptio

Re: [GENERAL] how to enforce index usage with +0

2007-06-13 Thread Andrew Sullivan
27;re probably trying to outsmart the planner/optimiser here, and that's _usually_ not a good idea. IT shouldn't make any difference whether you add that +0 or not, assuming the database is tuned correctly. I'd be rather more worried about the date_trunc stuff. You probably want a

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andrew Sullivan
least limit it to one list? A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andrew Sullivan
, we'd be violating it, and since we're not, we can't possibly know about it, right ;-) But there are some materials about why to use Postgres on the website: http://www.postgresql.org/about/advantages A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alte

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andrew Sullivan
On Mon, Jun 18, 2007 at 02:38:32PM -0400, Andrew Sullivan wrote: > I've picked -advocacy. Actually, I _had_ picked advocacy, but had an itchy trigger finger. Apologies, all. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are aga

Re: [GENERAL] Running OS-level programs from Postgres?

2007-06-20 Thread Andrew Sullivan
le (via polling or listen/notify) and sends the > queued mail. For the record, this is _way_ more robust. It also prevents your database from accidentally DoSing your mail server, as it would if thousands of mail messages were all triggered in a very short period of time. A -- Andrew

Re: [GENERAL] Experiences of PostgreSQL on-disk bitmap index patch

2007-06-21 Thread Andrew Sullivan
find out more about bizgres at http://bizgres.org/home.php. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] how to implement unusual constraint

2007-06-26 Thread Andrew Sullivan
7;s probably an indicator that some of the data is repeated, and that tells you you're not normalised correctly.) A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)-

Re: [GENERAL] db replication

2007-06-29 Thread Andrew Sullivan
ience tell me what is the best free solution to my > problem?... AFAIK there isn't one. PDA replication requires disconnected multimaster asynchronous replication, and I don't know of a project that has delivered that yet. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visi

Re: [GENERAL] [pgsql-general] In memory tables/databases

2007-07-05 Thread Andrew Sullivan
putting it in an RDBMS? Is it because all your pre-built tools already speak SQL? If you're really after performance, I'm not convinced a SQL-speaking RDBMS (delivered by MySQL or Postgres or anyone else) is what you actually need. A -- Andrew Sullivan | [EMAIL PROTECTED] The who

Re: [GENERAL] dropdb ; createdb equivalent without createdb permission?

2007-07-09 Thread Andrew Sullivan
access is for a (set of) script(s) that achieve what you want (e.g. scripts with the appropriate createdb, psql -c "something" &c. inside them). Obviously, if the user can edit the scripts, then your intention is still foiled. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact tha

Re: [GENERAL] dropdb ; createdb equivalent without createdb permission?

2007-07-09 Thread Andrew Sullivan
dly, or is this more a control attempt? If the latter, I fear you are going down the wrong road. A -- Andrew Sullivan | [EMAIL PROTECTED] The very definition of "news" is "something that hardly ever happens." --Bruce Schneier ---(

Re: [GENERAL] dropdb ; createdb equivalent without createdb permission?

2007-07-09 Thread Andrew Sullivan
ing is pretty useful. But for other applications, it's probably a lousy choice. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J

Re: [GENERAL] PostGreSQL Replication

2007-07-10 Thread Andrew Sullivan
system that currently supports what you're talking about. This is easier to bodge together under Slony using views and such like, but it's still not trivial. If you wish to discuss how to do this with Slony, I suggest taking it up on that list (available from the site mentioned above). A

Re: [GENERAL] Hyper-Trading

2007-07-10 Thread Andrew Sullivan
erthreading actually helps, although I may have overlooked a couple of cases. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J

Re: [GENERAL] how does a temp table work?

2007-07-11 Thread Andrew Sullivan
hared temp table" support in Postgres. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will

Re: [GENERAL] how does a temp table work?

2007-07-11 Thread Andrew Sullivan
ing to speculate :) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast)--- TIP 6: ex

Re: [GENERAL] SMTP

2007-07-16 Thread Andrew Sullivan
rom the database, or. . .? A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz ---(end of broadcast)---

  1   2   3   4   5   6   7   8   >