Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Martin Marques
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)

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Jonathan Bartlett
> 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 defin

Re: PostgreSQL or MySQL on RedHat [SOLVED]

2003-09-03 Thread Nick Marsh
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

2003-09-03 Thread Reuben D. Budiardja
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

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Ed Wilts
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 G

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Jason Dixon
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

PostgreSQL or MySQL on RedHat

2003-09-03 Thread Nick Marsh
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. nick marsh [EMAIL PROTECTED] -- redhat-list mailing list unsubscribe mailto

Re: Problem when transfering postgresql data folder

2003-08-14 Thread Edward Croft
On Fri, 2003-08-08 at 05:12, JImmy NGu wrote: > I've tried to backup the database in a postgresql server by copying > the folder /var/lib/pgsql/data, and i transfered the folder to another > server's /var/lib/pgsql/ folder and try to initialize postgres. But > there

Problem when transfering postgresql data folder

2003-08-10 Thread JImmy NGu
I've tried to backup the database in a postgresql server by copying the folder /var/lib/pgsql/data, and i transfered the folder to another server's /var/lib/pgsql/ folder and try to initialize postgres. But there seems to be a problem. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-us

Re: postgresql-perl in RH9

2003-06-12 Thread Andrei Gaponenko
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): sa

Re: postgresql-perl in RH9

2003-06-12 Thread Brian Ashe
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 g

postgresql-perl in RH9

2003-06-12 Thread Andrei Gaponenko
What happened to the postgresql-perl RPM package shipped with RH7.x-8.0? Perl scripts containing 'use Pg' are broken under RH9, since the Pg module (*not* DBD::Pg) is gone. I assume one can still grab the module from CPAN, but WHY is the rpm package gone without notice? It was not

Re: Postgresql

2003-06-10 Thread Edward Croft
> 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

2003-06-09 Thread Gordon Messmer
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

2003-06-09 Thread Alex
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

2003-06-09 Thread Mufit Eribol
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

Postgresql

2003-06-09 Thread Alex
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 to install bbstatus, a tool for traffic accounting. This tool works only with postgresql and it requires a database to be created, fr

Re: PostgreSQL won't restart

2003-03-17 Thread Brian Ashe
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 ch

PostgreSQL won't restart

2003-03-16 Thread Bob Hartung
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 system. Where should I begin looking? There is nothing in the logs and

Re: Mysql VS postgreSQL

2003-03-10 Thread Gordon Messmer
DuSTiN KRySaK wrote: Hi there - just learning redhat, and I need to learn a SQL - now I was wondering what the diff was between Mysql VS postgreSQL? Is one easier for a beginner than the other? One more stable? One play nicer with web pages (that will be my use for it). You probably won't

Re: Mysql VS postgreSQL

2003-03-10 Thread Todd A. Jacobs
On Mon, 10 Mar 2003, DuSTiN KRySaK wrote: > wondering what the diff was between Mysql VS postgreSQL? Is one easier They are similar but different. The best thing to do is to determine what functionality your relational database needs, and then pick the one that comes closest to meeting th

Mysql VS postgreSQL

2003-03-10 Thread DuSTiN KRySaK
Hi there - just learning redhat, and I need to learn a SQL - now I was wondering what the diff was between Mysql VS postgreSQL? Is one easier for a beginner than the other? One more stable? One play nicer with web pages (that will be my use for it). Thanks! d -- redhat-list mailing list

Re: MySQL vs. PostgreSQL

2003-02-27 Thread Andy Elacion, Jr.
y not that scary ;) http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=backup.html /B - Original Message - From: "Juan Nin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 11:19 Subject: Re: MySQL vs. PostgreSQL > F

RE: MySQL vs. PostgreSQL

2003-02-27 Thread Larry Brown
: MySQL vs. PostgreSQL I just shut down mysql and copy the directory to a folder that is backed up on the regular backup so the database down time is about a minute. The only problem with this is if you have set up your user access rights in the mysql database which is the one used by mysql to grant

RE: MySQL vs. PostgreSQL

2003-02-27 Thread Larry Brown
Ryurick M. Hristev Sent: Thursday, February 27, 2003 5:57 PM To: [EMAIL PROTECTED] Subject: Re: MySQL vs. PostgreSQL On Wed, 26 Feb 2003, Joe Giles wrote: > Question about backing up... > > Sorry if this is not on the lines of what you guys are talking about, > but I set up MySQL and I

Re: MySQL vs. PostgreSQL

