Re: [ADMIN] character problem

2005-10-12 Thread Andrew Sullivan
t restriction on insertions. SQL_ASCII does not represent a positive claim that the database knows all the characters to be 7 bit characters. It represents instead the complete absence of any encoding knowledge. Inserting high-bit characters into a database using the SQL_ASCII character set may hav

Re: [ADMIN] Solving OID wrap-around in 7.4 DB?

2005-10-18 Thread Andrew Sullivan
without OIDs, which will stave off your problem for a while. That'd probably even help if the database mostly just grows, depending (of course) on where the growth is. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. I

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

2005-10-21 Thread Andrew Sullivan
or that matter, dissatisfactory) about Slony? I expect the developers would like to know. 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. --Alex

Re: [ADMIN] ERROR: could not read block

2005-11-15 Thread Andrew Sullivan
On Mon, Nov 14, 2005 at 06:19:16PM -0600, Kevin Grittner wrote: > the moment aren't sure. The current machines are "transitional", > and it may not be too late to set the permanent servers up with ECC > memory. Is it something I should fight for? Yes. Always. A -- A

Re: [ADMIN] Major Problem, need help! Can't run our website!

2005-11-15 Thread Andrew Sullivan
take a _long_ time to complete (depending how big oyur database is), and (as I noted) it will cause your application not to work while it's going on. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November.

Re: [ADMIN] restore challenge

2005-11-17 Thread Andrew Sullivan
hers who've reported it works (and it ought to, if the snapshots work as advertised -- just be sure you know what the snapshots actually are). A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbo

Re: [ADMIN] fsm allocation

2005-11-18 Thread Andrew Sullivan
ussed, I can't believe you really need that much space. 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: [ADMIN] PKI/SSL Client/Server Certificate Authentication

