Re: [GENERAL] Postgresql and resource isolation

2007-11-15 Thread Andrew Sullivan
of nobody working on it today. -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Andrew Sullivan
some disadvantages, I think on the whole it was a good thing. A -- Andrew Sullivan ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] PLpgsql debugger question

2007-11-15 Thread Andrew Sullivan
members could say, Here are things that naturally fit together when we use them, and if enough people found a given description apposite, we could endorse that. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast

Re: [GENERAL] pg_dump problem

2007-11-15 Thread Andrew Sullivan
installed? Is this a replica? If so, it's a well-known problem. You can't use pg_dump under those circumstances. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [GENERAL] reserving space in a rec for future update

2007-11-14 Thread Andrew Sullivan
for PostgreSQL is its behaviour under this sort of most rows updated scenario, and it is wise to plan carefully how you will accomplish these sorts of activities without causing yourself extreme pain. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke

Re: [GENERAL] reserving space in a rec for future update

2007-11-14 Thread Andrew Sullivan
, of the sort you were implying is one, pay the cost during transaction is another one, c.). The piper has to be paid, and all we're doing is arguing about what currency we'll use :) A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end

Re: [GENERAL] reserving space in a rec for future update

2007-11-14 Thread Andrew Sullivan
would certainly suggest trying this on 8.3. I know that's the _point_ of the feature. But if you've already got an application you need to field today, doing it on a beta is risky. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end

Re: [GENERAL] WAL segments size

2007-11-12 Thread Andrew Sullivan
/static/runtime-config-wal.html#GUC-CHECKPOINT-SEGMENTS ? That doesn't say you have to set it at compile time. You can't change it without _restarting_ Postgres. That's because it's something that has to be initialized at start up. A -- Andrew Sullivan Old sigs will return after re-constitution

Re: [GENERAL] Insert statements really slow

2007-11-09 Thread Andrew Sullivan
looking at COPY for bulk imports. It's way faster. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [GENERAL] young guy wanting (Postgres DBA) ammo

2007-11-03 Thread Andrew Sullivan
nothing wrong with it. Supposing you don't need a DBA for MySQL or MS SQL Server or any other such system is a dangerous delusion. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [GENERAL] more problems with count(*) on large table

2007-09-28 Thread Andrew Sullivan
that this sort of inconsistent selectivity on an indexed column can be because the column statistics aren't good enough. You can try ALTER TABLE...SET STATISTICS to see if it helps. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary

Re: [GENERAL] Planning a Postgresql based Database

2007-09-20 Thread Andrew Sullivan
; or, if they're convinced the community is wrong, who prove what they claim in working code before talking about how nobody here knows what they're doing. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end

Re: [GENERAL] Uninstall mess Postgresql 7.3.4, 8.1.4 on Redhat 9

2007-09-19 Thread Andrew Sullivan
with the new pg_dump, not the old one. A -- Andrew Sullivan | [EMAIL PROTECTED] However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues in a great many others. --Alain de Botton ---(end

Re: [GENERAL] Reliable and fast money transaction design

2007-08-30 Thread Andrew Sullivan
, and that is that it's waiting on possibly-conflicting (but not actually conflicting) commits to happen in READ COMMITTED mode. No? Won't it have to check those things when it COMMITs? A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness

Re: [GENERAL] date of next Version 8.2 release

2007-08-30 Thread Andrew Sullivan
that the difference between release and _STABLE from CVS is the quantity of pre-built stuff in the tarball. In my experience, using the current tip of _STABLE is as good as any dot-release. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary

Re: [GENERAL] Reliable and fast money transaction design

2007-08-30 Thread Andrew Sullivan
doesn't count for me? 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.D. Baldwin ---(end of broadcast

Re: [GENERAL] Reliable and fast money transaction design

2007-08-30 Thread Andrew Sullivan
a nearly-mathematical serializability.) A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-27 Thread Andrew Sullivan
hard about the qualifications of someone who proposed using it for financial data. 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

Re: [GENERAL] Tables dissapearing

2007-08-27 Thread Andrew Sullivan
convinced your script is working as you think it is. You're clearly not managing to vacuum the entire database sometimes. 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

Re: [GENERAL] Removing pollution from log files

2007-08-27 Thread Andrew Sullivan
not pollution; it's telling you you need to fix your application to escape the backslashes differently. If you want to suppress them, though, you can change your logging level to be higher than WARNING. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way

Re: [GENERAL] Tables dissapearing

2007-08-27 Thread Andrew Sullivan
need to do that. You should be able to run vacuumdb -a, and get the result you need. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie

Re: [GENERAL] Tables dissapearing

2007-08-27 Thread Andrew Sullivan
think you are? A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [GENERAL] Is this a bug? Insert float into int column inserts rounded value instead of error.

2007-08-27 Thread Andrew Sullivan
get 4.12322345 back out if I didn't get an error on insert. If you quote it, it works. That is: testing=# SELECT 4.123123123::int; int4 -- 4 (1 row) testing=# SELECT '4.123123123'::int; ERROR: invalid input syntax for integer: 4.123123123 A -- Andrew Sullivan | [EMAIL PROTECTED] I

