[SPOOFED] Nothing to see here (was:Re: [GENERAL] I have had enough)

2004-11-10 Thread Lamar Owen
[all content snipped] Spoofed again. Nothing to see here. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---(end of broadcast)--- TIP 5: Have you

Re: [GENERAL] The reasoning behind having several features outside of source?

2004-10-25 Thread Lamar Owen
re if it is addressed in any of our written FAQ lists. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---(end of broadcast)--- TIP 9: the planner will

Re: [GENERAL] PostgreSQL 7.4.3 Now Available ...

2004-06-19 Thread Lamar Owen
s cycle. Been swamped at work. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [GENERAL] RPM init-script: Why the locale setting?

2004-04-05 Thread Lamar Owen
d wasn't happy with my choice of C locale, and here is why: Re: Thought you might find this very interesting. From: [EMAIL PROTECTED] (Trond Eivind GlomsrÃd) To: Lamar Owen <[EMAIL PROTECTED]> Lamar Owen <[EMAIL PROTECTED]> writes: > On Friday 25 May 2001 15:04, you wrote: > &

Re: [GENERAL] Before ship 7.4.2

2004-03-02 Thread Lamar Owen
nsistently removed from the RPMs of the main tarball. I once again apologize for not doing that for 7.4 and 7.4.1. For 7.5 this will be JDBC, right? (The JDBC RPM is pretty broken anyway, and downloading the proper jar from jdbc.postgresql.org and making a separate postgresql-jdbc RPM that is no

Re: [GENERAL] Before ship 7.4.2

2004-02-03 Thread Lamar Owen
ou > are talking about a packaging error in the RPM distribution. Lamar Owen > would be the man to talk to about that ... Lamar, any thoughts about > this? Well, my first instinct is to throw out the python client RPM entirely. Then package the python client in a separate RPM. My origin

Re: [GENERAL] 7.4.1 RPMS

2003-12-30 Thread Lamar Owen
On Tuesday 30 December 2003 04:44 pm, Ericson Smith wrote: > Are there any 7.4.1 RPM's yet? I looked at the mirrors but no go. After I get back from vacation (which I am on right now). -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Ro

Re: [GENERAL] perl(Pg) (S)RPM

2003-12-02 Thread Lamar Owen
On Tuesday 02 December 2003 06:05 pm, Roderick A. Anderson wrote: > On Tue, 2 Dec 2003, Lamar Owen wrote: > > exists). If no one else can do this, I can, but it's not high on my list > > of priorities. > What you have a life? :-) And four kidsoh, that's an 

Re: [GENERAL] RPM RH9.0 conflict with unixODBC

2003-11-25 Thread Lamar Owen
cle) with debug info turned on, and unstripped. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---(end of broadcast)--- TIP 2: you can get off a

Re: [GENERAL] RPM RH9.0 conflict with unixODBC

2003-11-25 Thread Lamar Owen
n; I was going to be off, but will have to come in for a couple of hours. So I'll transfer them across then. Many thanks! -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pa

Re: [GENERAL] SRPM (PGDG) will not build

2003-11-24 Thread Lamar Owen
-o with -c or -S and multiple compilations Can you send me a complete stderr and stdout log of the build? (nohup usually works the best to do this, as it catches everything). -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28

Re: [GENERAL] updated linux startup script?

2003-11-24 Thread Lamar Owen
sion" errors as well.) I have installed, started, and restarted successfully with the 0.2PGDG set on Fedora. It isn't breaking for me as yet. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28

Re: [GENERAL] updated linux startup script?

2003-11-22 Thread Lamar Owen
cript), then gives an error on subsequent startups. Into what location did you initdb? The script with the 0.2PGDG set is the latest, one guy has already reported that it worked for him. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive R

Re: [GENERAL] Problem with 7.4 RPMS for Fedora Core 1

2003-11-21 Thread Lamar Owen
On Friday 21 November 2003 09:33 pm, Lamar Owen wrote: > On Friday 21 November 2003 09:15 pm, milimeter wrote: > > errors: -> > > An old version of the database format was found.\nYou need to upgrade > > the data format before using PostgreSQL.\nSee > > /usr/share

Re: [GENERAL] Problem with 7.4 RPMS for Fedora Core 1

2003-11-21 Thread Lamar Owen
On Friday 21 November 2003 09:33 pm, Lamar Owen wrote: > On Friday 21 November 2003 09:15 pm, milimeter wrote: > > errors: -> > > An old version of the database format was found.\nYou need to upgrade > > the data format before using PostgreSQL.\nSee > > /usr/share