2003-02-27 Thread David Busby
/maintenance.sql -U $DB_USER $DATABASE - Original Message - From: "Ryurick M. Hristev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 14:56 Subject: Re: MySQL vs. PostgreSQL > On Wed, 26 Feb 2003, Joe Giles wrote: > > > Questio

Re: MySQL vs. PostgreSQL

2003-02-27 Thread Ryurick M. Hristev
On Wed, 26 Feb 2003, Joe Giles wrote: > Question about backing up... > > Sorry if this is not on the lines of what you guys are talking about, > but I set up MySQL and I sym link the database from one file system to > another for redundancy purposes. So, when I upgrade, I just break the > link an

Re: MySQL vs. PostgreSQL

2003-02-27 Thread dbrett
: > Hi, > > I'm about to make a kind of yahoogroups in PHP. It's for a University, so it > will be used a lot. > I'm considering using either MySQL or PostgreSQL... > > Which one would you recommend for this project? > I've always heared that Postgre

Re: MySQL vs. PostgreSQL

2003-02-27 Thread Martin Marques
comments good or bad so I don't get stuck in the > future... Horrible idea. Do daily dumps, and use those when you upgrade you MySQL system, or PostgreSQL. Thats what dumps are for! -- Porqué usar una base de datos rel

Re: MySQL vs. PostgreSQL

2003-02-27 Thread Martin Marques
On Mié 26 Feb 2003 18:58, Ryurick M. Hristev wrote: > > > That's true with all the database systems I have used (Informix, Oracle > > and PostgreSQL). > > It has to do with how diferent versions handly the database files, and > > how it changes. Any way, you don&

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Joe Giles
Well, I stated that for redundancy I created sym links. That isn't the proper wording I should have used. What I meant to say was I created sym links from one file system to another for space reasons. I ran out of space on the /var part. so I linked the databases to another fs. Sorry for the misund

Re: MySQL vs. PostgreSQL