Re: [GENERAL] Tables dissapearing

2007-08-27 Thread Andrew Sullivan
but in another database... but I know - it's too speculative. No, it just doesn't work that way. Are these all shared on the same hardware? Are you sure you're not having other problems? A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying

Re: [GENERAL] Tables dissapearing

2007-08-27 Thread Andrew Sullivan
On Tue, Aug 28, 2007 at 02:03:29AM +0200, Kamil Srot wrote: The system is actually management of websiteeshop with webbased UI ... Um, are you sure you don't have a SQL-injection problem, and someone is doing Something Bad to you? A -- Andrew Sullivan | [EMAIL PROTECTED] The fact

Re: [GENERAL] two phase commit

2007-07-23 Thread Andrew Sullivan
On Fri, Jul 20, 2007 at 05:17:00PM -0700, Jeff Davis wrote: On Fri, 2007-07-20 at 15:26 -0400, Andrew Sullivan wrote: instance, recently it turned out that there was a way, using 2PC, to lock everybody out of the database. The only remedy to that at the moment is to blow away all

Re: [GENERAL] two phase commit

2007-07-23 Thread Andrew Sullivan
might fail in certain, world-blows-up scenarios, then maybe that's good enough. (You really just need to know what you're not protected against, I'd assume.) A -- Andrew Sullivan | [EMAIL PROTECTED] The very definition of news is something that hardly ever happens. --Bruce

Re: [GENERAL] two phase commit

2007-07-23 Thread Andrew Sullivan
On Mon, Jul 23, 2007 at 12:29:06PM -0700, Jeff Davis wrote: The way you worded your reply would scare anyone away from using 2PC at all, and 2PC might be useful in Ben's case. Well, I didn't intend to scare anyone away from it! Apologies. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole

Re: [GENERAL] two phase commit

2007-07-20 Thread Andrew Sullivan
to. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---(end of broadcast)--- TIP 1: if posting/reading

Re: [GENERAL] SMTP

2007-07-16 Thread Andrew Sullivan
, 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)--- TIP 2: Don't 'kill -9

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

2007-07-11 Thread Andrew Sullivan
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 ignore your desire

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

2007-07-11 Thread Andrew Sullivan
:) 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: explain analyze

Re: [GENERAL] PostGreSQL Replication

2007-07-10 Thread Andrew Sullivan
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 -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet

Re: [GENERAL] Hyper-Trading

2007-07-10 Thread Andrew Sullivan
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.D. Baldwin

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

2007-07-09 Thread Andrew Sullivan
) 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 that technology doesn't work is no bar to success

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

2007-07-09 Thread Andrew Sullivan
the wrong road. A -- Andrew Sullivan | [EMAIL PROTECTED] The very definition of news is something that hardly ever happens. --Bruce Schneier ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

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

2007-07-09 Thread Andrew Sullivan
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.D. Baldwin

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

2007-07-05 Thread Andrew Sullivan
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 whole tendency of modern

Re: [GENERAL] db replication

2007-06-29 Thread Andrew Sullivan
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 visionary and imaginative, and goes to show

Re: [GENERAL] how to implement unusual constraint

2007-06-26 Thread Andrew Sullivan
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)--- TIP 3: Have you checked our

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

2007-06-21 Thread Andrew Sullivan
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] Running OS-level programs from Postgres?

2007-06-20 Thread Andrew Sullivan
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 Sullivan | [EMAIL PROTECTED

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

2007-06-18 Thread Andrew Sullivan
at 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

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

2007-06-18 Thread Andrew Sullivan
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 alter my conclusions. What do you do sir

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 against all

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

2007-06-13 Thread Andrew Sullivan
, 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 functional index on there. A -- Andrew Sullivan | [EMAIL PROTECTED] This work

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

2007-06-08 Thread Andrew Sullivan
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 there is a lot of code

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

2007-06-08 Thread Andrew Sullivan
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] Everything that happens in the world happens at some place

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 reformatting the Internet

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
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 Postmodernism. --Brad Holland

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
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 back in from disk (i.e. it's actually in OS calls). A -- Andrew Sullivan

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
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)--- TIP 5: don't forget to increase your

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread Andrew Sullivan
.) 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 description of men are for getting out

Re: [GENERAL] Auto Vacuum question?

2007-06-07 Thread Andrew Sullivan
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 and hard to use, but at least there is a lot

Re: [GENERAL] Limitations on 7.0.3?

2007-06-07 Thread Andrew Sullivan
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 have been squished since then.) A -- Andrew Sullivan

Re: [GENERAL] Database design wisdom needed

2007-06-05 Thread Andrew Sullivan
individuals on the other end, right? A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end of broadcast

Re: [GENERAL] Encrypted column

2007-06-05 Thread Andrew Sullivan
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 planner will ignore your desire

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

2007-06-05 Thread Andrew Sullivan
-stealable data is the data you don't have. But if there is a business case, you have to do the trade off. And security is always a tradeoff (to quote Schneier); just do it well. (Someone else's advice about hiring a security expert to audit this sort of design is really a good idea.) A -- Andrew

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