Re: [GENERAL] Problem with 7.4 RPMS for Fedora Core 1

2003-11-21 Thread Lamar Owen
Typo. Replace /etc/rc.d/init.d/postgresql with the attached script. Rename it from postgresql.init to postgresql and put in /etc/rc.d/init.d My apologies. I'll rebuild shortly. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosma

Re: [GENERAL] First generic/redhatish RPM's uploaded to ftp.postgresql.org.

2003-11-21 Thread Lamar Owen
On Friday 21 November 2003 01:13 pm, Lamar Owen wrote: > I have uploaded a first cut at the RPM's to ftp.postgresql.org. While I am > not 100% convinced of the need to do so, I have restructured the > directories, and await comment on that. > I expect RH 7.3, RH9, and RH 6.2

[GENERAL] First generic/redhatish RPM's uploaded to ftp.postgresql.org.

2003-11-21 Thread Lamar Owen
om Sander, once he reads this mail and gets the time to build them, as he has already asked to help do this. I have RH 8.0 at my disposal, and will build those. I will also be building Aurora 1.0 packages. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute

Re: [GENERAL] SuSE RPMs available for PostgreSQL 7.4

2003-11-19 Thread Lamar Owen
onized to our set periodically? Yes, they have. Do they call our set the 'official' set? Yes, they do. Why do you have a problem with this? > The directory structure is a mirror of the SuSE FTP site. On ftp.postgresql.org? I'm only talking about ftp.p

Re: [GENERAL] SuSE RPMs available for PostgreSQL 7.4

2003-11-19 Thread Lamar Owen
at has previously been set for naming RPM releases (regardless of the source). And then you neglected to put group write permissions on the directory so that other binaries could be uploaded. So now I wouldn't be able to upload RPMs in the customary place. Many thanks. -- Lamar Owen

Re: [GENERAL] RHEL

2003-11-12 Thread Lamar Owen
agement to sit up and take notice.) The RHEL3 beta (taroon) had rh-postgresql-server built and included. Does RHEL3 not include this package? -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari

Re: [GENERAL] Redhat RPMs

2003-10-14 Thread Lamar Owen
eneral, though. If the list server will accept it, reply-to has been set to pgsql-ports. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL Beta4 Tag'd and Bundle'd ...

2003-10-06 Thread Lamar Owen
ead -hackers ... That is the only way to keep up with what's going on. But you must be willing to take the e-mail volume that that entails. Or use the archive web interface. But -hackers is the place, and has been since the beginning. -- Lamar Owen Director of Information Technology Pi

Re: [GENERAL] State of Beta 2

2003-09-27 Thread Lamar Owen
ries - ACCELERATING Business with Open Technology * Education | -=^ Ad Astra Per Aspera ^=- * Integration| http://www.quantumlinux.com * Support| [EMAIL PROTECTED] = You know, I don't mind owning up to my own bu

Re: [GENERAL] State of Beta 2

2003-09-18 Thread Lamar Owen
once we get past 7.4 release, right? So in order to get critical bug fixes, users must upgrade to a later codebase, and go through the pain of upgrading their data. K, looking back through that it almost sounds like a ramble ... hopefully you understand what I'm asking ... *I* should complai

Re: [GENERAL] Commercial postgresql

2003-09-02 Thread Lamar Owen
ore which is a >significant amount of downtime for a large DB. I have harped on this at length. Maybe one day we'll get real upgrading. Search the archives for the discussions; there are many, and they are long threads. -- Lamar Owen Director of Information Technology Pisgah Astronomi

Re: [GENERAL] 7.3.4 RPM

2003-08-19 Thread Lamar Owen
them tomorrow when I'm back on my T1. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] libpq.so.2 and postgresql-libs-7.3.3 RPM

2003-06-29 Thread Lamar Owen
safe to symlink to libpq.so.3, shouldn't the RPM > do that? No. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] 7.3.3 RPM build

2003-06-26 Thread Lamar Owen
On Thursday 26 June 2003 18:34, Manuel Sugawara wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > If you want to help troubleshoot, look at the > > filter-requires-perl-Pg.sh script (Source16) and see where it needs > > to be invoked > But ... contrib *depen

Re: [GENERAL] 7.3.3 RPM build

2003-06-26 Thread Lamar Owen
l it with --nodeps for now, while I regroup and determine why it doesn't work (again). If you want to help troubleshoot, look at the filter-requires-perl-Pg.sh script (Source16) and see where it needs to be invoked -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---

