[GENERAL] Re: [HACKERS] custom types and optimization
On Sun, 31 May 1998, The Hermit Hacker wrote: > On Sun, 31 May 1998, David Gould wrote: > > > > I hate to use myself as an example...but why do I hate Linux? And > > > why wouldn't I recommend anyone to use it? Past Experience. > > > > Ok, why do you hate Linux? I have been using it since 94 and am happier than > > a pig in mud. Maybe I am easy to please (doubtful) or maybe I am missing > > something? I don't want to start an OS war here (there are enough of those > > in other places), so please reply (if you choose to do so) privately. > > No no, this wasn't meant to start a flame war...most of the > oldtimers here know of my hatred for Linux, and I've admitted often that > with Linux today, it is pretty unfounded... > > I used Linux pre-94...pre-v1.0..in a business/production > environment. At that time, I was hard-core Linux advocate...it was the > greatest thing since sliced bread, but, the day I hoooked it onto the > Internet, keeping it alive more then 24hrs was a chore, and it was all in > the TCP/IP networking code...switched to *BSD and have been here ever > since... I'd gone thru similar, but a more recent set of experiences have soured me. I've seen some out-of-the-box linux installations failing from overload where the equivelent in a FreeBSD environment wasn't. When I'd have 200+ users getting their email and a bunch of 'em also getting their web pages hit, nasty things were hitting the fan. As an admin it's a problem that eventual tuning wasn't good enuf. When you have PAYING customers crabbing about the services they're paying for not being up to their expectations, as a provider you have to answer to 'em. We were able to get a couple of linux boxen going to meet the need, but our experiences beyond that were that a FreeBSD box was able to instantly provide a much higher level of service with a much higher level of reliability to it for a lower cost (the cost of setting things up is, of course, figured into the overall cost). Do I wanna see all of the linux boxen removed? No way! Most of the security exploits are written to run on a linux platform. I don't need to waste any time porting an exploit to a FreeBSD machine (no matter how easy it is) just to make sure my machines aren't vulnerable. My personal opinion? Use the proper OS for the job at hand. I can come up with jobs that are best suited to many operating systems. If you want to choose an operating system that's not up to par with what you need to do or what your PAYING customer needs? Then you need to rethink your business strategies. For what I do, OS/2 provides me with the tools I need. For what my wife does, 95 is her choice. For my news machines and web servers, it has to be UN*X and currently that platform is FreeBSD. At work, it's HP-UX. You gotta use the proper tool for the job or you're only screwing yourself. The way you evaluate the tool is noone's responsibility but your own. Make the proper decision and you keep your customers; blow it and someone else gets your customers. Personally I don't like those all nite panic sessions. Vince. -- == Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] flame-mail: /dev/null # includeTEAM-OS2 Online Searchable Campground Listingshttp://www.camping-usa.com "I'm just not a fan of promoting stupidity! We have elected officials for that job!" -- Rock ==
[GENERAL] Re: [HACKERS] NEW POSTGRESQL LOGOS
On Thu, 4 Jun 1998, The Hermit Hacker wrote: > On Thu, 4 Jun 1998, Matthew N. Dodd wrote: > > > On Wed, 3 Jun 1998, Ken McGlothlen wrote: > > > Already taken by Apple's Quicktime product. However, a cross between > > > the BSD daemon 'toon and a penguin would be fairly funny; a red and > > > white penguin with horns and a long, barbed tail? :) > > > > How about the BSD daemon and the Linux penguin clubing down baby harp > > seals? > > How about the BSD daemon just saving time and clubbing down the > Linux penguin? :) I was thinking maybe the BSD daemon grilling the Linux penguin. :) Vince. -- == Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] flame-mail: /dev/null # includeTEAM-OS2 Online Searchable Campground Listingshttp://www.camping-usa.com "I'm just not a fan of promoting stupidity! We have elected officials for that job!" -- Rock ==
[GENERAL] RE: cant connect
redirected to general - We are trying to use psql on RedHat 5.2 to access a database on another Redhat 5.2 box runing Postgres (started as user postgres: postmaster -D /var/lib/pgsql -B 256 -i -d 3 &.) The backend start okay and we can access the data on the local machine runing psql but cannont on another machine on the same net. We tried adding PAM modules and adding the tcp port to the services files. We tried to log in as many different users but it just keeps telling us on the remote and local machine that authenication has failed. What could we be doing wrong? Any help would be greatly appreciated. Joe
[GENERAL] RE: PostgreSQL 6.5.2 Released ...
On 17-Sep-99 The Hermit Hacker wrote: > > Tonight, we officially release v6.5.2 for those that have been > experiencing problems with either v6.5 or v6.5.1. I've created two > patches, one from 6.5->6.5.1 and one from 6.5.1->6.5.2 ... please let me > know if there are any problems with them... > > Vince, can you please make links for the patches as well as the release > itself? Done. Vince. -- ====== Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] flame-mail: /dev/null # includeTEAM-OS2 Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] Re: search.cgi not found on ur site
On Tue, 16 May 2000, siva wrote: > hello, > > i'm a web server administrator of clickcricket.com, i was tried to get some >information on postgres database tools, when i clicked search postgres link; it was >given me a search.cgi not found error. pls. check this minor mistakes from the major >site of postgres. We had a disk crash and we're still finding things missing or in the wrong place. Thanks! > and i also wants to know how to find and delete duplicate values from postgres >database(primary key not defined). and i dont wants to go thru. any other books or >reference . give me the correct syntax : > > my table name is : cricktimes2 > and the field name to be sorted is : email I'm CCing this one to the general mailing list. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Postgres Instability
On Wed, 24 May 2000, The Hermit Hacker wrote: > On Wed, 24 May 2000, planx plnetx wrote: > > > I've remarked that postgresql-7.0 have two important bugs no, no... > > I'll define its Problems. > > > > The first is that it is very subsceptible to ipc: it's true that sometimes > > U need to do an ipcclean to remake it start > > This sounds like a Linux problem to me ... I've got v7.0 running on a > server over here that is dealign with the Search engine for the PostgreSQL > site (over 10million tuples in one table, indexing over 90k URLs) and the > server has been running flawlessly for the past ~14days now, and what is > only because that was the last time we rebooted it ... Ditto, except the uptime here (PostgreSQL running all the time taking care of user's mailboxes, web server, etc.): 265 days, 20:43 running FreeBSD-3.2-Rel. Vince. > > > > > > > The second is the very VERY important instability problem. > > I explain me better: I've tried Postgres on different systems > > (redhat6.0,6.1, mandrake7.0) and every time after that I make start the > > postmaster 20 or 30 times in a week or 2, it begin to have a problem > > with shared memory, but i do an ipcclean and go..., after when > > postmaster run without problems if I do a createuser (from sqladmin) or > > a createdb (from user) it give me the same problem like: > > > > > > FATAL 1: cannot create init file > > mydatabasedirectory//base/mydb/pg_internal.init > > > > > > it happens after few times of correct running... and persist also if I > > recompile again postgresql > > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy > Systems Administrator @ hub.org > primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org > > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Postgresql usage clip.
On Tue, 30 May 2000, Joseph Shraibman wrote: > Jan Wieck wrote: > > > > Ron Chmara wrote: > > > "Brett W. McCoy" wrote: > > > > MySQL is great for small websites with small budgets with read-only data > > > > or data that doesn't change often. It doesn't scale very well at all, and > > > > for larger sites it really falls apart without anyy referential integrity > > > > or supprto for views. But beyond that, you really need something bigger > > > > like Postgres (for a big site with a small budget) or Oracle (for a huge > > > > site with a huger budget). > > > > > > Have a db comparison toy. Lots of fun. > > > > > > http://mysql.com/crash-me-choose.htmy > > > > There was some discussion about exactly that crashme this > > month. Some detailed analysis turned out that many places > > where it says "unsupported" in reality mean "does not support > > MySQL's non standard syntax". Others are totally mislabeled. > > > > And on the performance, it triggered a problem in PostgreSQL > > that is unlikely in real world scenarios (creating and > > dropping 20,000 tables first, blowing up a system catalog). > > Then running the test queries with the blown up catalog. > > Really smart benchmark :-) > > Well it *is* called crashme. > Doesn't really matter what it's called if it's sole purpose is to make your product loog good and everyone else's look bad, it may as well come from Redmond. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] troubles installing postgresql6.4
On Tue, 6 Jun 2000, Marcos Lloret wrote: > hi, > > i do not know what superuser account i made. so i am not able to do > initdb.. it says.. > > We are initializing the database system with username X > (uid=500). > This user will own all the files and must also own the server > process. > > mkdir: cannot create directory > `/usr/local/pgsql/data/base/template1': Relaying denied. > Creating template database in /usr/local/pgsql/data/base/template1 > ERROR: cannot create pg_proc > ERROR: cannot create pg_proc > initdb: could not create template database > initdb: cleaning up by wiping out > /usr/local/pgsql/data/base/template1 > > what should i do > > thanks in advance, > > marcos > [EMAIL PROTECTED] > > Start by installing version 7.0.2 which is available at: http://www.postgresql.org then follow the installation instructions carefully and you'll be up and running in a very short time. On a decently fast machine it shouldn't take but 30-60 minutes (longer if you're on a slow internet connection). Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Postgresql
On Wed, 7 Jun 2000, Bruce Momjian wrote: > [ Charset ISO-8859-1 unsupported, converting... ] > > The following is a quote from a consultant's opinion on my intention to > > migrate to Postgresql. > > Quote: > > The use of Postgres is cautioned for mission critical data by the developers > > of Postgres themselves. > > Unquote. > > Please comment. > > > > I have been around for 4 years, and have never heard that said by anyone > closely related to the project. I recall seeing that quote somewhere, but it wasn't on our site nor was it said by anyone associated with Postgres. I'm thinking it was in either an online magazine or something like that. It was many months ago, tho. Almost a year, perhaps longer. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] anoncvs access
On Wed, 7 Jun 2000, Tom Lane wrote: > Travis Bauer <[EMAIL PROTECTED]> writes: > > I'm trying to get the tree from the cvs: > > cvs -d :pserver:[EMAIL PROTECTED]:/usr/local/cvsroot login > > It's /home/projects/pgsql/cvsroot now. > > I notice http://www.postgresql.org/docs/postgres/cvs28436.htm > still has the old location :-( ... that needs to be updated. > Hey Vince, isn't that stuff supposed to be rebuilt from sources > nightly? Tom Lockhart said he had to disable the auto build because it was failing something to do with Jade, I think. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Re: [INTERFACES] Re: Link to postgesql components
On Mon, 10 Jul 2000, Byron Nikolaidis wrote: > > While you're at it... > > How about links to all the other front-ends, like the odbc and jdbc drivers > for example? I know there are plenty more front-ends and useful things > that should appear in some kind of "links" section or something. Already did it. Look at Info Central | Interfaces Vince. > I went looking for the jdbc driver on the postgresql.org site today and > spent several frustrating minutes looking for it but could not find it. All > I wanted was the latest jar files. I had to resort to going to yahoo and > searching for it, and then found Peter's site. > > This seems not so good to me. Is it that hard to have a section for > front-ends and other things? A simple one line description and a link > would be all that's necessary. > > Byron > > - Original Message - > From: Vince Vielhaber <[EMAIL PROTECTED]> > To: Bruce Momjian <[EMAIL PROTECTED]> > Cc: Sergey Seroukhov <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > PostgreSQL-general <[EMAIL PROTECTED]>; PostgreSQL-interfaces > <[EMAIL PROTECTED]> > Sent: Monday, July 10, 2000 9:47 PM > Subject: [INTERFACES] Re: Link to postgesql components > > > > > > I'm just waiting on a 2-3 line description for the web page from him. > > I already requested it. > > > > Vince. > > > > On Mon, 10 Jul 2000, Bruce Momjian wrote: > > > > > I am CC'ing the webmaster to add this to our site, and the general list > > > so they know it exists. Thanks. > > > > > > > > > [ Charset KOI8-R unsupported, converting... ] > > > > Hello! > > > > > > > > Some time ago we talk about link to Delphi components for > > > > PostgreSql. > > > > > > > > We not so long ago made a new site http://www.zeos.dn.ua > > > > and release a new 4.0 version for postgresql users. > > > > > > > > Tests of latest 4.1 version show that our components > > > > faster more than 85% that PostgreSqlODBC+BDE and have some > > > > extra capabilites. More over these components are OpenSource > > > > and Freeware that correspond to spirit PostgreSql. > > > > > > > > Regrettably postgresql users nearly do not know about our > > > > components. Can you make a links on your site and documentation > > > > for Zeos Database Objects (current version is 4.0)? > > > > > > > >Regards, > > > > > > > > Sergey Seroukhov, leader of Capella Development Group > > > > > > > > > > > > > > > > > -- > > ====== > > Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net > > 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking > > Online Campground Directoryhttp://www.camping-usa.com > >Online Giftshop Superstorehttp://www.cloudninegifts.com > > == > > > > > > > > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: Re: [GENERAL] Logging Help Needed
On Mon, 17 Jul 2000, Oakley wrote: > > -- > > On Mon, 17 Jul 2000 13:19:33 leonbloy wrote: > >> "Oakley " <[EMAIL PROTECTED]> writes: > >> > When I did the configure, I did it with > >> > --enable-syslog and with the --without-CXX > >> > options. I read the online docs and created a > >> > file in the /usr/local/pgsql/data directory > >> > called postgresql.conf, and put in the options > >> > I wanted, those being: > >> > >> Sigh. We've *really* got to rearrange the website so that the most > >> visible set of docs are for the latest release, not for the development > >> tip version. You're trying to use configuration features that will be > >> in 7.1, but they're not there now. See the docs that came with 7.0.* > >> instead. > >> > >>regards, tom lane > >> > > > >Hee ... I was caught by that one... > >http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html > > > >So many programs apologize for not having the docs > >updated with the software... > >Postgres must be the only one having docs on line that > >apply to a future version :- > > > >Regards > > > >Hernan > > > > First off, lemme say thanks to everyone... now I have one more thing... > > where are the docs that go along with the current version? I have browsed and >rebrowsed the site and everything seems to stick right with the forthcoming version... It's not yet ready for prime time, but you can find the docs here: http://www.Postgresql.org/users-lounge/index.html Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Logging Help Needed
On Mon, 17 Jul 2000, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > So many programs apologize for not having the docs > > updated with the software... > > Postgres must be the only one having docs on line that > > apply to a future version :- > > Yup ;-). It's nice having the devel docs up there, but seems like they > ought to be labeled or segregated or something. > > I have the following bookmarks: > > http://www.postgresql.org/docs/postgres/index.html">PostgreSQL > manual (development version at hub.org). > > HREF="http://www.postgresql.org/users-lounge/docs/7.0/postgres/postgres.htm">PostgreSQL > manual (7.0 release at hub.org). It changed from that one, and I don't know how. Originally it was users-lounge/7.0/docs/... Then it became users-lounge/docs/7.0/... I checked it earlier when it didn't work and now it's: users-lounge/docs/v7.0/... I just can't wait to see what it'll become in August! so the corrected link is: http://www.postgresql.org/users-lounge/docs/v7.0/postgres/postgres.htm Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Quoting routines in libpq
On Tue, 18 Jul 2000, Peter Eisentraut wrote: > Denis Perchine writes: > > > Just a small question: why there is not any quoting routine in libpq. > > Can you give an example of what it should do? Just as a guess, something that parses a string and escapes single quotes, backslashes and stuff like that. I rolled my own for apps that I worked on that needed one, lately I've been using PHP which has such a function and a reversing function. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Logging Help Needed
On Tue, 18 Jul 2000, Thomas Lockhart wrote: > > > Yup ;-). It's nice having the devel docs up there, but seems like they > > > ought to be labeled or segregated or something. > > Vince, can we re-target the most-visible docs references to point at the > 7.0 release docs? I would assume it is just a matter of making or > changing a soft link or two... Should be able to make it happen in the next few days. I'm about to freeze the website. The tool is finally working that will maintain and create the site (haven't finished the cvs stuff yet, I'll hafta do them manually). The only thing that'll be in a frame is the docs, for all versions. There is a major problem tho. When I first started with the user's lounge I created two directories, 6.5 and 7.0. Under those were docs directories. I remember them being changed to docs/6.5 and docs/7.0 but don't remember why - but that's not the problem. Last month I updated the user's lounge even tho it's not ready for consumption so it'd point to the new locations. Today I find that they're now v6.5 and v7.0. I'm not sure what's going on, but for now I just symlinked it, but it can't keep playing musical chairs. Is this in a script somewhere for generating the older docs? Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Mailing list archives?
On Mon, 17 Jul 2000, John McKown wrote: > Does an archive of the various pgsql- mailing lists exist? If so, > would you be so kind as to tell me how to access them? Go to the website. Choose Info Central then Mailing Lists. They all should be listed, but I haven't checked yet to make sure. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Logging Help Needed
On Tue, 18 Jul 2000, Thomas Lockhart wrote: > > Today I find that they're now v6.5 and v7.0. > > I know I was working in there a bit to post the 6.5 and 7.0 docs, and to > get the auto-updating development docs to work. But I can't recall > changing directory structure (though I *may* have done so). Should I > feel guilty, or have you identified another culprit? You may have done the original 6.5/docs to docs/6.5, no complaint there. But docs/6.5 to docs/v6.5 was a surprise. We need to make sure it's not going to change again unannounced. > Can anyone speak up who had an opinion (or who has dirty hands ;) on > this so Vince can get back to being right-side-up and oriented? Not necessary unless it happens again. Then I'm gonna be looking for a big stick! :) Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL]
On Mon, 7 Aug 2000, Morten W. Petersen wrote: > Hiya guys > > I'm having a problem with a PostgreSQL backend, the problem being that the > backend can die, from the simplest queries. I'm wondering if this can be > the sympthom of a corrupted database, or just a buggy version of Postgre. It'll help if you provide more info, like what version of PostgreSQL, what OS and version, example queries, etc.. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Problems after instaling PostgreSQL 7.0
On Wed, 16 Aug 2000, J. Mauricio Cuenca H. wrote: > I installed PostgreSQL 7.0 on Linux RedHat 6.2, then I ran the initdb > command without any problems or warnings. Then, when I try to run the psql > interactive monitor, I get the following error: > > [postgres@x ~/bin]$ ./psql > ./psql: error in loading shared libraries: libpq.so.2.1: cannot open shared > object file: No such file or directory > > I've checked and the file libpq.so.2.1 does exist in the /lib directory. Does the OS know about it? You may need to run something like ldconfig to get it to reread all the directories shared libs reside in. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] [Solved] SQL Server to PostgreSQL
On Tue, 22 Aug 2000, Tom Lane wrote: > Tressens Lionel <[EMAIL PROTECTED]> writes: > > Le 22.08.00 a 09:37, "Roderick A. Anderson" m'ecrivait : > > )I was able to get the table format by using MS Access. Only question left > > )is what is the corresponding field type in PostgreSQL for a memo field in > > )SQL Server/Access (varchar())? > > > 'text' type perhaps ? > > Uh ... what's wrong with varchar(n) ? How big can our n be for varchar? By looking at his description I'm thinking SQL Server allows a large n. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] copy table from one database to another
On Wed, 20 Sep 2000, John McKown wrote: > Is there a simple way to copy a table from one database to another? I was > totally restructuring the tables in a database, so I simply created a new > database. There was one table in the old database whose information I > wanted. I really wanted to copy the table from the old database to the new > one and rename the table during the copy. What I ended up doing was using > "pg_dump -t table olddb >old.info", then I editted the "old.info" file to > point to the new database and renamed the table as well. I could then use > the "\i old.info" command in psql to import the information. Is there a > better without writing code in Perl or Python? (I.e. within psql). What version of PostgreSQL are you using? I move tables around all the time and don't need to edit. Instead of the \i, try this: pg_dump -t table olddb > old.info psql newdb < old.info Vince. -- ====== Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Public Database of zip code information
On Wed, 20 Sep 2000, Adam Haberlach wrote: > Sometime in the past year, someone mentioned a database that > contained zipcode, lat/long, and city information--does anyone else > remember this, or should I check into a drug clinic? > > I'm pretty much looking for a way to correlate zip, city, > and/or geographic locations. You mean this one: http://ftp.census.gov/geo/www/gazetteer/places.html It sure helped me too! Note the web page says the data is from 1990, but there were continual updates over the last decade. I hope to see 2000's data soon. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Tips for investigating DBMS failure
On Mon, 16 Oct 2000, Tom Lane wrote: > Karl DeBisschop <[EMAIL PROTECTED]> writes: > > If it's of any use, I have attached the debug output - I don't see > > where the problem is occurring, but I don't pretend to fully understand > > the output, other than the exit is status 25. > > Signal 25?? What is that on your machine? (see /usr/include/signal.h) > On mine it's SIGTSTP, which doesn't make any sense --- for one thing, > that doesn't cause a process exit, only suspension ... That's odd. Here SIGTSTP is 18. 25 is SIGXFSZ (exceeded file size limit). Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] three things
On Tue, 24 Oct 2000, Robert Kernell wrote: > Hi. > > 1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s > book)? http://www.postgresql.org/users-lounge > > 2.) Can someone point me to the Postgres FAQ? http://www.postgresql.org/users-lounge Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: Re: [GENERAL] OT: List confirmation
On Tue, 31 Oct 2000 [EMAIL PROTECTED] wrote: > I tried the links and got an error that said postgresql.org didn't exist or >something of that nature. Anybody else get that and what do you do to correct it? >Thanks. It was easiest to respond by mail so I never even tried the web interface. Vince. > > Rick > Vince Vielhaber <[EMAIL PROTECTED]> wrote: > > On Tue, 31 Oct 2000, Adam Lang wrote: > > > Scrappy from postgresql wants me to reply to subscription messages for each > > of the lists I am subscribed to... do I need to, or should I ignore the > > messages? > > I got it too and figure since it only took a few seconds each it wasn't > any big deal and it be a bigger pain in the ass to have to resub to all > the lists again. > > Vince. > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] manuals
On Tue, 12 Dec 2000, Bruce Momjian wrote: > > > > I'm a newbie. > > > > I have printed out nearly 2 mb of postscript manuals without > > realizing that they are for 6.5. I'm going to use 7.0.3 > > and would like to know whether I'm foolish to rely on 6.5 manuals. > > > > I really don't feel like wasting paper and printing 7.0 manual and > > dumping 6.5. > > > > Who put 6.5 manuals on top of 7.0 on that web page? Not everyone has > > 72 inch monitor you know. > > > > I thought I fixed that, but it seems to have moved again. Vince, is > this the page that gets generated automatically? > > Don't fix anything. We discussed things generated via a script. This is one of those things and there's a link at the top of the page to take you either to the current version or the development version. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] manuals
On Tue, 12 Dec 2000, Bruce Momjian wrote: > > > > Who put 6.5 manuals on top of 7.0 on that web page? Not everyone has > > > > 72 inch monitor you know. > > > > > > > > > > I thought I fixed that, but it seems to have moved again. Vince, is > > > this the page that gets generated automatically? > > > > > > > > > > Don't fix anything. We discussed things generated via a script. This > > is one of those things and there's a link at the top of the page to take > > you either to the current version or the development version. > > But 6.5 isn't even our current version. > Your point? This appears at the TOP of the page with Documentation in large bold type: Documentation Current Release Docs (ver 7.0) Current Development Docs The two lines that begin with Current are links. Perhaps I should put it bright blinking red text with arrows pointing to it? Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] Re: RE: Re: MySQL and PostgreSQL speed compare
On Wed, 3 Jan 2001, Lincoln Yeoh wrote: > Actually I agree with Eric. > > The documentation is not as detailed or organised for usage. But it is > decent. Only sometimes you need to resort to real-life testing to see how > things really work. I do like the real world practical info which the MySQL > docs provide. > > There still isn't as much mention of limits and limitations of various > things as I'd like. > > Overall it's better than a "textbook style" doc. > > In contrast: take a look at Oracle's installation manual for an example of > how bad things can get ;). Compare it with a Oracle HOWTO. Then it goes right back to what someone else eluded to... If you don't like what you see in the documentation, contribute. Send in diffs, or even new items. If you don't know what's needed go to the DOCS list and ask. Getting people to help with documentation for ANY project is like pulling teeth. Finding people to criticize existing documentation is quite easy. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Re: RE: Re: MySQL and PostgreSQL speed compare
On Wed, 3 Jan 2001, Gregory Wood wrote: > > Then it goes right back to what someone else eluded to... If you don't > > like what you see in the documentation, contribute. Send in diffs, or > > even new items. If you don't know what's needed go to the DOCS list and > > ask. Getting people to help with documentation for ANY project is like > > pulling teeth. Finding people to criticize existing documentation is > > quite easy. > > What a horrible chicken and egg scenario... you can't help with providing > documentation until you have some deal of experience with something, but if > you ask for better documentation to get that experience, you are told to > write some. I understand the frustration, but at the same time, please > understand the frustration of those trying to learn. Personally I find the > documentation is more than adequate, but could always be improved. Hopefully > I will learn enough at some point to be able to say that I'm ready to > contribute... until then I'll be here feeding off the scraps of knowledge > that are dribbled here and there... You need to read things again 'cuze you completely missed the point. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] Re: Re: RE: Re: MySQL and PostgreSQL speed compare
I received an off list comment regarding this documentation issue that's been discussed here the last few days. Rather than respond to the comments privately I'm posting them to the whole list so that maybe folks will understand that asking for documentation contributions doesn't necessarily imply 'put up or shut up'. 1) Whining about anything is counter-productive. 2) Whining on the GENERAL list about documentation (which has its own list) is also counter-productive. 3) Rather than complain that the docs are inadequate, incomplete, too hard to read or just plain suck; give some examples on how they can be improved, ask for clarifications to things that may be confusing or yes, contribute something. 4) Did you figure out how to do something that the docs were vague about? Explain it and send it to the DOCS list, you don't have to be a technical writer or know SGML, but a couple of sentences or an example or something to that nature will eventually help someone who is and is in process of updating things. It'll also be in the archives and available via search. Bottom line: Something that's confusing or inadequate to you may not be to the person that wrote it, but they won't know that something's wrong if you don't tell them *specifically* what it is. I guess in that respect 'put up or shut up' is correct, but not completely. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] simple version question
On Wed, 17 Jan 2001, Richard Seymour wrote: > The site says 7.0.3 is the current version. The docs on the site are for > version 7.1. There are a few bugfixes / features in 7.1 that may be > useful. If you look in the developer's area you will find the docs for the development version. If you look in the user's area you will find the docs for the current version. If you look at www.postgresql.org's (and mirrors) home page you will see that the third item down explains how and where to find the appropriate documentation and even provides links to each version. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Search engine doesn't work
On Sat, 27 Jan 2001, Marc SCHAEFER wrote: > Hi, > > I wanted to try in the archives how to store a md5sum best in a database > (origin is 16 bytes binary, if I don't get a good answer I will use ASCII > like the output of the md5sum UNIX command since this is easy to debug). > > I got this error: > > Not Found The requested URL /mhonarc/pgsql-general/search.mpl was not > found on this server. > > Apache/1.3.12 Server at postgresql.rmplc.co.uk Port 80 > > They must not be in sync since I fixed that problem a few days ago. Go to http://www.postgresql.org/mhonarc/pgsql-general/search.mpl and it should work fine. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Re: 7.1 Docs WAS:Auto-timestamp generator (attached)
On Mon, 12 Feb 2001, Bruce Momjian wrote: > > As a suggestion regarding the docs ... as a newbie, I went straight to > > the"user's lounge" and didn't check out the "developer's corner" because > > I figured those docs would be pretty hard-core technical. But in > > reality, many of the developer's docs are much the same, only more > > current and more complete. I think I have seen other questions on this > > listserv deriving from the same problem (they would be easily answered > > from the developer's docs). IMHO, perhaps there should be some sort of a > > pointer from the user's lounge to the developer's docs, with warning, if > > that is necessary?? > > Can you give us an example of something you found in developers that was > not in users? The docs in devel-corner are for a not yet released version. If you're running a beta or developer's version of PostgreSQL, that's what you need. Otherwise you should avoid it or encounter the same pitfall as others who thought the stuff was relevant to their release systems and spent hours trying to get something working that wasn't implemented in their version. > > While I'm at it ... to show that I am super-anal-retentive ... the "l" > > in "lounge" on the www.postgresql.org home page should be capitalized. :) > > Oh, he got us there. No, as he said he's being anal. Since I came up with the user's lounge I'm the one that knows it's not a proper noun and therefore *should* be lower case. I do however make it upper case at times for no apparent reason -- my bad :) Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Bad book review
On Wed, 14 Feb 2001, Bruce Momjian wrote: > I am not sure how many people have looked at my book on Amazon.com, but > I have received my first negative book review: > > >http://www.amazon.com/exec/obidos/ASIN/0201703319/o/qid%3D976592762/sr%3D8-1/ref%3Daps%5Fsr%5Fb%5F1%5F3/104-0116316-8891907 > > I guess everyone isn't going to like my book. :-) Did you read any of his other reviews? He doesn't strike me as a happy person. Someone musta moved his cheese. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] New Book: PostgreSQL: The Elephant Never Forgets
On Tue, 20 Mar 2001, Joshua Drake wrote: > > Open Docs Publishing has announced today that they plan to release their > sixth book entitled "Learning PostgreSQL: The Elephant Never Forgets" by > the first week of June. This title will include PostgreSQL Great Bridge > version 7.1 (The Linux World Editors winner for Best Database in 2000). WTFI "PostgreSQL Great Bridge version 7.1" ? Is GB putting out their own releases now? Ned? Bruce? Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
RE: [GENERAL] PostgreSQL under Windows?
On Mon, 26 Mar 2001, Christian Marschalek wrote: > Hm... I can only find how to compile the libraries under visual c++ http://www.postgresql.org/related.html Vince. > > regards > > > -Original Message- > > From: Peter Eisentraut [mailto:[EMAIL PROTECTED]] > > Sent: Monday, March 26, 2001 9:04 PM > > To: Christian Marschalek > > Cc: [GENERAL] PostgreSQL > > Subject: Re: [GENERAL] PostgreSQL under Windows? > > > > > > Christian Marschalek writes: > > > > > Is it possible to compile and run PostgreSQL under Windows2000 ? > > > > Yes. See installation instructions. (Requires Cygwin.) > > > > -- > > Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ > > > > > > > ---(end of broadcast)------- > TIP 4: Don't 'kill -9' the postmaster > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] download PostgreSQL
On Tue, 27 Mar 2001 [EMAIL PROTECTED] wrote: > Hi > > Could someone tell me where I can download PostgreSQL for Windows and > MacOS from HTTP site other than ftp site, since the proxy server won't > allow me go to the ftp site? > > Looking forward to your reply! Yeah, I put a link up for this. http://www.postgresql.org/ftpsite Looks like I forgot to put up a link to it on a webpage. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Re: [DOCS] Better Features document?
Great! You guys do it and I'll put it on the website. Vince. On Sun, 8 Apr 2001, Bruce Momjian wrote: > Sounds great. > > I have collected some comments from people about PostgreSQL vs. other > databases at: > > ftp://candle.pha.pa.us/pub/postgresql/comparison.mbox > > This may help. You can also link to the docs and my book at: > > http://www.postgresql.org/docs/awbook.html > > to give people more detailed information about the features. I think > such a page would be a great idea. I can help too. > > > > > One thing that confused me when I started seriously looking at PostgreSQL > > was the features it had relative to other competitors. We have so many > > powerful features that are often underused by new users: > > > > * procedural languages > > * triggers > > * rules > > * views > > * custom aggregate functions > > * ... and more > > > > and so on. The documentation does a good job (& gets better all the > > time!) at explaining this, but many users never read that far into the > > documentation, and, of course, many people never get to the documentation > > at all -- they're evaluating software by a 10-minute glance through the > > web site. > > > > We have a features document at > > > >http://www.postgresql.org/features.html > > > > but this covers the architecture of the system (postgres / postmaster, > > etc), and very little about some of our other competitive advantages. > > > > My fear is that users & potential users come to PG w/o learning what a > > view is, how triggers can be helpful in designing database systems, why > > custom aggregates are so great, etc. (Those of us w/CS backgrounds do well > > to remember how many web database designers don't have that background!) > > > > Therefore, people compare us sometimes w/other database systems (mostly > > MySQL simply as 'MySQL seems faster and easier to install, but PostgreSQL > > has some features, like transactions, that may be useful to complicated > > databases', completely missing how many PG features are important to > > everyone that is designing databases, simple or large. > > > > I started writing a 'Features+' document a few months ago, but it got sat > > aside during a busy work time. I'd like to restart that work. > > > > I don't want to recreate the manuals -- I envision something like a 5-page > > 'product datasheet' that explains just enough about what a trigger is so > > that users have no excuse for not digging into that chapter, and that > > people understand how fantasic procedural languages are. > > > > Before I start digging into that, does anyone know if there > > exists a short- or medium- length (2-5 p) document that explains, for > > ordinary database mortals, about the sophisticated features of PG? > > > > Does anyone want to help put this together? > > > > > > -- > > Joel Burton <[EMAIL PROTECTED]> > > Director of Information Systems, Support Center of Washington > > > > > > ---(end of broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > > > > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [GENERAL] www.postgresql.org down?
It's back. Vince. On Sun, 8 Apr 2001, Justin Clift wrote: > Hi all, > > Is it just my route to the main webserver, or is the website at > www.postgresql.org down? > > Can access the mirrors, but can't touch anything at the main PostgreSQL > website. > > Rats, wanted to submit results of 7.1RC3 to Vince's database... > > Regards and best wishes, > > Justin Clift > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[GENERAL] Re: [HACKERS] Re: Hardcopy docs available
On Tue, 24 Apr 2001, Thomas Lockhart wrote: > > > ... if there is interest in an A4 layout of the docs, let me know... > > I've gotten several requests for the A4 format, and have completed four > > of the six docs in that format. Thanks for the feedback. They should be > > available in the next couple of days... > > OK, A4 docs are now posted on the web site and the ftp site. Also, I've > put copies of the html tarballs on the ftp site, so there should now be > tarballs, two kinds of postscript, and PDFs available there. > > If someone wants to run the A4 docs through a PDF converter, send 'em to > me and I'll post them too. Tom, ps2pdf is on hub. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Invoices
On Fri, 4 May 2001, Roderick A. Anderson wrote: > On Fri, 4 May 2001, Robert wrote: > > > I write the same application for the same reasons - we're three > > partners and we all want to be able to create invoices and also see what > > others create. > > Have you looked at SQL-Ledger? THough I disagree with some of the > table designs it is a pretty good accounting package. (Given I'm not an > accountant.) Possible down side is it is web-server/browser based. Has > support designed in for international use. Got a URL? Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Invoices
On 4 May 2001, Tony Grant wrote: > On 03 May 2001 17:05:44 -0700, Paul Ramsey wrote: > > > > There are a couple good solutions to this: > > - use PDFLib to generate printable format directly then pipe it directly > > to the browser. There are PHPLib hooks in PHP and also a perl module > > which hooks into it. You can even access it in Java via JNI calls. > > - create HTML output, but pipe it to html2ps on the system, then pipe > > that through ps2pdf, then pipe it back out to the browser. The nice > > thing about this approach is that you don't have to write your own page > > rendering routines, html2ps does it for you, and you just control it > > with style-sheet directives. > > In any event, reporting off a database from the browser does not have to > > be clunky or unattractive, there's some very good tools available. > > My problem is with mailing labels. Standard Avery sort. How do I do > about formatting multiple pages for mass mailings? > > Any pointers? I'd write a simple C app to read the database and write directly to the printer port. First print to paper and line it up over the labels. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] Re: Invoices
On Sun, 13 May 2001, Louis-David Mitterrand wrote: > * On Thu, May 03, 2001 at 07:45:23PM -0400, Vince Vielhaber wrote: > > On Thu, 3 May 2001, Ludwig Meyerhoff wrote: > > > > > Hallo! > > > > > > Maybe this is a bit off-topic, as this problem is more a "design"-one, but > > > I wanted to write a web-application write invoices more easy. I wonder if > > > it was a good idea to try this using Postgres or if it was better to write > > > the data of each invoice in a separate file in a separate directory. > > > > > > I doubt it was a good idea to put all the data into one database like > > > > I wrote a couple of programs for various projects to do this (one was > > for someone else so I can't release it). I kept all the data in their > > own tables - account info in the account table, customer info in the > > customer table, etc. - and put the data together as I generated the > > invoice. Simple, huh? Not exactly. > > > > Here's where the problem arises. You can create a really good looking > > invoice, in fact you can create a whole bunch of really good looking > > invoices. What you can't do with a web app is send a form feed to the > > printer! > > Yes you can. Try the CSS2 reference manual: > > 13.3 Page breaks > > The following sections explain page formatting in CSS2. Five properties > indicate where the user agent may or should break pages, and on what > page (left or right) the subsequent content should resume. Each page > break ends layout in the current page box and causes remaining pieces of > the document tree to be laid out in a new page box. > > And it works, we use it in our own app. Yes, that was pointed out last week. It works with opera and ie, not with mozilla or any of the netscapes (4 or 6) but it is a start. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
RE: [GENERAL] Install with Apache/PHP (Was "Stubborn Multibyte")
On Wed, 23 May 2001, Karen Ellrick wrote: > I gave up on 7.1.1 for now, although that is not ideal. I looked around the > web some more, and saw a recommendation to someone who was using RPMs for > postgresql and had the same problem, saying to install the postgresql-devel > RPM as well. I don't know how to do that with compiled source, but I then > realized that my successful installs have always been after a full set of > 7.0.2 RPMs were already installed. I tried a 7.1.1 RPM I found on > rpmfind.net, but it complained that it needed about 30 files I did not have. > So I just loaded the same old 7.0.2 RPMs I used before, and it all seems to > work (haven't made the database yet or tried to connect to the web serv. > Why I can't do it with compiled source, why my other machine complained of > disabled multibyte, and whether I will run into any of the bugs fixed in > 7.1.1 will remain mysteries. 7.1.2 will/should be out soon. Rather than searching out rpms that may or may not work, why don't you try building from the source? The instructions for doing it are very simple and you could probably do it in your sleep. At least that way you'll know what you have and if you still have problems you'll be starting from a known good starting point. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] PGDG?
On Sat, 9 Jun 2001, Tim Mickol wrote: > what does the element PGDG in an rpm filename, e.g., > postgresql-test-7.1.2-2.PGDG.i386.rpm, allude to? > PostGreSQL Development Group? What does it mean? > > I'm trying to get a compete collection of the 7.1.2 binary rpms but have > discovered many of the ftp mirrors aren't synched yet. > Also many of the mirrors are refusing logins. I did find a responsive > mirror in thailand, but the rpms all carry the "PGDG" tag. > > Can anyone shed some light on this? Post Gresql's Damn Good ? Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
RE: [GENERAL] ERWin
On Thu, 24 May 2001, Abhimanyu_Bhola wrote: > check these links out for the odbc driver, > > ftp://ftp.PostgreSQL.org/pub/odbc/ > > http://www.openlinksw.com. Of course there's always http://odbc.postgresql.org Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] New mirrors on web page
On Mon, 7 May 2001, Bruce Momjian wrote: > I like the new mirrors web page at http://www.postgresql.org. Now I > just need to learn about some of those flags. The alt tags will tell you what country. Looking at the status bar will tell you what host (if your browser supports that). Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Oracle to Pg tool
On Wed, 9 May 2001, Bruce Momjian wrote: > > Where do people want this. Should it be in /contrib or on its own web > page? This is already linked on the related page. > I have an Xbase conversion utility too. Where should that go? What's the URL? > > > > Hi, > > > > As I previous searched a tool to convert Oracle database to PostgreSQL > > and really found nothing, there's now a piece of perl code I've written > > that > > can become a great tool to do this job. > > > > It currently extract the database schema table definition of an Oracle > > database > > and output a sql script to import into postgresql. You simply provide the > > DBI > > connection to the Oracle DB and the script do its best. It normally handle > > unique, primary and foreign keys. > > > > I need help to go further because I really don't know about Oracle and I go > > > > very slowly. Also I did not have so much Oracle database to test with. > > > > Things to do are: > > > > - Extract grants (coming soon) > > - More precision in type conversion based on length (I've no good DB to do > > that) > > - Extract triggers and internal function. > > - Extract datas. > > - SQL queries converter. > > > > For extracting data if someone know a way to dump content of an Oracle DB > > in ascii. I don't found anything than binary dump. Extracting them with > > perl/DBI > > can be very slow but if there's no other way... > > > > You can found this tools at: > > > > http://www.samse.fr/GPL/ora2pg/ > > > > > > Regards > > > > > > ---(end of broadcast)------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > > > > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Web site gripes
On Wed, 20 Jun 2001, Norman J. Clarke wrote: > You do an excellent job Vince. By and large the website is awesome, and I > love some of the newest additions such as the interactive docs. But you > should listen to his gripes and respond in a more polite way. If you think > he is wrong, then explain why. > > Responding with a personal attack is not helpful at all and seems really > out of sync with the tone of the rest of the list. When I saw his first > email I cringed because from reading your previous posts I knew you were > going to respond exactly as you did. I'll try to keep this plain and simple. If you (anyone) have suggestions for the website, I'm all ears. But if you're looking to be blown off, insulted, treated rudely, etc. then you need to preface it with a bunch of whining gripes that have little to no foundation. Make yourself look as clueless as possible. If you're going to go looking for things to bitch about as your lead-in to the suggestions you have, don't get upset if I tell you where to go. If I did it to you I'd expect the same result. On the flip side of the coin, I'm not one for praises either. Now then, even tho you can find it in the archives, I'll let everyone in on some of the reasons for the site's layout and why some things happen and some don't. Documentation: The release docs and the development docs (the ones that don't apply to the released version - things not there, things working differently, etc) have to be kept as far apart as possible. Time and time again I/we'd get email from people crabbing about how they depended on a specific feature that's in the documentation that doesn't work - only to find out they're reading the devel docs and using the release version or even an older version of the software. In the release docs section all of the indexes are created with a couple of scripts so a bunch of editing doesn't have to take place if things are added (such as a pdf version) or removed. Just run the script. This happens alot at release time for one reason or another. When you click on English docs, you get a page that has links for the different versions with the current release at the top. True, they're links to anchors on the same page but they're not visible at that time unless your browser's broken or you have your browser set to some rather large size. The anchors are far enough away that it shouldn't matter what order they're in. In the developer docs some work is still needed there to make it simpler. Mailing List Info: This too is separated between stuff that users are interested in and what developers are interested in. Why? Partly because too many people were getting confused about what lists they should be reading. Imagine, the hackers list was too advanced for a few folks. What's the difference between a developer and a user? A developer is someone that's actually working on the PostgreSQL sources either making additions, fixing bugs, working on docs, etc. for future releases. A user is one who uses, administrates, develops apps that use PostgreSQL, etc. typically in the current release. If someone has a better suggestion for names for developer and user, I'm all ears - but note the comments in the first paragraph (not the first sentence). Why Aren't Betas Announced? I tried using red, red bold, red bold and larger font size but too many people didn't see it and complained rather loudly that this version they found on the website didn't work and they lost their data. Never mind the fact it was beta, had beta in the filename, said on the website in big bold red letters that it was beta, if it was there, it should have been safe to use. Why isn't the webmaster's address on the website? If you made it this far on the internet that you're using, deploying, developing, etc. an open source database then [EMAIL PROTECTED] should be a no-brainer. When it was there I got 60-70 HotBabes/AcceptCreditCards/GetALoan/etc... spams each and every day. Now it's finally down to about 10/day. If, however, anyone wants me to forward some of the spam I get to them 'cuze they like getting that kinda stuff, I'll be more than happy to share!! :) BTW, I'm planning on a new look for the website in the not too distant future - but with graduations, weddings, etc. at this time of the year there's no set date. Perhaps the new look will satisify some of the things that folks dislike and/or maybe some of the things will flow together better, but I still expect that not everyone will be happy and many will be downright upset about it. Hmmm, maybe I'll do it in frames.. Lotsa little frames.. *evil laugh* Vince. -- == Vince Vielhaber -- KA8CSHemail
Re: [GENERAL] Web site gripes
On Wed, 20 Jun 2001, Adam Haberlach wrote: > On Wed, Jun 20, 2001 at 04:38:58PM -0400, Vince Vielhaber wrote: > > On Wed, 20 Jun 2001, Norman J. Clarke wrote: > > > > > You do an excellent job Vince. By and large the website is awesome, and I > > > love some of the newest additions such as the interactive docs. But you > > > should listen to his gripes and respond in a more polite way. If you think > > > he is wrong, then explain why. > > > > > > Responding with a personal attack is not helpful at all and seems really > > > out of sync with the tone of the rest of the list. When I saw his first > > > email I cringed because from reading your previous posts I knew you were > > > going to respond exactly as you did. > > > > I'll try to keep this plain and simple. > > > > If you (anyone) have suggestions for the website, I'm all ears. But if > > you're looking to be blown off, insulted, treated rudely, etc. then you > > need to preface it with a bunch of whining gripes that have little to > > no foundation. Make yourself look as clueless as possible. If you're > > going to go looking for things to bitch about as your lead-in to the > > suggestions you have, don't get upset if I tell you where to go. If I > > did it to you I'd expect the same result. On the flip side of the coin, > > I'm not one for praises either. > > Ok, I've held my tongue on this for a while, now, but your attitude > is just annoying the shit out of me. I'll keep it plain and simple, > too. You started out fine, then you got to the whining: > o. When I /do/ make it to a docs page, I end up at a "oldest stuff at > the top" list, when it is likely that the first thing people want is > going to be the newest docs. > > o. When I finally make it to the documentation for my version, I get > a list of no less then 38 different links, covering almost all > permutations of That should be enough, but as you know (since you wrote it) there is more. I'm not going to get into it again, you don't like my attitude, I don't like yours or your whining. End of conversation. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] web site suggestion
On Fri, 22 Jun 2001, Bruce Momjian wrote: > > I would really like is to have the "User's lounge" link changed to "User > > Documentation". If I haven't been to the postgresql site in a few months, > > when I look at the "User's lounge" link, I always think, "Is that a chat > > room or something?" Actually you might want to have a "User Documentation > > and Mailing Lists" link, since that will get the great majority of > > newcomers going in the right direction to start off with. > > Agreed. I always thought of "Lounge Singer". You mean you didn't hang around long enough to hear that guy singing the mssql blues? He's pretty good! Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] More Red Hat information
On Mon, 25 Jun 2001, Bruce Momjian wrote: > > On Mon, 25 Jun 2001, webb sprague wrote: > > > > > I guess I prefer my free software free... > > > > Agreed, but alot of companies want to be able to point a finger at > > someone or some company when something goes awry. With RH being > > the first to put out PostgreSQL with an operating system that I would > > assume was fine tuned for best performance by those that know the > > OS very well and possibly even include some tools along with it, I'd > > think their offering would be well received in the small to medium > > sized business community. > > Heck, I pay ~400/year for BSD/OS support on my home machine because when > I have a complex problem, I need someone to concentrate on getting it > solved, so commerical support isn't just for finger-pointing. > > The $400/year has been worth it for me so I suspect there are PostgreSQL > users that need such support too. I didn't mean someone to blame, I meant someone to call. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] ODBC driver for Mac?
On Sun, 15 Jul 2001, Randall Perry wrote: > Any plans to work on a Mac version of PgSQL ODBC driver? I don't know anything about mac (besides the lastest os being based on FreeBSD 3.2), but you're using the latest version can't you use iODBC? Also http://www.unixodbc.org has one that may work on the mac. You can find more info on either the PostgreSQL ODBC website: http://odbc.postgresql.org or the PostgreSQL odbc mailing list. You may even find someone who knows what they're talking about :) Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] html to postgres...
On 16 Jul 2001, Tony Grant wrote: > Hello, > > I have several hundred HTML (!) pages that need to be converted to a > format that in turn can be imported into PostgreSQL. They are all built > on a very similar grid. > > Any thoughts? For the integrated docs I wrote a C program (I suck at perl) and a shell script to send to stdout: \connect whateverdatabaseyouwant insert into table(pagereference,textofpage) values('titleofpage',' The parse the file and send it to stdout but take any apostrophes and backslashes and escape them. Then follow it up with: ');\n and when run it took a directory of about 480 files and neatly filed them into a table. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] JDBC 2.0 support?
On Mon, 16 Jul 2001, stefan wrote: > Hi: > > Are there JDBC drivers for PostGresSQL? http://jdbc.postgresql.org Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Is the bug system active?
On Tue, 14 Aug 2001, Tom Lane wrote: > Lee Kindness <[EMAIL PROTECTED]> writes: > > Is the bug system at: > > http://www.ca.postgresql.org/bugs/ > > actively in use? I recently reported the following bug: > > http://www.ca.postgresql.org/bugs/bugs.php?4~415 > > and after doing so browsed through a number of earlier bugs it appears > > that the vast majority are still 'unassigned' and not evaluated after > > a long period of time (like over a year)! Surely if this system is > > being ignored it should be removed from the website... > > It's not being ignored, exactly --- the part of it that is actually > useful is that bug reports entered via the webform are spit out to the > pgsql-bugs mailing list. Which the developers do read, and respond to. > (I see your ecpg bug report on the list, BTW.) But no one is > maintaining the bug database in the sense of marking stuff done. > > I hadn't realized that there was a publicly-visible database attached > to the webform, actually. Perhaps we should not make the database > visible, if we're not going to update it. Vince, what do you think? If we're not going to update it then I agree, although updating it is rather trivial. It's a function/feature that's already built in. So I guess it's your call, 'cuze it's just as trivial for me to disable that part. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] RFC: PostgreSQL and MySQL comparison.
On Wed, 29 Aug 2001, Justin Clift wrote: > Hi guys, > > I'm willing to put this on techdocs.postgresql.org, as long as I feel > it's been written for the right reasons. > > i.e. I'm all for a document(s) which helps people needing a good, solid, > Open Source database needing transactions, ACID features, etc. But, I'm > definitely not for a document which will incite PostgreSQL-vs-MySQL > warfare and not try and get people to choost the appropriate product(s). Don't worry, it'll incite a riot no matter how accurate it is. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Idea: jobs.postgresql.org
On Sat, 8 Sep 2001, Justin Clift wrote: > Hi Guys, > > It is definitely something interesting, and there are a fair few > PostgreSQL jobs out there. > > The address Joe mentioned is correct, I'm just so short of time now I > haven't been able to do much in the way of site maintenance recently, so > that page hasn't been updated in ages. If you want we can merge jobs into the main site for now. Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [GENERAL] Idea: jobs.postgresql.org
On Sun, 9 Sep 2001, Justin Clift wrote: > Vince Vielhaber wrote: > > > > On Sat, 8 Sep 2001, Justin Clift wrote: > > > > > Hi Guys, > > > > > > It is definitely something interesting, and there are a fair few > > > PostgreSQL jobs out there. > > > > > > The address Joe mentioned is correct, I'm just so short of time now I > > > haven't been able to do much in the way of site maintenance recently, so > > > that page hasn't been updated in ages. > > > > If you want we can merge jobs into the main site for now. > > > Sounds good to me. When it's up, the jobs page is the third most > popular techdocs page people visit. The hardest part I've found is > knowing when jobs have been filled, because people routinely "forget" to > say when. > > An attitude I've found dissapointing is the weird belief a number of > agencies have that there must be "some kind of catch" to putting their > PostgreSQL related jobs online for free. No charge, no banner > advertising, etc. You'd think they'd never heard of "Community Spirit". We can talk to Marc, but we can set it up as 1) someone looking for work gets a free listing, 2) a company looking for someone gets a free listing, but 3) a headhunter pays $10/listing - or "donates" it to postgresql.org or run it thru pgsql.com of if neither do we can run it thru libpq.com. > A lot of the stuff I do on the techdocs site is "lets see if this works > and is beneficial". The jobs section was and is, and so I'm happy for > it to become something more, main site, sub-domain, whatever. That's where idocs came from. Now when it doesn't work my mailbox fills up quickly! Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [GENERAL] Idea: jobs.postgresql.org
On Mon, 10 Sep 2001, Justin Clift wrote: > Sorry Vince, > > My mistake. I must have worded that badly. > > What I mean is that some Agencies find it difficult to believe that we > would actually assist them in looking for candidates, especially > directly to a targeted audience, without demanding to be paid for the > effort. > > Once they understand we're doing this for the benefit of the PostgreSQL > Community, they're cool with it. OOhhh! Now that makes more sense! Vince. -- ====== Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [GENERAL] business perspective
The website is currently undergoing a rewrite. Vince. On Wed, 12 Sep 2001, Ryan Mahoney wrote: > Since Great Bridge is no longer, there is a need for a strong online > presence for companies and individuals to learn about postgresql. This gap > is a detriment to the project from a marketing perspective, where GB helped > the most. > > I visit postgresql.org a few time a week and find it to be very useful > (especially the documentation search!). From a design and information > architecture perspective it can be extended to communicate (through design) > the sense of confidence and clarity of the better websites for companies > and projects in this industry. Having a spectacular website probably isn't > going to persuade fortune 500 companies to make a switch - it is definitely > an integral part of communication that helps to shape the way people > perceive postgresql, especially first impressions. > > Here are a few sites that I am basing my comparison on: > sendmail.com > sun.com > redhat.com > ibm.com > > There are a handful of design decisions that have been employed by these > companies that effectively communicate their brand and > products. Implementing these methods and techniques to postgresql.org is > within the scope of our capabilities. Deciding on a direction, boiling > that down to something concise and ultimately creating something that the > community can approve of and feel great about is a larger task. I believe > that it is worthwhile, and am willing to devote time towards this > end. Please post your comments, so we may see if there is a desire to move > forward in this direction as well as who else may be interested in this > project. Although I only occasionally chime in, I read the general and > hackers lists daily (er, hourly ;) ) and have a deep respect for the > individuals who participate on these lists. > > Looking forward to your feedback, > > Ryan Mahoney > > BTW, I have been involved in the design (and development) of a few > successful and highly trafficked websites. Including Nerve.com, > Flower.com, and Viasource.net. I am based in NY and collaborate with a > number of other small design shops (kolumn.com, frameweld.com). I agree > with Jakob Nielson's design and usability concepts and read useit.com regularly. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Contents of greatbridge.com?
On Tue, 9 Oct 2001, Tommy wrote: > >From what I understand they went out of business. I have not seen the site > morrored anywhere. > > I wonder what this means for the future of PostgreSQL? You must be new here 'cuze this has been covered many times in the last few weeks. PostgreSQL is not now, nor has it ever been a product or property of Great Bridge. PostgreSQL, Inc has been around longer than Great Bridge and is still running just fine. In fact there's currently nine companies listed on the PostgreSQL website that do the exact same thing as GB, among them is PostgreSQL, Inc, and RedHat. The projects website is, or is about to be available at http://gborg.postgresql.org So to answer your question about what the future is for PostgreSQL? Just as bright as ever. Vince. > > Tommy > > "reywob" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED]... > > Hi, > > > > Does anyone know if the contents of Greatbridge.com is anywhere? > > Someone told me that they had a good article comparing PostgreSQL to > > other databases, which I would like to read - except that the site has > > disappeared :-( > > > > Thanks, > > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly