[GENERAL] info on people running postgre
hi, I am going to be implementing an online database and was considering oracle on an ultra, until i checked the price and 2,000 dollars, no way. I have used mSQL and looked at mySQL and now am aware of postgres and have heard that it is the most robust and well used of the freeware databases. Is this correct? Also i am wondering about it's realibility, stability, scalability, etcetera? Can anyone point me in the right direction for this info. Also is there a web page or list of people running postgres, with their configurations, connections and what not. I would like to know that their are other people using postgres for commercial web sites. The whole company will depend on the database and so i just don't want to be the only person doing this. When i implemented mSQL for this things weren't nearly as important and performance and scalability weren't as essential. Any help, comments, advice would be greatly appreciated. Eric Enockson
[GENERAL] pg_dumpall error!
I'm getting the following error when running a pg_dumpall -z >db.out failed sanity check, opr with oid 67473 was not found How can I trace what oid 67473 is ? -- C'ya! Valerio Santinelli a.k.a. TANiS [[EMAIL PROTECTED]]+:+[http://www.mediacom.it/~tanis]
Re: [GENERAL] info on people running postgre
Personally, I find PostgreSQL to be good for non mission critical databases. I have used it for many commercial sites, but none that are "heavy" usage, zero down time. PostgreSQL is a fine database with many features, but there are database recovery/space usage issues that, I think, keep it from being usable for all applications. The SQL engine is for the most part ANSI compliant and the SQL translates well to other databases like Oracle. I don't know about user defined database level functions...those probably require rewriting. Performance wise, postgreSQL is fast. If there are probs then you probably have run into the few performance tweak issues that you can find listed in the archives... The fact that you are coughing at $2000 dollars probably indicates that the application isn't mission critical and postgreSQL probably would work fine as long as you keep in mind that backups are very important in postgreSQL and that vacuuming often will save you lots of headaches. -Original Message- From: Eric Enockson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, March 25, 1999 1:59 AM Subject: [GENERAL] info on people running postgre > hi, > >I am going to be implementing an online database and >was considering oracle on an ultra, until i checked the price >and 2,000 dollars, no way. I have used mSQL and looked >at mySQL and now am aware of postgres and have heard that it >is the most robust and well used of the freeware databases. >Is this correct? Also i am wondering about it's realibility, >stability, scalability, etcetera? Can anyone point me in >the right direction for this info. Also is there a web page >or list of people running postgres, with their configurations, >connections and what not. I would like to know that their >are other people using postgres for commercial web sites. >The whole company will depend on the database and so i just >don't want to be the only person doing this. When i >implemented mSQL for this things weren't nearly as important >and performance and scalability weren't as essential. > > >Any help, comments, advice would be greatly appreciated. > >Eric Enockson >
[GENERAL] 8000 photos in a database
Hi! http://oslo.clickwalk.no/ http://lwn.net/1999/0325/a/clickwalk.html 8000 photos in PostgreSQL database. RedHat linux, Apache httpd, Java serlets. Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.
[GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
When I try to vacuum, or vacuum analyze my database, I get the following error: FATAL 1:btree: BTP_CHAIN flag was expected I've tried the following two commands: /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing and /usr/local/pgsql/bin/psql -c "vacuum;" billing The top command used to work (for the last few years), so I assume that something has changed with my data. Otherwise, the database appears to be working ok. Any pointers? I'm thinking about dumping all the data and re-inserting it... Jay Summet
RE: [GENERAL] info on people running postgre
Hi, We have tryed PostgreSQL as the backend of a Java application used to collect orders and other information. Everything would have been fine but for the lack of row-level locking, and some problems with processes that go hanged when locked for to long. Also we have experienced a couple of corruptions on a table that suffers the deletion and insertion of 46000 records every day, and some sporadic and misterious backend crashes. Table-locking has forced us to quit from PostgreSQL and move to Oracle. So if you need a read-only (or single user) database with moderate performance (any comercial one is faster), PostgreSQL will probably give you what you need in this other aspects: good SQL, ease of use and administration, really thin JDBC type 4 driver; and you may find to need more of: Export/import tools Backend stability Crash recovery Programming interfaces doc. Best luck, Juan Alvarez Ferrando
[GENERAL] macaddr
Is there some documentation on the macaddr type anywhere? Cheers, Patrick
[GENERAL] Re: [SQL] sql 92 support in postgres
Eric - I've redirected your question to the general list, since it seems to fit in there better than the sql list. I think you're confusing mySQL's limitations with those of PostgreSQL (PG from here on) - PG does in fact support views, has for quite a while. They're even updateable. With each release, more and more of the SQL92 function set is implemented, and what's not can usually be worked around. I'm new to all this DB stuff, myself, but I haven't bumped up against limitations of the implementation yet - I hit the limits of my knowledge first! As to mySQL, I've never used it, but I understand it's a very fast, but limited, subset of SQL. The biggest drawback I see referenced is the lack of transaction support. My 2 cents, Ross Eric Enockson wrote: > > > hi, > > I am going to be implementing an online database and > was considering oracle on an ultra, until i checked the price > and 2,000 dollars, no way. I have used mSQL and looked > at mySQL and now am aware of postgres and have heard that it > is the most robust and well used of the freeware databases. > Is this correct? Also i am wondering about it's sql 92 support, > i see that it doesn't have views and some other things, but my > question is this. For those of you who are using it, what is your > opinion of it's functionality sql wise? Is it sufficient, do > wish that you had more? If you could afford it would you rather > be using oracle? I can afford oracle as i'm not going to be > paying, but 2000 just seems unresonable. I don't want to > pay for suits and corporate planes, i just want to run software. > > Any help, comments, advice would be greatly appreciated. > > Eric Enockson -- Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
Re: [GENERAL] Re: [SQL] sql 92 support in postgres
I second the opinion that postgreSQL implements a very flexible and extensive set of SQL functionality. $2000 is chump change if the application is a mission critical one. The Costs of losing the data or downtime of the database easily exceed $2000 (in probably the first minutes of downtime). I think in your choice of databases this is one of the more important factors to consider. There are also many competitors to Oracle too out there which you might want to consider... PostgreSQL is great especially since its free. It fills the niche nicely for low cost med intensity applications like small/med size business e-commerce apps. I don't think I would want to run something like a multi national manufacturing firm's real time data acquisition system off of the database. -Original Message- From: Ross J. Reedstrom <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: PGSQL-General (E-mail) <[EMAIL PROTECTED]> Date: Thursday, March 25, 1999 2:22 PM Subject: [GENERAL] Re: [SQL] sql 92 support in postgres >Eric - >I've redirected your question to the general list, since it seems to fit >in there better than the sql list. I think you're confusing mySQL's >limitations with those of PostgreSQL (PG from here on) - PG does in fact >support views, has for quite a while. They're even updateable. With each >release, more and more of the SQL92 function set is implemented, and >what's not can usually be worked around. I'm new to all this DB stuff, >myself, but I haven't bumped up against limitations of the >implementation yet - I hit the limits of my knowledge first! > >As to mySQL, I've never used it, but I understand it's a very fast, but >limited, subset of SQL. The biggest drawback I see referenced is the >lack of transaction support. > >My 2 cents, > >Ross > >Eric Enockson wrote: >> >> >> hi, >> >> I am going to be implementing an online database and >> was considering oracle on an ultra, until i checked the price >> and 2,000 dollars, no way. I have used mSQL and looked >> at mySQL and now am aware of postgres and have heard that it >> is the most robust and well used of the freeware databases. >> Is this correct? Also i am wondering about it's sql 92 support, >> i see that it doesn't have views and some other things, but my >> question is this. For those of you who are using it, what is your >> opinion of it's functionality sql wise? Is it sufficient, do >> wish that you had more? If you could afford it would you rather >> be using oracle? I can afford oracle as i'm not going to be >> paying, but 2000 just seems unresonable. I don't want to >> pay for suits and corporate planes, i just want to run software. >> >> Any help, comments, advice would be greatly appreciated. >> >> Eric Enockson > >-- >Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]> >NSBRI Research Scientist/Programmer >Computer and Information Technology Institute >Rice University, 6100 S. Main St., Houston, TX 77005 >
RE: [GENERAL] info on people running postgre
On Thu, 25 Mar 1999, Juan Alvarez Ferrando wrote: > > collect orders and other information. Everything would have been fine but > for the lack of row-level locking, and some problems with processes that go > I'm not yet doing anything in a production environment yet, but the next version of postgresql does has something more advanced than row level locking, MVCC. I've been running the CVS version during development and it seems quite a bit faster than 6.4.2 as well. I'm seriously thinking about scraping my Oracle DB at work and replacing it with postgresql. Why? One...Oracle is on site license so I'm not out any money if I switch :-) Two...Oracle is an absolute hog when it comes to memory and disk space. Here is a look at top viewing an idle Oracle DB on a Solaris system PID USERNAME PRI NICE SIZE RES STATE TIME WCPUCPU COMMAND 6174 oradba230 33M 12M sleep 0:00 0.18% 0.12% oracle 6166 oradba330 35M 12M sleep 0:00 0.16% 0.11% oracle 6168 oradba330 33M 10M sleep 0:00 0.13% 0.08% oracle 6170 oradba330 33M 10M sleep 0:00 0.13% 0.08% oracle 6176 oradba270 33M 10M sleep 0:00 0.08% 0.05% oracle 6172 oradba330 33M 10M sleep 0:00 0.08% 0.05% oracle 351 oradba330 11M 2944K sleep 0:00 0.03% 0.02% tnslsnr Three...By adopting postgresql as my primary db I hope to help the free software community by dealing with problems as they come up and submitting problem reports. The people on the dev team have always been helpful so I'm not too worried that I'll get burned. On a related note. I'm currently working with a local company to automate their entire business process and GPL the resulting code. Postgresql is currently the data storage system of the backend. We are betting that a freeware solution with (hopefully) free software community support will provide a better solution in the long run than a propritary one. So you will not be alone in depending upon postgresql. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
[GENERAL] Postgres logo, copyrights, etc...
Hi all, I'd like to know if there is any 'postgresql-powered' (or sg. like that) logo available on the net. I have checked a few ftp and web sites and been searching for it but without success. (I just want to use it on a website which is 'postgres-powered' really!) My other problem/question is about copyrights. I developed a registry-system for universities using Java, JDBC, Postgres and Linux and I planning to sell it but before I do anything I'd like to know if it's legal... I'd give these "helper-tools" along with my system (and with source) and I'd only charge for what I did, however I know that this program depends on all of the above. Please, someone tell me if it's OK or not. Thanks in advance, Peter Blazso
Re: [GENERAL] Re: [SQL] sql 92 support in postgres
At 14:59 3/25/99 -0500, you wrote: >I second the opinion that postgreSQL implements a very flexible and >extensive set of SQL functionality. > >$2000 is chump change if the application is a mission critical one. The >Costs of losing the data or downtime of the database easily exceed $2000 (in >probably the first minutes of downtime). I think in your choice of >databases this is one of the more important factors to consider. There are >also many competitors to Oracle too out there which you might want to >consider... Yes, it is chump change, and Oracle is not the only answer (although they would like you to believe it). Informix, DB-2, Sybase, Solid are all good data bases and also run on Linux. Competition is wonderful! Regards, Jim FSC - Building Better Information Technology Solutions- From the Production Floor to the Customer's Door. Jim Jennis, Technical Director, Commercial Systems Fuentez Systems Concepts, Inc. 1161Y Winchester Ave. Martinsburg, WV. 25401 USA. Phone: +001 (304) 264-2290 FAX: +001 (304) 263-8777 Email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---
Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuumcommand)
On Thu, 25 Mar 1999, Jay W. Summet wrote:
> When I try to vacuum, or vacuum analyze my database, I get the
> following error:
> FATAL 1:btree: BTP_CHAIN flag was expected
>
> I've tried the following two commands:
> /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing
> and
> /usr/local/pgsql/bin/psql -c "vacuum;" billing
>
> The top command used to work (for the last few years), so I assume
> that something has changed with my data. Otherwise, the database
> appears to be working ok.
>
> Any pointers? I'm thinking about dumping all the data and
> re-inserting it...
Try just drop'ng and rebuilding your indices...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
RE: [GENERAL] info on people running postgre
On Thu, 25 Mar 1999, Juan Alvarez Ferrando wrote:
> Hi,
>
> We have tryed PostgreSQL as the backend of a Java application used to
> collect orders and other information. Everything would have been fine but
> for the lack of row-level locking, and some problems with processes that go
> hanged when locked for to long. Also we have experienced a couple of
> corruptions on a table that suffers the deletion and insertion of 46000
> records every day, and some sporadic and misterious backend crashes.
>
> Table-locking has forced us to quit from PostgreSQL and move to Oracle. So
> if you need a read-only (or single user) database with moderate performance
> (any comercial one is faster), PostgreSQL will probably give you what you
> need in this other aspects: good SQL, ease of use and administration, really
> thin JDBC type 4 driver; and you may find to need more of:
>
> Export/import tools
pg_dump and psql
> Backend stability
would love to see more information on this ..
> Crash recovery
> Programming interfaces doc.
huh?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
Re: [GENERAL] Postgres logo, copyrights, etc...
On Thu, 25 Mar 1999, Peter Blazso wrote:
> Hi all,
>
> I'd like to know if there is any 'postgresql-powered' (or sg. like that)
> logo available on the net. I have checked a few ftp and web sites and
> been searching for it but without success. (I just want to use it on a
> website which is 'postgres-powered' really!)
Over the past several works, there has been extensive work done on coming
up with something, and today, it was "provided"...hopefully, over the next
few days, it will be publicly announced, but there are still a few "bugs"
being worked out of it ...
> My other problem/question is about copyrights. I developed a
> registry-system for universities using Java, JDBC, Postgres and Linux
> and I planning to sell it but before I do anything I'd like to know if
> it's legal... I'd give these "helper-tools" along with my system (and
> with source) and I'd only charge for what I did, however I know that
> this program depends on all of the above.
Go for it...there is nothing that says you cannot use PostgreSQL, or
distribute it, as part of one of your projects...another bonus over things
like Oracle and Informix :)
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
[GENERAL] V6.4.2 port to SCO Openserver 5.0.5
Is there a binary for this port? Or is there a HOW-TO to compile this. I have seen some threads on 6.3 but I am trying to compile 6.4.2 and it is failing with an error 2 and a few other errors in the make. TIA -- "Mr. Scott ..One to Beam up!" John J. Boris, Sr. JEN-A-Sys Administrator Archdiocese of Philadelphia Tel: 215-587-0579 Fax: 215-587-3525 email:[EMAIL PROTECTED] begin:vcard n:Boris, Sr.;John J. tel;fax:215-587-3525 tel;work:215-587-0579 x-mozilla-html:FALSE org:Archdiocese of Philadelphia;Office of Financial Services version:2.1 email;internet:[EMAIL PROTECTED] title:JEN-A-SyS Administrator adr;quoted-printable:;;222 North 17th Street=0D=0A5th Floor;Philadelphia;PA;19135-1299;USA fn:jboris end:vcard