Re: [GENERAL] postgresql 7.1.3

2001-10-16 Thread Lamar Owen
thing > else that I am missing? My apologies. In my README.rpm-dist I missed a step: chkconfig --level 345 postgresql on Put the runlevels desired to start in in place of '345' above if desired. Sorry. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] postgresql.conf

2001-09-25 Thread Lamar Owen
make generalized optimizations -- so I ship the default file. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTEC

Re: [GENERAL] USA Disaster

2001-09-11 Thread Lamar Owen
the PostgreSQL project is then directly affected... -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] USA Disaster

2001-09-11 Thread Lamar Owen
msnbc.com, www.foxnews.com, or some other news web site (if you can get through). While this is a horrendous thing, it isn't a PostgreSQL thing -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our

Re: [GENERAL] USA Disaster

2001-09-11 Thread Lamar Owen
ist will be affected by the war that is likely to result from these cowardly acts. :-( -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] How to make a REALLY FAST db server?

2001-09-10 Thread Lamar Owen
> > - Hardware: dual / quad Intel class The ultimate would be an IBM S/390 mainframe running some distribution of Linux S/390. I/O bandwidth on mainframe DASD is incredible, the memory is robust and fast, and the CPU is trememdous. The price is also trememdous. -- Lamar Owen WGCR In

Re: [GENERAL] install only pg_dump

2001-09-10 Thread Lamar Owen
.2 binary RPM's, all you would need installed would be the main postgresql RPMand the postgresql-libs RPM. You would not need the postgresql-server RPM installed for to do a pg_dump. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)---

Re: [GENERAL] speed of communication and pgsql development

2001-08-25 Thread Lamar Owen
the only > one sitting behind a firewall'd system? Anyone with half a security clue is behind a firewall. Our firewall here won't pass ANY IRC for security reasons. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)---

Re: [GENERAL] speed of communication and pgsql development

2001-08-25 Thread Lamar Owen
and bugfixes typically get done by a particular developer, and changes typically don't interact a great deal (there are of course exceptions -- the foreign key support is one of them). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--

Re: [GENERAL] New RPMS ?

2001-08-22 Thread Lamar Owen
s none was intended whatsoever. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] New RPMS ?

2001-08-20 Thread Lamar Owen
6DX4-100 I had RH 6.2 installed on (48MB RAM). (That machine went on the mission field) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] New RPMS ?

2001-08-20 Thread Lamar Owen
source RPM -- but I cannot at present do that. And, once a Red Hat 7.2, or 8.0, or whatever Red Hat comes out with next materializes, I will likely migrate my servers to it as well. My apologies. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end o

Re: [GENERAL] AutoStart and AutoDown

2001-07-23 Thread Lamar Owen
s 3, 4, and 5). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: RPM source files should be in CVS (was Re: [GENERAL] psql -l)

2001-07-20 Thread Lamar Owen
n thing about 'our' RPMs -- they are intended as a semi-standard base from which OS distributors may make their own packages, for which they are responsible. A side benefit is that people can grab the latest hopefully-generic RPMset from us if their OS vendor isn't forthcoming with up

Re: RPM source files should be in CVS (was Re: [GENERAL] psql -l)

2001-07-18 Thread Lamar Owen
On Wednesday 18 July 2001 10:42 pm, Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > While I understand Oliver's reasons for having the Debian stuff on the > > debian server, I believe it would be appropriate to have the patchfile > > and the various

[GENERAL] PostgreSQL 7.1.2-5PGDG RPMset released for Red Hat 7.1.

2001-07-18 Thread Lamar Owen
to README.rpm-dist Dependency correction for -devel subpackage. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Lamar Owen
On Friday 13 July 2001 14:47, Peter Eisentraut wrote: > Lamar Owen writes: > > But I will reiterate that the prebuilt binary RPMs are built for _stock_ > > RedHat (and hopefully the systems used to build the non-RedHat binaries > > are stock, as well). > Maybe the dir

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Lamar Owen
x27; (or 2.1)), or making sure the command 'python' points to python2. Or edit the pyver definition line to use python2 by default. Is there a need for a whole separate binary RPM for Python 2 clients? But I will reiterate that the prebuilt binary RPMs are built for _stock_ RedHat (and h

Re: [GENERAL] PostgreSQL perl / libpq.so.2 problem - again :(

2001-07-09 Thread Lamar Owen
version -- just being able to have fine-grained resource management like that is so nice -- makes one wish for an S/390. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] Re: [HACKERS] 2 gig file size limit

2001-07-07 Thread Lamar Owen
limit will be when making backups using pg_dump or pg_dumpall. You may need to pipe the output of those commands into a file splitting utility, and then you'll have to pipe through a reassembly utility to restore. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---

Re: [GENERAL] defunct postmasters

2001-05-11 Thread Lamar Owen
this one here and see what happens. A port scan should not do this to postmaster. - -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE6/AVG5kGGI8vV9eERAjXuAKCA/MY5pmzBY+8SvfXz8Um/

Re: [GENERAL] 7.1-1 installation from RPM

2001-05-07 Thread Lamar Owen
to have built by this time tomorrow. /etc/rc.d/init.d/postgresql start by now should succeed. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] More src install probs...

