Re: PostgreSQL or MySQL on RedHat

El Mié 03 Sep 2003 12:48, Nick Marsh escribió: > I have been using MySQL on RedHat for about a year now. My hardcode geek > friends keep telling me that PostgreSQL is better. Can anyone offer some > insight as to the advantages of using one over the other? Thanks. Why use postgresql? 1) Triggers 2

Re: PostgreSQL or MySQL on RedHat

> I have been using MySQL on RedHat for about a year now. My hardcode > geek friends keep telling me that PostgreSQL is better. Can anyone offer > some insight as to the advantages of using one over the other? Thanks. PostgreSQL has the following: * user-defined functions (can be defined from C,

Re: PostgreSQL or MySQL on RedHat [SOLVED]

Bad question for this list. Sorry. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list

Re: PostgreSQL or MySQL on RedHat

On Wednesday 03 September 2003 11:48 am, Nick Marsh wrote: > I have been using MySQL on RedHat for about a year now. My hardcode geek > friends keep telling me that PostgreSQL is better. Can anyone offer some > insight as to the advantages of using one over the other? Thanks. This is more a databa

Re: PostgreSQL or MySQL on RedHat

On Wed, Sep 03, 2003 at 10:48:16AM -0500, Nick Marsh wrote: > I have been using MySQL on RedHat for about a year now. My hardcode > geek friends keep telling me that PostgreSQL is better. Can anyone > offer some insight as to the advantages of using one over the other? Start with Google. A search

Re: PostgreSQL or MySQL on RedHat

On Wed, 2003-09-03 at 11:48, Nick Marsh wrote: > I have been using MySQL on RedHat for about a year now. My hardcode geek friends > keep telling me that PostgreSQL is better. Can anyone offer some insight as to the > advantages of using one over the other? Thanks. Hi Nick. Please don't be offen

Re: postgresql-perl in RH9

Hi, Brian. > Install the postgresql-pl package. It was moved into > there. It is in the > changelog of the postgresql package. (not obvious, > but findable) The postgresql-pl package is installed (actually I am looking at a system with everything from RH9 distribution installed): sam ~$ rpm -ql

Re: postgresql-perl in RH9

Hello Andrei, Thursday, June 12, 2003, 5:54:32 PM, you textually orated: AG> What happened to the postgresql-perl RPM package AG> shipped with RH7.x-8.0? AG> Perl scripts containing 'use Pg' are broken under RH9, AG> since the Pg AG> module (*not* DBD::Pg) is gone. I assume one can AG> still

Re: Postgresql

> Alex > - Original Message - > From: "Mufit Eribol" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 10, 2003 2:49 AM > Subject: Re: Postgresql > > > > Enter 'su postgres' first. Then issue postgresql commands. > >

Re: Postgresql

Alex wrote: I did su - postgres but when I try to insert the file I get the same error. :( -bash-2.05b$ psql -U bbstatus -e bbstatus < bbstatus.sql psql: FATAL: IDENT authentication failed for user "bbstatus" Don't use the -U and -e args. psql tries to connect to a database with the same name as

Re: Postgresql

ED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 10, 2003 2:49 AM Subject: Re: Postgresql > Enter 'su postgres' first. Then issue postgresql commands. > > Mufit -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list

Re: Postgresql

Enter 'su postgres' first. Then issue postgresql commands. Mufit On Tue, 10 Jun 2003 02:37:31 +0300, Alex <[EMAIL PROTECTED]> wrote: Hello, Maybe someone can help me with this problem that I can't get past of. I have the following scenario: RH9 with postgresql installed from dist adn I want t

Re: PostgreSQL won't restart

Bob Hartung, On Sunday March 16, 2003 11:26, Bob Hartung wrote: > Hi all, >I had a new install of 7.2.2 running and I was just beginning to learn a > little about postgresql. Now, on rebooting postmaster fails to start - it > has started just fine for a month. I have made no changes to the s

Re: PostgreSQL Triggers/PHP

David Busby wrote: List, I've got a PHP script on a web site that allows for insertion of data into my PG database. After data is inserted I need to have a PERL script executed that will message many other hosts (sort of like replication). The PERL script can take a few minutes to execute.

Re: Postgresql

On Friday 31 January 2003 2:10 pm, Delao, Darryl W wrote: > Anyone know if postgres has a connections limit by default? I see a > connections limit in my conf file but it is commented out..Just curious > what the default limit is, if any. > > Darryl I've just asked this for you on the postgresql

Re: Postgresql

On 31-Jan-2003/08:10 -0600, "Delao, Darryl W" <[EMAIL PROTECTED]> wrote: >Anyone know if postgres has a connections limit by default? I see a >connections limit in my conf file but it is commented out..Just curious what >the default limit is, if any. I seem to remember a seciont on limits in the

Re: postgresql database script idea

On Mon, 2002-12-09 at 03:05, Anthony E. Greene wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 08-Dec-2002/21:06 -0600, Bret Hughes <[EMAIL PROTECTED]> wrote: > >I am working on porting an application to postgres and as I was tweaking > >the RI It dawned on me that I should go ahea

Re: postgresql database script idea

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08-Dec-2002/21:06 -0600, Bret Hughes <[EMAIL PROTECTED]> wrote: >I am working on porting an application to postgres and as I was tweaking >the RI It dawned on me that I should go ahead and build a series of >webpages that will perform basic CRUD tas

Re: postgresql source install - can't find readline

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 3 Nov 2002 20:37:47 +0100 (CET), john-paul delaney wrote: > I'm trying to install the latest verion of postgresql [7.2.3] after > removing the rpm installation (which worked ok with readline) on > RH7.3. My problem is that the output of confi

RE: Postgresql upgrade?

I went successfuly through upgrade. Unless you use triggers etc. the only thing you need is to restore the data in PSQL 7.2 after you init your dataspace and create the database. See user manual for details. Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Be

Re: Postgresql upgrade woe continues

On 07/08/02, at 10:42 PM, "Anthony E. Greene" <[EMAIL PROTECTED]> said: >Try moving or deleting the old data files under $PGHOME/data/base. When you >start PostgreSQL it should recreate the template database. When I tried to start postgres after doing that, it gave me the 'old version detected.

Re: Postgresql upgrade?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08-Jul-2002/21:29 -0400, [EMAIL PROTECTED] wrote: >After a RH7.1-7.3 upgrade, postgres won't start, complaining that I need >to update my data format. The instructions in the postgres >readme.rpm.dist file refer to a nonexistant program and make n

Re: postgresql

<[EMAIL PROTECTED]> wrote: > >I take it that this is not part of a regular installation and that I need to > download it? [info about tk 8.0 snipped] It should be on the CD. Tony -- Anthony E. Greene <[EMAIL PROTECTED]> PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA2

Re: postgresql

I take it that this is not part of a regular installation and that I need to download it? Thanks -- >From: tc lewis <[EMAIL PROTECTED]> >To: Redhat <[EMAIL PROTECTED]> >Subject: Re: postgresql >Date: Thu, Dec 20, 2001, 6:41 PM > > > [tcl@localhost tc

Re: postgresql

[tcl@localhost tcl]$ rpm -qi tk Name: tk Relocations: (not relocateable) Version : 8.3.3 Vendor: Red Hat, Inc. Release : 65Build Date: Wed 29 Aug 2001 12:11:39 PM PDT Install date: Wed 28 Nov 2001 08

Re: postgresql missing /lib/cpp

Thanks Wofgang, did that and works beautifully :)) Sorted cheers, Bodri - Original Message - From: "Wolfgang Pfeiffer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2000 4:09 PM Subject: Re: postgresql missing /lib/cpp >

Re: postgresql missing /lib/cpp

Bodri wrote: > > Hi, > > I'm trying to install postgresql 7.0.2-17 on my Redhat 7.0 distribution > (details in signature below). > I'm using GnoRPM to download and install the packages (postgresql, > postgresql-server and postgresql-devel). > When I click install after selecting the packages it

Re: postgresql missing /lib/cpp

On Thu, 16 Nov 2000, Bodri wrote: > When I click install after selecting the packages it says: > > "The following dependency problems occured: > postgresql-7.0.2-17 requires /lib/cpp" Install the "cpp" rpm. ___ Redhat-list mailing list [EMAIL PROTEC

Re: postgresql weirdness

Hi Larry, Well, everything I am going to tell you is assuming you have just done a stock install of some recent RedHat, or have used all RPMs to install. First type this at the prompt... /etc/rc.d/init.d/postgresql status You should get a response similar to this...(pid could be different) postm

Re: PostgreSQL 6.3.2 RPM?

>I don't suppose anyone out there has found an rpm version of v6.3.2 of >PostgreSQL? I looked in the contrib directory, but found none... > >Thanks! >Mike > >== try ftp://rufus.w3.org/linux/redhat-contrib/hurricane/i386/postgresql* -- PLEASE read the Red Hat FAQ, Ti

Re: PostgreSQL and MS-Access ... and Interbase!

Well, here it is for download, everyone ... http://www.interbase.com/ Brad === Bradley Kieser Don't go through life, grow through life. -- Eric Butterworth ---Chris Fishwick <[EMAIL PROTECTED]> wrote: > > > I must admit I find the idea that Borland will begin releasing Linux products > >

Re: PostgreSQL and MS-Access ... and Interbase!

> I must admit I find the idea that Borland will begin releasing Linux products > a bit unlikely. Does anyone have a pointer to more information? In fact, go to http://www.interbase.com, and you will see the banner tehre reads: Interbase 4.0 for RedHat Linux 4.2

Re: PostgreSQL and MS-Access ... and Interbase!

> I must admit I find the idea that Borland will begin releasing Linux products > a bit unlikely. Does anyone have a pointer to more information? >From what I hear, it is going to be released as a free product... dunno how true this is... Regards Chris Fishwick Technical Support Southern Inte

Re: PostgreSQL and MS-Access ... and Interbase!

[EMAIL PROTECTED] said: > I have since heard that Borland's Interbase is to be released with > native support for Linux. I would be interested to hear more about > this is anyone out there has any news or experience with Interbase > for this platform. > However, I must add that Interbase, tho

Re: PostgreSQL and MS-Access ... and Interbase!

I have since heard that Borland's Interbase is to be released with native support for Linux. I would be interested to hear more about this is anyone out there has any news or experience with Interbase for this platform. However, I must add that Interbase, though a good product, is for medium usea

Re: PostgreSQL and MS-Access

On Fri, 1 May 1998, Bradley Kieser wrote: > I am not certain about your options with commercial Ingres on Linux, > although I know that University Ingres is availble for it. Personally, I > would say go with Postgresql. There has been some traffic on our local user group mail list that CA will b

Re: PostgreSQL and MS-Access

Paul, Copy of a reply sent. Hope this helps! Brad. Marc., Ingres is a fully relational, heavyweight database capable of storing very large volumes of data (I have worked with up to 100GB of data with 50 users online on an 18-way Squent machine without ill effect!). It suppor

Re: PostgreSQL and MS-Access

I would be very interested in any Linux DB that can communicate with MS Access So any valuable infoe please cc to me Thanks Phil Bradley Kieser wrote: > ---Bruce Tong <[EMAIL PROTECTED]> wrote: > > > > I'm starting to work with PostgreSQL and I wonder if there is anyone out > > there who wouldn'

Re: PostgreSQL and MS-Access

---Bruce Tong <[EMAIL PROTECTED]> wrote: > > I'm starting to work with PostgreSQL and I wonder if there is anyone out > there who wouldn't mind answering a few questions via private e-mail? I use Ingres a LOT, and am installing PostgreSQL as well, so email me if you want, and I'll do my best.

Re: postgresql-6.3-1.rpm

> v6.3.1 seems to be there, v6.3.2 is now out but I'm unsure what benefits > that offers over v6.3.1. Security I think. Version 6.3-2 was supposed to fix a memory leak that developed in 6.3-1. Prior to the 6.3-2 release the general attitude was to stay with 6.2 and wait for the fix. Which looks l

Re: postgresql-6.3-1.rpm

On Wed, 29 Apr 1998, Chris Fenton wrote: > Please correct me if I am wrong but I believe only postgresql-6.3.1 has > a the necessary jdbc backend for java front-ending postgresql databases. > I was just wondering if one of you nice people had put together a rpm > for postgresql-6.3.rpm. It is ab

Re: PostgreSQL Documnetation

Hi, I was lurking around and was hoping that somebody would surely mention the PostgreSQL site address. I am enclosing below some relevant extracts that I have which should be helpful to the person searching for PostgreSQL related info. I had collected this more than a 9 months back and some of i

RE: postGreSQL documentation : A book?

Keep looking. I found a ps version of the document, and printed it out. Unfortunately, I do not have the URL. I will see if I can find it. Rich Minear [EMAIL PROTECTED] -Original Message- From: Chris Fenton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 19, 1998 4:46 AM To: [EMAIL

Re: PostGreSQL documentation, where ?

>What do you currently have? What I have is the contents of the doc >directory that came with the source code. If that's of interest to you, >send me e-mail and I'll send it. > > I have it too, but I want some more. Thanks anyway Claudiu Balciza ALTEX IMPEX srl str.Stefan Cel Mare nr.6 5600

Re: PostGreSQL documentation, where ?

What do you currently have? What I have is the contents of the doc directory that came with the source code. If that's of interest to you, send me e-mail and I'll send it. - Stephen > where can i find more postgresql documentation ?>> > > Claudiu Balciza > ALTEX IMPEX srl > str.Stefan

Re: postGreSQL documentation : A book?

ok exist and where. > For example 'PostGreSQL for idiots and biologists' Chris, I agree with your frustration with hypertext documents used for learning! What I did was to download the Postscript version of the Database-HOWTO (dealing exclusively with PostgreSQL--see "Re: P

Re: PostGreSQL documentation, where ?

On Thu, 19 Mar 1998, SC Altex Impex SRL wrote: > where can i find more postgresql documentation ? The Database-HOWTO (v4.0+) deals specifically with PostgreSQL and is a very good resource. You can find it (in HTML, DVI, Postscript, etc.) at ftp://sunsite.unc.edu/pub/Linux/docs/HOWTO/other-form