2006-01-13 Thread Andrew Sullivan
t it _can_ use SSL, except that it doesn't have the ability to validate via certs. So there'd be another potential use case for this. I briefly toyed with trying to find someone to implement cert-based authentication, but found I had other things more pressing (so the TODO fell off the end

Re: [ADMIN] Unable to connect to a specific database

2006-01-16 Thread Andrew Sullivan
ot;psql dbname" and it hangs for a while. I'm still waiting. Any > ideas? What do your database logs say? I expect that you're in recovery mode, but it's impossible to tell from this note. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn&#

Re: [ADMIN] Unable to connect to a specific database

2006-01-16 Thread Andrew Sullivan
say, it's very bad news, but it shouldn't actually corrupt the 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. --J.D. Baldwin ---

Re: [ADMIN] full vacuum - resources - scaling

2006-05-30 Thread Andrew Sullivan
ut I haven't done any real analysis of it. The main thing is, "Don't do vacuum full." A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)

Re: [ADMIN] transactoin id wraparound problem

2006-09-06 Thread Andrew Sullivan
;do VACUUM FULL". These aren't the same thing. My bet is what you need is vacuumdb -a You've probably missed a database you don't know is there. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place.

Re: [ADMIN] transactoin id wraparound problem

2006-09-06 Thread Andrew Sullivan
ll need the (postgresql) password for the account in question to do this. 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. --B

Re: [ADMIN] transactoin id wraparound problem

2006-09-06 Thread Andrew Sullivan
On Wed, Sep 06, 2006 at 09:48:45AM -0700, Sriram Dandapani wrote: > Is there a quick way(other than vacuum full) to re-init the transaction > ids. (I can afford some downtime) You don't need a vacuum full. You just need a bog-standard vacuum, but you need it _on every database_. A

Re: [ADMIN] transactoin id wraparound problem

2006-09-06 Thread Andrew Sullivan
you think will happen while vacuum is running. If it's a lot, you could pass the fatal point (== you lose data) before vacuum finishes. In most cases, it's probably ok, but only you can decide how dangerous it would be for you to lose data. A -- Andrew Sullivan | [EMAIL PROTECTED] Th

Re: [ADMIN] timezone Q for postgresql v814

2006-09-07 Thread Andrew Sullivan
On Thu, Sep 07, 2006 at 10:00:31AM -0400, Mr. Dan wrote: > right. We think postgres is using UTC-5 for some reason. We don't have Why do you think that? A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jan

Re: [ADMIN] Multi-Master Async Replication

2006-09-19 Thread Andrew Sullivan
runs only on 7.0 and 7.1 versions. > > I'm using pg 8.1.3 both sides, over linux. > > Do somebody has any tips?!?! AFAIK, there isn't anything that does this today. There have been various suggestions floated on how to emulate this with some contortions using Slony, but

Re: ?^???G Re: [ADMIN] How can I restore from WAL log? [PG 7.3]

2006-09-29 Thread Andrew Sullivan
On Fri, Sep 29, 2006 at 10:24:01AM +0800, Chan Michael wrote: > Hi Jim, > > Thanks for your info. > > Then in PostgreSQL 7.3 how can I use the WAL log to recover? You can't. That's why it's a "new feature" in 8.0. A -- Andrew Sullivan | [EMAIL

Re: [ADMIN] Postgres Logging doesnt work

2006-10-02 Thread Andrew Sullivan
| 0 You've set this up to rotate once every 10,080 minutes, no matter what. If you've run into a file size limit, then you'll be out of luck until the next file is opened, which should be on the same day of the week the postmaster was last started. Just a guess. A -- An

Re: [ADMIN] postgres in HA constellation

2006-10-05 Thread Andrew Sullivan
a major pain to restore in the event of such corruption. In addition, your recovery will only be to the last dump. That's why I suggest replicating, either with Slony or something else, as a belt that will nicely complement the suspenders of your shared-disc failover. A -- Andrew Sullivan

Re: [ADMIN] postgres in HA constellation

2006-10-11 Thread Andrew Sullivan
u make, so that you don't have a garbage file to read. As I said, I don't think that it's a bad idea to use this sort of trick. I just think it's a poor single line of defence, because when it fails, it fails hard. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future thi

Re: [ADMIN] postgres in HA constellation

2006-10-11 Thread Andrew Sullivan
eak at the same time, and have a recovery plan for it. I submit that a recovery plan of "restore from pg_dump" is usually not going to be enough if it was worth the cost and hassle of setting up shared disk failover. YMMV, of course. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact

Re: [ADMIN] Vacuum Problems (locking)

2006-10-26 Thread Andrew Sullivan
nd sleeps for a few seconds in between -- and you shouldn't have this problem. But you'll need to VACUUM FULL or dump and reload first. A -- Andrew Sullivan | [EMAIL PROTECTED] Windows is a platform without soap, where rats run around in open sewers. --Daniel Eran ---

Re: [ADMIN] 100% failover + replication solution

2006-10-30 Thread Andrew Sullivan
eployed systems. This happens to be true of commercial offerings too (if not, you could buy the cheapest version of, say, Oracle and get RAC in the bargain), but they _sell_ it to you as though it were one big package. To the extent your managers don't understand this, you're always

Re: [ADMIN] New to PostgreSQL

2006-11-02 Thread Andrew Sullivan
eSQL. This is a very unfamiliar situation to most Oracle and some DB2 administrators, in my experience. The good ones, of course, have no problem catching on; the bad ones never deserved the name DBA anyway ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software

Re: [ADMIN] Postgres-R

2006-11-02 Thread Andrew Sullivan
t; TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- 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 Rit

Re: [ADMIN] What is pg_attribute_relid_attnam_index?

2003-10-09 Thread Andrew Sullivan
ly) to your database without doing VACUUM? If you go to single user mode and REINDEX that table you might find it helps. Otherwise, I doubt they should be so large as a percentage, unless you have an empty database with lots of columns with long names. A -- Andrew Sullivan

Re: [ADMIN] Security Problem

2003-10-14 Thread Andrew Sullivan
On Tue, Oct 14, 2003 at 11:32:03AM +0200, Daniel Rubio wrote: > How I could solve this? Upgrade to 7.3 and use the schema support to do it for you. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <

Re: [ADMIN] ERserver patch question

2003-10-15 Thread Andrew Sullivan
The program all builds for me. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110

Re: [ADMIN] ERserver problems

2003-10-20 Thread Andrew Sullivan
e see the archives for the mailing list for erserver. They're available at the erserver gborg site. In short, there is a bug in the setup scripts, and you need to do some work by hand. Instructions are in the archives. A -- Andrew Sullivan 204-4141 Yonge Street

Re: [ADMIN] Postgresql Memory Problem