2001-04-30 Thread Lamar Owen
David Pieper wrote: > > I'm trying to build 7.1 from source on a RedHat box. > Here's what I keep ending up with: >From the gcc version it appears you are on a RedHat 6.x box. > It seems like I'm missing something, but what? kernel-headers? -- Lamar Owen WG

Re: [GENERAL] installing DBD::Pg without installing postgres

2001-04-23 Thread Lamar Owen
the dependencies for the DBD::Pg RPM? Satisfy those dependencies, and properly set up for client-server communications with a postgresql server, and it _should_ just _work_. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)---

Re: [GENERAL] locale & glibc 2.2.2

2001-04-19 Thread Lamar Owen
the issue -- after I finish getting my office and servers moved this week and next. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(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] locale & glibc 2.2.2

2001-04-19 Thread Lamar Owen
7;ll have to wait on the reporter to elaborate what was meant by '..the locale supportbroken...'. Which case-sensitivity issue? The one about table and column names? Or a different one? (sitting confused in Pisgah Forest) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 --

Re: [GENERAL] 7.1 RPM has old JDBC driver - SQL statement too long

2001-04-19 Thread Lamar Owen
built 7.1 JDBC jars to ship as part of the RPM, or get time to install the pieces necessary to build JDBC on RH6.2, RH7.0, and RH7.1. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2: you can get off all lists at once with

Re: [GENERAL] locale & glibc 2.2.2

2001-04-19 Thread Lamar Owen
nd other issues were substantially changed for glibc 2.2.2. It is a glibc 2.2.2 issue, not a PostgreSQL one -- as the same codein PostgreSQLO (strcoll) is being used. We will see how things pan out with locale on glibc 2.2.2, as, like I said, there are big changes, apparently. -- Lamar Owen WGCR Interne

Re: [GENERAL] 7.1 rpm problem

2001-04-18 Thread Lamar Owen
er install 'postgresql-7.1-1', 'postgresql-libs-7.1-1', and 'postgresql-server-7.1-1'. The reasons for this are explained in the README.rpm-dist file found on the website as well as in the RPM. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(en

Re: [GENERAL] postdrv.exe fails on 7.1

2001-04-15 Thread Lamar Owen
Tulio Oliveira wrote: > Please, is any configuration more to make on 7.1, or exist a new postdrv.exe > ??? See http://www.greatbridge.org/project/psqlodbcplus/projdisplay.php -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of bro

Re: [GENERAL] 7.1 SRPM woes (Mandrake 7.2)

2001-04-14 Thread Lamar Owen
lled. Conversely, build everything but the python package by: rpm --define "python 0" -ba postgresql.spec -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] anti Christian bias?

2001-04-14 Thread Lamar Owen
ch it is translated. That of course means that there is no copyright associated with it; thus no license at all. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregiste

Re: [GENERAL] anti Christian bias?

2001-04-13 Thread Lamar Owen
On Fri, 13 Apr 2001, Bruce Momjian wrote: > Lamar Owen wrote: > > As a matter of fact, I am an ordained Baptist minister. Don't > > know about Bruce -- other than I like his catchy .sig... :-) > Wow, pretty cool. I am just an underling. :-) Well, we're all unde

Re: [GENERAL] Shared memory failure?

2001-04-13 Thread Lamar Owen
port (and which would you recommend)? Thanks. Oh, and BTW: when you rpm-e postgresql, you have to put all of the rpms on one line, or the circular dependencies that sometimes have been present will bite you. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---

Re: [GENERAL] Shared memory failure?