2003-02-26 Thread nate
Joe Giles said: > Question about backing up... > > Sorry if this is not on the lines of what you guys are talking about, but > I set up MySQL and I sym link the database from one file system to another > for redundancy purposes. So, when I upgrade, I just break the link and > upgrade, then re link.

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Joe Giles
Question about backing up... Sorry if this is not on the lines of what you guys are talking about, but I set up MySQL and I sym link the database from one file system to another for redundancy purposes. So, when I upgrade, I just break the link and upgrade, then re link. It has worked so far (well

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Ryurick M. Hristev
On Wed, 26 Feb 2003, Martin Marques wrote: > On Mié 26 Feb 2003 16:19, Juan Nin wrote: > > From: "David Busby" <[EMAIL PROTECTED]> [...] > > I've heared that upgrading is more painfull with PostgreSQL, since you have > > to dump the database

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Anthony E. Greene
Juan Nin wrote: I've heared that upgrading is more painfull with PostgreSQL, since you have to dump the databases and restore them again after the upgrade Dump and rebuild is an easy and reliable way to preserve your data through db engine updates. Are you saying that if the binary formats

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Juan Nin
From: "David Busby" <[EMAIL PROTECTED]> > Juan, > After performing the Dump/Import for the upgrade once it's cake. There > are two utilities that you can use > pg_dump > to dump data > psql < [file] > to restore > so before I upgrade I simply > pg_dump [options] [dbname] > to my ar

Re: MySQL vs. PostgreSQL

2003-02-26 Thread David Busby
amp;file=backup.html /B - Original Message - From: "Juan Nin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 11:19 Subject: Re: MySQL vs. PostgreSQL > From: "David Busby" <[EMAIL PROTECTED]> > > > I'

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Juan Nin
From: "Stefan Neufeind" <[EMAIL PROTECTED]> > Well yes and know to the use / not use MySQL-question. I wouldn't > rate the university-use "mission critical". It runs good, that's what > I hear from many people. And it's stablizing more and more. Got a > bugfix-newsletter yesterday which only in

RE: MySQL vs. PostgreSQL

2003-02-26 Thread Christian Brink
> I've heared that upgrading is more painfull with PostgreSQL, > since you have > to dump the databases and restore them again after the upgrade Yes it's true you need to dump the databases and restore them, but I disagree that it's painful. It's fairly quick and ea

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Stefan Neufeind
On 26 Feb 2003 at 11:28, nate wrote: > Juan Nin said: > > > but I've heared that the new MySQL 4.x branch changes this a bit, > > and that from MySQL 4.1 there are nested queries support, etc > > I most certainly would reccomend AGAINST using mysql 4.x unless your > app has a long development ti

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Juan Nin
> I most certainly would reccomend AGAINST using mysql 4.x unless your > app has a long development time to give mysql 4.x time to stabilize(I > would not use it for probably at least a year). It still isn't "final" > according to mysql.com. And even after it is I would not deploy it > immediately.

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Shannon Neumann
pache was racking the processor utilization up tp 90+%. Just my .02. -- Shannon Neumann Neumannweb Computers www.neumannweb.net Juan Nin wrote: Hi, I'm about to make a kind of yahoogroups in PHP. It's for a University, so it will be used a lot. I'm considering using either

Re: MySQL vs. PostgreSQL

2003-02-26 Thread nate
Juan Nin said: > but I've heared that the new MySQL 4.x branch changes this a bit, and that > from MySQL 4.1 there are nested queries support, etc I most certainly would reccomend AGAINST using mysql 4.x unless your app has a long development time to give mysql 4.x time to stabilize(I would not u

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Stefan Neufeind
- scripts. The 4.x-branch changes this, as you already stated. But I wouldn't use 4.x in a "rough" production-environment at the moment. If you use it for your university that's okay I believe - but you can't use it in a REALLY critical environement yet. PostgreSQL has

Re: MySQL vs. PostgreSQL

2003-02-26 Thread Juan Nin
From: "David Busby" <[EMAIL PROTECTED]> > I've always loved PostgreSQL I use it for large and small projects, with > some real nasty/ugly nested queries. It still performs great even under > some heavy load. Make sure you get a real (real) fast HDD (LVD SCSI 15K &g

Re: MySQL vs. PostgreSQL

2003-02-26 Thread David Busby
I've always loved PostgreSQL I use it for large and small projects, with some real nasty/ugly nested queries. It still performs great even under some heavy load. Make sure you get a real (real) fast HDD (LVD SCSI 15K RPM), the slower the drive the slower the database in my experience

MySQL vs. PostgreSQL

2003-02-26 Thread Juan Nin
Hi, I'm about to make a kind of yahoogroups in PHP. It's for a University, so it will be used a lot. I'm considering using either MySQL or PostgreSQL... Which one would you recommend for this project? I've always heared that PostgreSQL is better for big databases with lots of

RE: PHP and PostgreSQL

2003-02-13 Thread Marius Andreiana
On Mi, 2003-02-12 at 19:30, Joel Lopez wrote: > I don't have a data/postgresql.conf file. it's created when you start postgresql for the first time ( service postgresql start ), don't create it by hand (as it has been mentioned, it's in /var/lib/pgsql/data ) -- Soluţi

RE: PHP and PostgreSQL

2003-02-12 Thread Patrick Nelson
Joel Lopez wrote: - I don't have a data/postgresql.conf file. But I do have a /usr/share/pgsql/postgresql.conf.sample file. should I copy and rename this file with out the .sample or should I place a copy in a /data directory somewhere? - Look under: /var/

Re: PHP and PostgreSQL

2003-02-12 Thread Gordon Messmer
On Wed, 2003-02-12 at 08:50, Joel Lopez wrote: > > I have installed Red Hat 8. I have been trying to use PostgreSQL with PHP > but I can't seem to connect to the DB. Dont' specify a hostname or port. If you do, the PostgreSQL libraries attempt a TCP/IP connection.

RE: PHP and PostgreSQL

2003-02-12 Thread Joel Lopez
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Joel Lopez Sent: Wednesday, February 12, 2003 9:31 AM To: [EMAIL PROTECTED] Subject: RE: PHP and PostgreSQL I don't have a data/postgresql.conf file. But I do have a /usr/share/pgsql/postgresql.conf.sample file. should I cop

RE: PHP and PostgreSQL

2003-02-12 Thread Joel Lopez
EMAIL PROTECTED]]On Behalf Of Marius Andreiana Sent: Wednesday, February 12, 2003 9:16 AM To: redhat-list Subject: Re: PHP and PostgreSQL On Mi, 2003-02-12 at 18:50, Joel Lopez wrote: > Hi, > > I have installed Red Hat 8. I have been trying to use PostgreSQL with PHP > but I can't

RE: PHP and PostgreSQL