2003-10-21 Thread Andrew Sullivan
unds like you're worrying about something that you need not worry about. It is totally normal for your OS to "use up" memory that is not otherwise used. Why have it if it's not going to be used? A Andrew Sullivan 204-4141 Yonge Street Afilias Canada

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread Andrew Sullivan
reproducable. I think Tom Lane is especially interested in looking at cases like this; or he was last time I talked to him about it. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada &

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread Andrew Sullivan
ea for fixing this data is wellcome. I will check the data > inconsistent. As I understand it, you need to zero out the file with dummy data in order to get going again. You really need to plough the archives for what to do, though. I've never had to do this. A -- Andrew Sullivan

Re: [ADMIN] Matching indexes on int8 columns?

2003-10-30 Thread Andrew Sullivan
n -hackers archives you'll find several attempts to find a solution to this little problem; all of them have failed so far, AFAIK. There was talk of making the int4-to-int8 case behave more reasonably in 7.4, but I don't know whether it's been done. A -- Andrew Sullivan

Re: [ADMIN] PGSQL Mailing List Reply-To field

2003-11-05 Thread Andrew Sullivan
> Its not. You should probably just get used to doing reply to all. Or you can get a mail client that support "reply-to-list" functionality. I seem to recall hearing rumours that pine will do that. I know mutt does, because it's what I use. A Andrew Sullivan

Re: [ADMIN] performance problem - 10.000 databases

2003-11-05 Thread Andrew Sullivan
numbers are different... I guess it did take. huh. No, that probably just means that there is more variability to runs than people like to imagine. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontar

Re: [ADMIN] data format problem for upgrede from 7.1->7.3

2003-11-06 Thread Andrew Sullivan
ust long enough to catch up any changes. Of course, you need twice the disk, which is a pain, but it's certainly not impossible. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario C

Re: [ADMIN] Problems Compiling eRserver

2003-11-10 Thread Andrew Sullivan
. BTW, there's a list just for erserver. You'll probably get better help there. I suggest noodling around the erserver site, because the archive has an explanation of this. A -- Andrew Sullivan 204-4141 Yonge Street Afilias Canada

Re: [ADMIN] Upgrading to Solaris 9

2003-11-12 Thread Andrew Sullivan
On Tue, Nov 11, 2003 at 07:29:42PM +0100, Gaetano Mendola wrote: > > Seems that solaris is the worst choice for run Postgres. > > Am I completely wrong ? Windows is worse ;-) A -- Andrew Sullivan 204-4141 Yonge Street Afilias Canada

Re: [ADMIN] Upgrading to Solaris 9

2003-11-12 Thread Andrew Sullivan
r handling large numbers of processes. We get around that by throwing hardware at the problem. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTECTED]>

Re: [ADMIN] Logging: statements and users

2003-11-14 Thread Andrew Sullivan
log connections, and then trace back to see who connected with that pid. There was some discussion about improving this for 7.4, but I don't know if any of that was done. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToront

Re: [ADMIN] Oracle and PostgreSQL servers incompatibility

2003-11-14 Thread Andrew Sullivan
f them can know about other programs' semaphore use. You probably need more available semaphores from your kernel. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTECTED]>

Re: [ADMIN] compare two databases

2003-11-17 Thread Andrew Sullivan
s in the same order. They key to all this is understanding the implications of lazy vacuum: tuples do not always stay in the same place on the disk. > If it is not the case, then you might need to sort each > table dump before the diff. Yes. -- Andrew Sullivan

Re: [ADMIN] [GENERAL] Point-in-time data recovery - v.7.4

2003-11-18 Thread Andrew Sullivan
-quality? I don't think so. Jan Wieck has a proposal for a new replication system which will offer a trick for producing point in time as a side benefit. We are aiming to have that software in use sooner rather than later, but it hasn't been written yet. A -- Andrew Sullivan

Re: [ADMIN] recovering from backup + transaction log

2003-11-20 Thread Andrew Sullivan
from a log. No. > (Is this to do with the recent Point-in-time recovery, and if so, > will we have to wait for 7.5?) Yes. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTECTED]>

Re: [ADMIN] postgresql crushed with XLogWrite error

2004-01-05 Thread Andrew Sullivan
he very reason 7.3.4 was released. Upgrade. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8

Re: [ADMIN] postgresql crushed with XLogWrite error

2004-01-05 Thread Andrew Sullivan
you'll need to get some version of 7.3 running first. A Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8

Re: [ADMIN] postgresql crushed with XLogWrite error

2004-01-05 Thread Andrew Sullivan
! If you're upgrading via RPM, why not just do a regular RPM installation? Doesn't that work? (Extracting binaries from RPMs and doing other such things sounds like the way to break something.) A -- Andrew Sullivan 204-4141 Yonge Street Afilias Canada