2001-04-13 Thread Lamar Owen
the buggy results. If you are not actively using the old PostgreSQL, and have the RPMset files to reinstall, you should be safe in issuing an 'rpm -e' for each postgresql rpm that 'rpm -qa|grep postgresql' returns. -- Lamar Owen WGCR Internet Radio 1 P

Re: [GENERAL] Cant connect if -B 1024 was set to postmaster

2001-03-19 Thread Lamar Owen
"Poul L. Christiansen" wrote: > > H, don't you mean /var/lib/pgsql/data/postmaster.opts ? Yes, I do. Monday morning. :-) GUC is much nicer in 7.1......one file. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--

Re: [GENERAL] Cant connect if -B 1024 was set to postmaster

2001-03-19 Thread Lamar Owen
/dev/null 2>&1" < /dev/null > I remember having this problem. You need to pass the '-i' switch. > Try: '-B 1024 -i' Add the line '-B 1024' to /var/lib/pgsql/data/pg_options along with the -i that is there already, the

Re: [GENERAL] Caldera Install

2001-03-15 Thread Lamar Owen
now what it spits back at you. You do need a complete development system, including the python developmet libraries, and at least version 3.0.5 of RPM. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 2: you can get off all l

Re: [GENERAL] Re: pgsql for Python

2001-03-09 Thread Lamar Owen
interested. What's the difference between PoPy and the PygreSQL driver included in the PostgreSQL distribution? Just curious. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Re: Order question

2001-02-13 Thread Lamar Owen
tuation with two ordernums being equal. Writing that in a single UPDATE would be left as an exercise for the reader :-). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] 7.1 installation problem

2001-02-12 Thread Lamar Owen
. The best thing to do (until RH 7 RPM's are built -- final release will definitely have RH 7 binaries) is to rebuild from the source RPM on all BUT RedHat 6.2. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] tuples too big

2001-02-08 Thread Lamar Owen
TOAST, however, is in the backend itself and is fully automatic. Hardcoded row limits on the amount of data per row (there is still a limit on the number of _columns_ in a row, but not on the size of each column) are gone in 7.1. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] .mips.rpm

2001-02-08 Thread Lamar Owen
cobaltqube.org site lists a couple of archives, but neither have PostgreSQL 7 RPM's. The latest Qube RPM for PostgreSQL that I have found is for 6.5.3. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] RE: Why is there so much MySQL bashing???

2001-01-18 Thread Lamar Owen
hen postmaster is started, or when a backend is first brought up on the table in question, or even a standalone migration utility that doesn't require an old version of the backend to read the old version files), but I wouldn't hold your breath. Yes, the existing scheme is a little baroque -

Re: [GENERAL] RE: Why is there so much MySQL bashing???

2001-01-17 Thread Lamar Owen
orge switched for performance reasons. Seems there was a great deal of Postgres-bashing from the MySQL side not long ago. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] postgresql.conf ignored

2001-01-17 Thread Lamar Owen
previous version, and my development server has 7.1beta3 installed. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] PostgreSQL v7.1BETA3 Bundled and Available ...

2001-01-11 Thread Lamar Owen
Mike Cannon-Brookes wrote: > > Will there be RPMs for this beta? (Whoever makes the RPMs ;)) I do, and am working on them. There are a few changes I have to integrate from various sources, as well as stress-testing the build, etc. Look for RPM's Sunday, possibly sooner. -- Lama

Re: [GENERAL] 7.0.3 rpm testing & other problems

2001-01-04 Thread Lamar Owen
name change in the file due to confusion in KFM and the GNOME file manager -- they were trying to open the README with kpackage or GNoRPM Thanks for the quick answers, Peter. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Lamar Owen
Alfred Perlstein wrote: > Lamar Owen wrote: > > But, then again, if the default settings are so bad performance-wise, > > why _are_ they the default anyway? There should be good reason, of > > course, but I think maybe the defaults could or should be revisited as > >

Re: [GENERAL] red hat/mysql fiasco

2000-12-21 Thread Lamar Owen
tions to include potentially faulty combinations with certain programs. Mandrake is known for aggressive -O settings. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] Large files on linux

2000-12-11 Thread Lamar Owen
PostgreSQL segments nicely for tables. But, unless you do chunking, it _does_ affect dumpfile size. Someone posted awhile back a script that did dumpchunking. Should be in the archives. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] Many postmasters...

2000-12-06 Thread Lamar Owen
0's multithreaded nature will help this -- unless a mechanism can be devised to share database connections amongst multiple full processes for older Apache's. Multithreading is a big win for clients that generate multiple connections -- it's not a big win for backends that serve multiple connections. IMHO. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] Can PostGreSQL handle 100 user database?