2003-02-12 Thread Fontenot, Paul
Sent: Wednesday, February 12, 2003 10:16 AM To: redhat-list Subject: Re: PHP and PostgreSQL On Mi, 2003-02-12 at 18:50, Joel Lopez wrote: > Hi, > > I have installed Red Hat 8. I have been trying to use PostgreSQL with > PHP but I can't seem to connect to the DB. for all db ad

Re: PHP and PostgreSQL

2003-02-12 Thread Marius Andreiana
On Mi, 2003-02-12 at 18:50, Joel Lopez wrote: > Hi, > > I have installed Red Hat 8. I have been trying to use PostgreSQL with PHP > but I can't seem to connect to the DB. for all db admin tasks login as the user postgres, don't use root. Don't set a password for pos

Re: PHP and PostgreSQL

2003-02-12 Thread papapep
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joel Lopez wrote: | Hi, | | I have installed Red Hat 8. I have been trying to use PostgreSQL with PHP | but I can't seem to connect to the DB. | I have created a user and a DB in postgres. What is the proper way to set | up the DB and new

PHP and PostgreSQL

2003-02-12 Thread Joel Lopez
Hi, I have installed Red Hat 8. I have been trying to use PostgreSQL with PHP but I can't seem to connect to the DB. I have created a user and a DB in postgres. What is the proper way to set up the DB and new user? Should the new user be the owner of the DB? Thanks for the help.

Re: Segmentation Fault with Postgresql Updates

2003-02-06 Thread Gordon Messmer
On Thu, 2003-02-06 at 02:26, Alan Harding wrote: > > I was attempting to update the Postgresql packages on my machine when I > started getting Segmentation Faults. ... > So I tried both Red-carpet and apt-get to see if it would update. Both > give the same error. Sounds like th

Segmentation Fault with Postgresql Updates

2003-02-06 Thread Alan Harding
I am having a few issues with the above and wondered if anyone can help. I was attempting to update the Postgresql packages on my machine when I started getting Segmentation Faults. It seems every time it attempts to update the main Postgresql package the error occurs. Now seeing as how I am not

Re: PostgreSQL Triggers/PHP

2003-02-05 Thread Anthony E. Greene
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.

PostgreSQL Triggers/PHP

2003-02-05 Thread David Busby
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. How can I have the P

Re: Postgresql

2003-02-03 Thread Gary Stainburn
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 y

Re: Postgresql

2003-02-03 Thread Anthony E. Greene
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

Postgresql

2003-01-31 Thread Delao, Darryl W
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 -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com

Re: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Gordon Messmer
On Fri, 2003-01-24 at 08:24, [EMAIL PROTECTED] wrote: > The /var/lib/pgsql/data directory does have one file in it: pg_hba.conf. > This file was present after my installation process, I didn't move it > there. It shouldn't have been. It's not owned the the package or created by the post install

Re: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Rebecca . R . Hepper
Thanks to everyone for the help. Everything is working although I am not sure what caused my original problem. I removed the /var/lib/pgsql/data dir, erased the postgresql RPMs, installed them again, ran an initdb and things are working fine now

Re: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Hardy Merrill
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote: > > The /etc/init.d/postgresql script actually does an initdb for me. Here is > a copy of that line from the script: > > su -l postgres -s /bin/sh -c "/usr/bin/initdb --pgdata=/var/lib/pgsql/data > > /dev/null 2>&1&

RE: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Rebecca . R . Hepper
Yes, the following postgresql RPMs were installed during kickstart: postgresql-7.2.2-1 postgresql-libs-7.2.2-1 postgresql-server-7.2.2-1 "Mobeen

Re: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Rebecca . R . Hepper
The /etc/init.d/postgresql script actually does an initdb for me. Here is a copy of that line from the script: su -l postgres -s /bin/sh -c "/usr/bin/initdb --pgdata=/var/lib/pgsql/data > /dev/null 2>&1" < /dev/null After this line, it checks whether a PG_VERSION file e

RE: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Mobeen Azhar
Rebecca, how did you install PostGreSQL? Did you install it from the RPM? --Moby -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hardy Merrill Sent: Friday, January 24, 2003 08:36 To: [EMAIL PROTECTED] Subject: Re: Problems starting postgresql in

Re: Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Hardy Merrill
what I've outlined above is all you need to do. HTH. -- Hardy Merrill Senior Software Engineer Red Hat, Inc. [EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote: > Hi All, > > I just installed RedHat 8.0 on a system. I receive a failure status when I > try to start the postrgresql server by