Re: [ADMIN] postgresql crushed with XLogWrite error

2004-01-05 Thread Andrew Sullivan
On Mon, Jan 05, 2004 at 07:35:16PM +0200, Tsirkin Evgeny wrote: > On Mon, 5 Jan 2004 11:23:08 -0500, Andrew Sullivan > <[EMAIL PROTECTED]> wrote: > > I want to keep my configs.Of course i can save my postgresql.conf > (and other files that i changed and don't curren

Re: [ADMIN] Veritas Filesystem

2004-02-03 Thread Andrew Sullivan
as the versions for other systems. _Similar_, perhaps. If IBM's jfs on AIX does what it appears to do on Linux occasionally, I'm going to be one very unhappy camper. A -- Andrew Sullivan | I remember when computers were frustrating because they *did* exactly what you told them to. Th

Re: [ADMIN] hanging for 30sec when checkpointing

2004-02-06 Thread Andrew Sullivan
, they do hurt _quite substantially_ during the checkpoint. If you need fast all the time, cranking that interval too high will definitely hurt you. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace.

Re: [ADMIN] hanging for 30sec when checkpointing

2004-02-07 Thread Andrew Sullivan
and that SCSI has been, historically anyway, better at dealing with parallel loads. This is because of the historical design goals of the two different systems. Glib remarks about misinformation are easy to make, but don't really help anyone make decisions. A -- Andrew Sullivan | [EMAIL P

Re: [ADMIN] reduce downtime when upgrading 7.3 -> 7.4

2004-02-12 Thread Andrew Sullivan
th them, in fact, as its memory is limited by the JVM limits. The strategy is otherwise sound, though, and has even been used by, uh, some of us. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner --

Re: [ADMIN] Panic involving a LC_COLLATE issue

2004-02-20 Thread Andrew Sullivan
It looks like you need to initdb. > Aborted You need the locale support offered by the Red Hat system. Seems you need ISO 8859-15. My bet is either that Mandrake's locale doesn't support that, you don't have the right libs, or the binary you've installed wasn't co

Re: [ADMIN] How to do fast, reliable backups?

2004-03-06 Thread Andrew Sullivan
#x27;m not saying that master-slave systems are a bad idea, but you'd better be aware of what you're exposing yourself to before considering such hot-failover cases. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: su

Re: [ADMIN] How to do fast, reliable backups?

2004-03-07 Thread Andrew Sullivan
itted transactions. 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: sub

Re: [ADMIN] ERServer on Windows?

2004-03-07 Thread Andrew Sullivan
able on the gborg site. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] HIPAA

2004-03-08 Thread Andrew Sullivan
ind a techno fix to the problem. (I still like it that someone is spending some time on improving the crypto stuff, though.) A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspu

Re: [ADMIN] HIPAA

2004-03-09 Thread Andrew Sullivan
these data, nobody is actually going to be able to prevent such an attacker anyway. All you can do is limit your own liability in exposing data; and that means collecting as little (not as much) as you can, and then further attempting to protect the data you actually do collect. A -- Andrew

Re: [ADMIN] Restoring DB From A Log?

2004-03-22 Thread Andrew Sullivan
than erserver. You may also want to watch the PITR project, which appears to be aiming to get into 7.5. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate su

Re: [ADMIN] Hardware and OS for postgresql

2004-03-22 Thread Andrew Sullivan
IBM RS/6000 (P650), and it is one fast machine. It's sort of unfair to compare it to UltraSPARC II machines, but I certainly am impressed as compared to Sun's E4500. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde

Re: [ADMIN] access multiple PostgreSQL Databases at the same time.

2004-03-24 Thread Andrew Sullivan
s multiple PostgreSQL databases at the same time. Not separate schema, > but in different postgresql server. Doesn't seem like much security if you're going to break it by putting a back door in. But there's a contrib module called dblink that will likely help you. A -- Andrew S

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Andrew Sullivan
NOT_ be "free" > (again in their terms). To be fair to the FSF, they have never claimed that the original BSD license was not a free license. It just wasn't compatible with the GPL, because of the advertising clause. A -- Andrew Sullivan | [EMAIL PROTEC

Re: [ADMIN] Do Petabyte storage solutions exist?

2004-04-02 Thread Andrew Sullivan
here for some kinds of use (I think it provides my employer with a great advantage), but it likely needs a few more features to take the last steps. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all l