2000-11-30 Thread Lamar Owen
t; You are wrong. The file size limit has to do with the data size of > your file offset pointer. This is not necessarily a 32 bit quantity > on a 32-bit processor. If the file offset pointer is a signed integer, then it holds. That is an OS specific issue as to the type of the pointer. -- La

Re: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-17 Thread Lamar Owen
ile. Execute as root '/etc/rc.d/init.d/postgresql start' and it will both initdb and start the postmaster for you. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-17 Thread Lamar Owen
Rich Shepard wrote: > On Thu, 16 Nov 2000, Lamar Owen wrote: > > The result of 'rpm -qa|grep postgres' would be educational here. > [root@salmo rshepard]# rpm -qa | grep postgres > postgresql-server-6.5.3-1 > postgresql-test-6.5.3-1 > postgresql-7.0.3-2 > &qu

Re: [GENERAL] Script Location

2000-11-15 Thread Lamar Owen
k in) doesn't have read and execute permissions, you will get an error. To correct this problem, set your permissions appropriately in the directory you wish to use. Hope that helps! -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

[GENERAL] Updated RPMset available (7.0.3-2)

2000-11-15 Thread Lamar Owen
on. In addition to the change for this dependency bug, the 7.0.3-2 RedHat-style RPMset has experimental build support for ia64, as well as better build support for PowerPC, which prevents building with too high an optimization level. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-15 Thread Lamar Owen
or should not have occurred in the first place -- I guess a -2 RPMset is in order. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] 7.0.3 RPMs?

2000-11-13 Thread Lamar Owen
loaded. Silly little error on my part, really. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] 7.0.3 RPMs?

2000-11-13 Thread Lamar Owen
.3, as Ryan hasn't yet released a 7.0.3 patch. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] 7.0.3 RPMs?

2000-11-13 Thread Lamar Owen
What distribution are you using? -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] postgres on redhat 7.0

2000-11-01 Thread Lamar Owen
> Can this kind of stuff get put on a Red Hat mailing list, rather than sent > here? Thanks! pgsql-ports for PostgreSQL related stuff. I will announce soon some exciting news related to the RPM's, as well as a dedicated 'postgresqlrpms' mailing list, and the RPM spec files, p

Re: [GENERAL] postgres on redhat 7.0

2000-10-31 Thread Lamar Owen
If you need to patch the spec file or whatever else to get it to run, send the patches my way so we can make it just a simple --rebuild for most folks. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] how good is PostgreSQL

2000-10-31 Thread Lamar Owen
like 41,000 virtual machines each running Linux/390 and Apache. However, if you want to see the architecture of a _large_ database-backed website, see the story behind Digital City at www.aolserver.com. While they're using Sybase instead of PostgreSQL, the architecture is the same. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] pg_check 0.1.3 is now Available

2000-10-31 Thread Lamar Owen
migration -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] --enable-syslog in rh7 ?

2000-10-31 Thread Lamar Owen
onfigure switch (it exists both in CURRENT and REL7_0_PATCHES in CVS). > so the question is: if I put syslog = 2 in pg_options, it will work > in a rh7 with postgres out of the box ? Yes, it should. The patch was necessary for 7.0.2, but not for later than that. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] postgres on redhat 7.0

2000-10-31 Thread Lamar Owen
Adam Lang wrote: > > But it don't help if you downloaded the OS. ;) If you downloaded the RedHat CD ISO images, OR the ftp dirs, you got the postgresql RPM's, unless you specifically excluded them. And you can certainly get them from RedHat's ftp site, as busy as it i

Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?)

2000-10-26 Thread Lamar Owen
compatibility for other RPM's linked against libpq.so.2.0, which failed when libpq.so.2.1 came on the scene). I think the answer is no, but I haven't checked the details yet. Not just libpq, though -- libpgtcl.so has also been problematic. Of course, the file format on disk changes (again!

Re: [GENERAL] Postgres 7.0.2-2 on Red Hat 7.0?

2000-10-26 Thread Lamar Owen
>I fail to see the relevance of that argument. Popularity does not make > correctness. If I'm just being extremely dense about that sentence, feel > free to let me know. The relevance is that most who use it don't really care where the stuff is. They just want to upgrade. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] pgsql 7.0.2 on RH6.2 regression test failed

2000-10-24 Thread Lamar Owen
tion orders. The collation is unexpected by Unix standards, but is according to ISO standards. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

  1   2   >