Problems starting postgresql in RedHat 8.0

2003-01-24 Thread Rebecca . R . Hepper
Hi All, I just installed RedHat 8.0 on a system. I receive a failure status when I try to start the postrgresql server by doing the following command as root: /etc/init.d/postgresql start It is failing because there is no PG_VERSION file at /var/lib/pgsql/data. In the data directory, there is

postgresql on RH8 different than 7.1?

2003-01-21 Thread Kall, Bruce A.
I just upgraded to RH8 (from RH7.1). When I try any psql commands with syntax like: psql -U postgres -l I get psql: FATAL 1: IDENT authentication failed for user 'postgres' But if I do a psql -l (after doing a su - postgres) it returns that I have two databases , template0 and template1 both

Re: How connect to postgresql database from C program ?

2003-01-05 Thread Anthony E. Greene
On 05-Jan-2003/11:49 +0330, Shiva Haddad <[EMAIL PROTECTED]> wrote: >Hi every body, >I download C API example from POstgreSQL .com and compile and link >example and set ODBC drivers in linux, but when I run example , it didn't >connect to database. >how can I connect to

How connect to postgresql database from C program ?

2003-01-05 Thread Shiva Haddad
Hi every body, I download C API example from POstgreSQL .com and compile  and link example and set ODBC drivers in linux, but when I run example , it didn't connect to database. how can I connect to databade from C functions program.        

Re: postgresql database script idea

2002-12-10 Thread Bret Hughes
>probably been done". > > I thought that a couple of years ago, but when I looked I didn't find > anything. That may have changed. I use pgaccess for interactive editing > and GtkSQL when I need to make query output presentable. I just found that the webmin postgresql mod

Re: postgresql database script idea

2002-12-09 Thread Anthony E. Greene
-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

postgresql database script idea

2002-12-08 Thread Bret Hughes
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 tasks. Then I thought hey how hard would it be to write a script that would build a basic page from the table schema to

Re: Mysql or Postgresql

2002-11-19 Thread Aly Dharshi
True, I know this one, but by default the other database servers support case-insensitivity, this includes oracle, mysql, sapdb if I am not wrong since its oracle compatible. We had to change our application to deal with this by lowercasing all the data which we never had a problem with in MySQL p

Re: Mysql or Postgresql

2002-11-19 Thread Jonathan Bartlett
Referential integrity is only a small part of the relational idea. In fact, I should mention that no database system that I know of implements the relational idea fully. However, MySQL is just much further away than others. Jon On Mon, 18 Nov 2002, Todd A. Jacobs wrote: > On Mon, 18 Nov 2002,

Re: Mysql or Postgresql

2002-11-19 Thread Jens Tautenhahn
> The only thing that I dislike about Postgres is the case-sensitivity of > data in the database, if anybody knows how to turn it off let me know. You can use select statements like this: select * from abc where upper(xyz) = 'SEARCH'; select * from abc where xyz ~* 'search'; POSIX Regular Express

Re: Mysql or Postgresql

2002-11-18 Thread Todd A. Jacobs
On Mon, 18 Nov 2002, Jonathan Bartlett wrote: > MySQL does not support the relational idea very well. Sure it does. It's just that support for referential integrity is fairly recent. -- "Whenever I feel blue, I start breathing again." - Unknown -- redhat-li

Re: Mysql or Postgresql

2002-11-18 Thread Jonathan Bartlett
> i've been a fan of mysql as of late because it's simple and fast. AND the > documentation is great. postgres is the opposite of all of the above. ctually, the 7.x series of Postgres is quite fast. Using Postgres on an RH system is as easy as service postgresql start; su postg

RE: Mysql or Postgresql

2002-11-18 Thread Jonathan Bartlett
ated to SAP itself? > > > > Cheers, > > Ronald > > > > > > -Original Message- > > From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]] > > Sent: maandag 18 november 2002 15:11 > > To: [EMAIL PROTECTED] > > Subject: Re: Mysql or Postgresql > &

RE: Mysql or Postgresql

2002-11-18 Thread Jonathan Bartlett
To: [EMAIL PROTECTED] > Subject: Re: Mysql or Postgresql > > > Before I start, let me first say that you have left out two very good > open-source databases from consideration - SAP DB and Interbase. You > might look into both of these. Anyway, as to your specific question: > >

Re: Mysql or Postgresql