Re: [ADMIN] Do Petabyte storage solutions exist?

2004-04-05 Thread Andrew Sullivan
On Fri, Apr 02, 2004 at 03:32:27PM +, Bricklen wrote: > Anyways, ss they say, "You get what you pay for". This has not been my experience at all. The correlation between software price and quality looks to me to be something very close to random. A -- Andrew Sullivan | [EM

Re: [ADMIN] Data replication

2004-04-20 Thread Andrew Sullivan
k it's safe to say that it isn't ready for that. 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 H

Re: [ADMIN] Recycled Log Files

2004-04-30 Thread Andrew Sullivan
t; have gone away in this version or I would have increased that as well. > Actually, this is a good thing: it means the logs are getting cleared and available for re-use. But what I'm wondering is why you're going through them so fast. What are you doing in this period? A --

Re: [ADMIN] GNUmakefile size 0

2004-05-18 Thread Andrew Sullivan
want to grovel through recentish archives (last 3 months or so) for a post from Chris Browne. He posted a workaround for configure woes on Sol 8, and I bet it'll work for 9 also. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)

Re: [ADMIN] tcpip_socket=false and psql is working?

2004-05-28 Thread Andrew Sullivan
-h 127.0.0.1; if that works, you have a problem. A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] postmaster stopps

2004-10-19 Thread Andrew Sullivan
t. You'll probably want to send the output through a log rotator if you increase the verbosity: multi-gig log files aren't so good. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] NIC to NIC connection

2004-10-19 Thread Andrew Sullivan
ra_ IP address so that the web servers don't have to compete for the bandwidth? In that case, sure, you'll probably get a minor performance increase, depending on your current network traffic. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes sh

Re: [ADMIN] NIC to NIC connection

2004-10-19 Thread Andrew Sullivan
On Tue, Oct 19, 2004 at 12:11:20PM -0500, [EMAIL PROTECTED] wrote: > > Depends on the NIC. If your running 100MBS Ether and put in 1GBS Ether or > fiber, it would make a difference. Not if you're not using 100 megs in the first place :) A -- Andrew Sullivan | [EMAIL PROTECT

Re: [ADMIN] Large transaction problem

2004-11-12 Thread Andrew Sullivan
it for most cases. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [ADMIN] Large transaction problem

2004-11-12 Thread Andrew Sullivan
nd for quite a while. > BTW, thanks. I removed the --full option. My bet is that will help matters. 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 Post

Re: [ADMIN] Usenet Discussion Proposal

2004-11-18 Thread Andrew Sullivan
Usenet, please. 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)--- TIP 5

Re: [ADMIN] Load Balancing/Multiple Postgres Machines

2004-12-06 Thread Andrew Sullivan
mmense speed improvement by moving from 7.2.x to 7.4.x -- so much so that my QA guys didn't believe their tests the first time, and ran them all again. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem.

Re: [ADMIN] Very busy 24x7 databases and VACUUM

2004-12-06 Thread Andrew Sullivan
vacuum has the ability really to kill performance if it starts at the wrong moment. You need something much more hand-crafted at the moment. I'll bet, however, that vacuuming some tables more often than once a day will still be a net win for you. A -- Andrew Sullivan | [EMAIL PROTECTED] This wor

Re: [ADMIN] upgrading postgresql

2004-12-15 Thread Andrew Sullivan
replicate from 7.3.x -> 7.4.y (where x >2) -- catch up -- move set We've had quite a few reports of big successes upgrading this way; it works well if you have the disk space. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that vis

Re: [ADMIN] Tyan Thunder MB for postgres server

2004-12-16 Thread Andrew Sullivan
overy cost. In most 0+1 arrangements (I'm aware of none which don't do this), you have to re-sync the entire thing in case you lose even one drive. Performance really suffers at that point. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *d

Re: [ADMIN] Too frequent warnings for wraparound failure

2005-03-17 Thread Andrew Sullivan
y bet is you're missing one. template1, perhaps? 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: [ADMIN] Clustering

2005-03-23 Thread Andrew Sullivan
't really do this today. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Any examples of companies using PG in high volume and/or large scale environs...

2005-03-23 Thread Andrew Sullivan
case it helps, we do have one system with absolutely critical financial data in it, which we anticipate will be a TB in not very long. Postgres has performed well for us so far, thanks partly to the team of great DBAs I've been able to assemble. A -- Andrew Sullivan | [EMAIL PROTECTED] This