2007-06-04 Thread Andrew Sullivan
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 gets out of whack. --Scott Morris ---(end

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 Sullivan | [EMAIL

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

2007-06-04 Thread Andrew Sullivan
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 Jacobs ---(end of broadcast

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

2007-06-04 Thread Andrew Sullivan
to one another. :-/ A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---(end of broadcast)--- TIP 4: Have you searched our list archives

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

2007-06-04 Thread Andrew Sullivan
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 to. That actually seems sort of quaint now

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

2007-06-02 Thread Andrew Sullivan
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 penultimate month is not in truth a good way

Re: [GENERAL] Slightly OT.

2007-06-02 Thread Andrew Sullivan
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 | [EMAIL PROTECTED] Unfortunately

multimaster (was: [GENERAL] Slightly OT.)

2007-06-01 Thread Andrew Sullivan
, 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 do you do sir? --attr. John Maynard

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

2007-06-01 Thread Andrew Sullivan
that they look different. This was the reason I asked, What is the problem you are trying to solve? A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
. 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 ---(end of broadcast)--- TIP 4

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, What is the problem you are trying

Re: [GENERAL] multimaster

2007-06-01 Thread Andrew Sullivan
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* exactly what you told them

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

2007-06-01 Thread Andrew Sullivan
.) 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 alter my conclusions. What do you do sir

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
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 Sullivan | [EMAIL PROTECTED] A certain description of men

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
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 automatically. A -- Andrew Sullivan | [EMAIL

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Andrew Sullivan
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 it on the Slony list. A -- Andrew Sullivan | [EMAIL

Re: [GENERAL] postgres access - pg_hba.conf

2007-05-30 Thread Andrew Sullivan
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 ---(end of broadcast

Re: [GENERAL] Inheritance question

2007-05-30 Thread Andrew Sullivan
, 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. --Philip Greenspun

Re: [GENERAL] 8.3

2007-05-30 Thread Andrew Sullivan
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)--- TIP 4: Have you

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 whole tendency of modern

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 visionary

Re: [GENERAL] Monitoring Tool

2007-05-29 Thread Andrew Sullivan
, 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 not end up well

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

2007-05-28 Thread Andrew Sullivan
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. That actually seems sort of quaint now

Re: [GENERAL] why postgresql over other RDBMS

2007-05-28 Thread Andrew Sullivan
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 Schneier ---(end

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

2007-05-28 Thread Andrew Sullivan
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: Have you checked our

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

2007-05-28 Thread Andrew Sullivan
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 Sullivan | [EMAIL PROTECTED] The fact

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

2007-05-28 Thread Andrew Sullivan
, 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. --H.W. Fowler ---(end of broadcast

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
means a lower estimation of the value of the feature. So features that seem sort of boutique are to be regarded at least with scepticism, in order to keep the code useful for everyone. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
they say, This patch works, there is a stronger probability the community will take seriously their claims that the patch works correctly. Free software never comes without cost, and this is one of them. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
a subtransaction around every statement. You say you don't want to do the latter, but there's no reason your client couldn't do it for you, in much the same way we have AUTOCOMMIT modes. Indeed, PL/pgSQL actually does this sort of trick in order to get exception handling. A -- Andrew Sullivan

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
dedicated storage hardware for that database. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end of broadcast

Re: [GENERAL] why postgresql over other RDBMS

2007-05-24 Thread Andrew Sullivan
in a connection pool. I'm shuddering at the thought of it, to be honest, so details are left as an exervisse for the reader. 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

Re: [GENERAL] Integrity on large sites

2007-05-23 Thread Andrew Sullivan
storing correctly. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

Re: [GENERAL] Need software infrastructure advice

2007-05-23 Thread Andrew Sullivan
network might bite you here, though.) A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Problem with pg_dump

2007-05-22 Thread Andrew Sullivan
using Slony, right? You can't use pg_dump on a database where _any_ table is Slony-replicated right now. Yes, this is due to the catalogue corruption Slony introduces. There's an alternative in the Slony tools/ directory. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens

Re: [GENERAL] Data replication through disk replication

2007-05-20 Thread Andrew Sullivan
it doesn't. (It's not the question of what it could do, but what it actually does, that's the important one for implementors.) A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes

Re: [GENERAL] Data replication through disk replication

2007-05-19 Thread Andrew Sullivan
sells HACMP. I refuse to comment on whether IBM's advice on high availability products is worth taking seriously. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun

Re: [GENERAL] Data replication through disk replication

2007-05-18 Thread Andrew Sullivan
technologies.) A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

2007-05-18 Thread Andrew Sullivan
this on Thursday and deploying on Monday. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schneier ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [GENERAL] Data replication through disk replication

2007-05-18 Thread Andrew Sullivan
implementation you have. Note that there are many ways to do this wrong, including things like using tokens on the filesystem as a lockfile (I swear someone once proposed this to me). A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

2007-05-17 Thread Andrew Sullivan
to be ruined by a data recovery. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 5: don't forget to increase your free space

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

2007-05-17 Thread Andrew Sullivan
product, that in my experience does _not_ always work as advertised. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)--- TIP 3

<    1   2   3   4   5   6   7   8   >