2002-11-18 Thread Aly Dharshi
amp; ... > > which one is better , Mysql or postgresql ? > > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe > https://listman.redhat.com/mailman/listinfo/redhat-list -- Aly S.P Dharshi [EMAIL PROTECTED] Student and Syste

Re: Mysql or Postgresql

2002-11-18 Thread gabriel
duct, it must be multi-user & ... > which one is better , Mysql or postgresql ? -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list

Re: Mysql or Postgresql

2002-11-18 Thread Frank Bax
At 11:50 PM 11/17/02, Shiva Haddad wrote: I want to have client , server database in redhat for a IP Telephone system product, it must be multi-user & ... which one is better , Mysql or postgresql ? From what I've read, it appears to depend on what you will do. If your system will b

RE: Mysql or Postgresql

2002-11-18 Thread maillist
wrote: > Never heart of SAP DB. Is it related to SAP itself? > > Cheers, > Ronald > > > -Original Message- > From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]] > Sent: maandag 18 november 2002 15:11 > To: [EMAIL PROTECTED] > Subject: Re: Mysql or Postgres

RE: Mysql or Postgresql

2002-11-18 Thread Ronald Hermans
Never heart of SAP DB. Is it related to SAP itself? Cheers, Ronald -Original Message- From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]] Sent: maandag 18 november 2002 15:11 To: [EMAIL PROTECTED] Subject: Re: Mysql or Postgresql Before I start, let me first say that you have left out

Re: Mysql or Postgresql

2002-11-18 Thread Jonathan Bartlett
example, PostgreSQL supports views, MySQL does not. This is very important if your database is going to be used by more than one application, or has a chance of changing in the future. PostgreSQL supports arbitrary types defined by the user, MySQL does not. PostgreSQL support _serializable_

Re: Mysql or Postgresql

2002-11-17 Thread Aly Dharshi
ernel (relevent) spots. Cheers, Aly. On Sun, 2002-11-17 at 22:51, nate wrote: > Shiva Haddad said: > > I want to have client , server database in redhat for a IP Telephone > > system product, it must be multi-user & ... > > which one is better , Mysql or po

Re: Mysql or Postgresql

2002-11-17 Thread nate
Shiva Haddad said: > I want to have client , server database in redhat for a IP Telephone > system product, it must be multi-user & ... > which one is better , Mysql or postgresql ? since redhat's 'official' database is postgres, if you are gonna run redhat, you'

Re: Mysql or Postgresql

2002-11-17 Thread Joshua Schmidlkofer
You are going to get a lot of opinion, but I believe that PostGreSQL would be best. On Sun, 2002-11-17 at 20:50, Shiva Haddad wrote: > I want to have client , server database in redhat for a IP Telephone > system product, > it must be multi-user & ... > which one is b

Mysql or Postgresql

2002-11-17 Thread Shiva Haddad
I want to have client , server database in redhat for a IP Telephone system product, it must be multi-user & ... which one is better , Mysql or postgresql ?

Re: graphical version of postgresql

2002-11-11 Thread Gordon Messmer
On Mon, 2002-11-11 at 21:37, Shiva Haddad wrote: > I'm new to linux , I installed RedHAt and I use Postgresql. > I want to use graphical version . But I don't know how can I do it . Depends on what release you're using. Prior to 8.0, postgresql-tk included a GUI PostgreS

Re: graphical version of postgresql

2002-11-11 Thread Bret Hughes
On Mon, 2002-11-11 at 23:37, Shiva Haddad wrote: > I'm new to linux , I installed RedHAt and I use Postgresql. > I want to use graphical version . But I don't know how can I do it . > > Would you mind help me? man pgaccess should get you started. Bret -- re

graphical version of postgresql

2002-11-11 Thread Shiva Haddad
I'm new to linux , I installed RedHAt and I use Postgresql. I want to use graphical version . But I don't know how can I do it .   Would you mind help me?

Re: [Solved] postgresql source install - can't find readline

2002-11-03 Thread john-paul delaney
For the record, after installing termcap-devel rpm, then running ldconfig, I was able to compile postgresql from source with readline. /j-p. -- redhat-list mailing list unsubscribe mailto:redhat-list-request@;redhat.com?subject=unsubscribe https://listman.redhat.com/mailman/listinfo

Re: postgresql source install - can't find readline

2002-11-03 Thread Michael Schwendt
-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

postgresql source install - can't find readline

2002-11-03 Thread john-paul delaney
Hello List... 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 configure states: ... checking for readline... no ... with the result that postgresql installs ok

  1   2   >