Re: [ADMIN] how to add a new data partition

2007-02-06 Thread Andrew Sullivan
stem tools to do this. I know you _can_, but I haven't done it recently on Linux. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- T

Re: [ADMIN] database encryption

2007-02-07 Thread Andrew Sullivan
On Wed, Feb 07, 2007 at 11:23:03AM +0100, Olivier Boissard wrote: > I saw on the web that there is a contrib (pgcypto) but I can't estimate > its efficiency Well, it works for some people. What are you trying to accomplish with "database encryption"? A -- Andrew Sulliva

Re: [ADMIN] Measuring statement runtime?

2007-02-07 Thread Andrew Sullivan
ee the full execution plan, plus information about how long each step _actually_ takes. 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."

Re: [ADMIN] Manual trigger removal [WAS] Flushing Postgres Function Cache

2007-05-17 Thread Andrew Sullivan
id you do any DDL with Slony installed, without using EXECUTE SCRIPT? A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Can I restrict backups?

2007-05-23 Thread Andrew Sullivan
hiring people you can trust. But you could restrict the subset of the data they can see using VIEWs. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)

Re: [ADMIN] Desaster Recovery from failover using SLONY-I

2007-05-30 Thread Andrew Sullivan
hiving backup method. When you subscribe a datbaase, it automatically drops and recreates the target from scratch. There has been some discussion of how to improve that, but AFAIK nobody has written the support for it yet. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are f

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Andrew Sullivan
would be very interested to see a set-up that can actually guarantee 99.99% uptime across a wide area link. What write speeds do you need in the database? What is your tolerance for loss of committed data? A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Andrew Sullivan
coast solutions, for instance, will make the latency such that users will certainly be able to see it.) A -- Andrew Sullivan | [EMAIL PROTECTED] However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-31 Thread Andrew Sullivan
tartup requirements on the slave. Right, and the requirement was actually upped to 99.99%, which is approximately 1 hour of allowable downtime a year. That is a very high bar. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy and hard to use, b

Re: [ADMIN] Deletes hurt

2007-05-31 Thread Andrew Sullivan
the cost of maintenance outside the main transaction path is intrinsically superior, because you don't have to pay it while your user is sitting there waiting for you. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data.

Re: [ADMIN] the right time to vacuum database?

2007-06-05 Thread Andrew Sullivan
rmation about how many pages it is recovering. 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 2: Don't 'kill -9' the postmaster

Re: [ADMIN] the right time to vacuum database?

2007-06-06 Thread Andrew Sullivan
have been increased in 18 hours. > what's wrong with my PostgreSql Server? Maybe nothing. How much data do you think you're putting in there? What does VACUUM VERBOSE say, as I asked about -- are you getting a lot of dead space? A -- Andrew Sullivan | [EMAIL PROTECTED] The wh

Re: [ADMIN] the right time to vacuum database?

2007-06-07 Thread Andrew Sullivan
this suggests you don't have bloat on that table at least. So it sounds to me like your disk use is going up because you have a lot of data. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become

Re: [ADMIN] reclaiming disk space after major updates

2007-06-07 Thread Andrew Sullivan
ostgres. Another trick, if the table is otherwise mostly static, is to do the updating in a copy of the table, and then use the transactional DDL features of postgres to change the table names. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happ

Re: [ADMIN] reclaiming disk space after major updates

2007-06-08 Thread Andrew Sullivan
to do this sort of thing, and breaking into groups of a couple thousand or so really made the difference. 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.

Re: [ADMIN] the right time to vacuum database?

2007-06-08 Thread Andrew Sullivan
pty space around for new data, which means you don't have to go down to the filesystem to make the file bigger before you write it it. This is a Good Thing.) Please go back and run VACUUM VERBOSE on the table you killed the vacuum on before. A -- Andrew Sullivan | [EMAIL PROTECTED] However

Re: [ADMIN] the right time to vacuum database?

2007-06-08 Thread Andrew Sullivan
t. I have the feeling, on the basis of this thread, that you need to spend some more time with the manual. 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.

Re: [ADMIN] AIX - best practices?

2007-06-18 Thread Andrew Sullivan
ixen as far as > PostgreSQL goes? As they say in alt.sysadmin.recovery, all operating systems suck. They don't usually say, however, that AIX, when pronounced as a word, is the only one that actually describes what it gives you. All best, A -- Andrew Sullivan | [EMAIL PROTECTED] I reme

  1   2   3   >