You need to su to the user "postgres" from being root, then you will be able to do all that stuff. > -----Original Message----- > From: plug-discuss-admin@lists.plug.phoenix.az.us [mailto:plug-discuss- > admin@lists.plug.phoenix.az.us] On Behalf Of Michael Havens > Sent: Friday, April 16, 2004 12:18 AM > To: plug-discuss@lists.plug.phoenix.az.us > Subject: PostgreSQL > > > Well then, I suppose I'll learn PostgreSQL. It only took about 9 minutes > to > download too! I even found a tutorial for thcersion I apt-geted (7.2.1). > Unfortunately I ran into problems immediately (1). The tutorial said that > it > meant I didn't have permissions right but I don't know how to fix those. I > then figured I should try to create a user. That resulted in a new error > (2). > So my question is: how do I create a user? > > 1- > bmike1@1[bmike1]$ createdb mydb > psql: FATAL 1: user "bmike1" does not exist > createdb: database creation failed > bmike1@1[bmike1]$ sudo createdb mydb > psql: FATAL 1: user "root" does not exist > createdb: database creation failed > bmike1@1[bmike1]$ > bmike1@1[bmike1]$ > > 2- > bmike1@1[bmike1]$ sudo createuser bmike1 > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) y > psql: FATAL 1: user "root" does not exist > createuser: creation of user "bmike1" failed > bmike1@1[bmike1]$ > > > On Thursday 15 April 2004 21:07, Earl, Alex C wrote: > > I would have to agree with Jerry. It would depend on what you are > > looking for. I personally like PostgreSQL because its SQL is more > > compliant with the ISO standard, it also has the feature like Jerry > > mentioned of writing Perl (and you can add other languages) functions > > right in the database. PostgreSQL does have a smaller user base right > > now, I think it is because MySQL _looks_ so much easier to use. I used > > both for extended periods of time and personally felt that PostgreSQL > > suited my needs better. > > > > Alex > > > > > -----Original Message----- > > > From: plug-discuss-admin@lists.plug.phoenix.az.us > > > > [mailto:plug-discuss- > > > > > admin@lists.plug.phoenix.az.us] On Behalf Of Jerry Davis > > > Sent: Thursday, April 15, 2004 6:29 PM > > > To: plug-discuss@lists.plug.phoenix.az.us > > > Subject: Re: database > > > > > > On Thursday 15 April 2004 08:10 pm, Michael Havens wrote: > > > > A couple of people have recommended I do that. Something I need to > > > > know is > > > > > > why you recommend PostgreSQL over MySQL. I mean how is it better; > > > > does it > > > > > > have more of a future; is it easier to learn or is it just differant > > > > to > > > > > > learn? > > > > > > Mike, > > > > > > When I fooled around with MySQL and PostgreSQL, I was equally > > > > impressed with > > > > > both of them. > > > > > > 1) MySQL seemed faster for selects > > > 2) I liked PostgreSQL's ability to write perl functions right in the > > > > database. > > > > > So, I guess it depends upon what you want to do with it. > > > > > > I would go to both sites, and look at the features, to make a real > > > determination. > > > > > > I have a both O'Reilly books. Alas ... I am currently pretty far away > > > > from > > > > > Phoenix now. > > > > > > Jerry > > > > > > > I was advised not to go with it previously because I could get help > > > > from > > > > > > more people if I went with MySQL. > > > > > > > > > > > > > > > > Then again > > > > > > > > On Thursday 15 April 2004 17:19, Earl, Alex C wrote: > > > > > > > am I correct in assuming that you need Apache to be running to > > > > work > > > > > > > with > > > > > > > > > > > > MySQL? > > > > > > > > > > > > No. MySQL is completely independent. > > > > > > > > > > > > There is a very large and still fast growing field of > > > > development, > > > > > > > LAMP: > > > > > > Linux, Apache, MySQL, PHP. http://www.onlamp.com/ The tools > > > > work > > > > > > > very > > > > > > > > > > > well together, and will for a very long time since development > > > > of all > > > > > > > > these is geared toward working together AND working with as many > > > > other > > > > > > > > protocols as possible. For instance, I worked on a project that > > > > > > > > > > included > > > > > > > > > > > a DB2 database, which PHP could interface through an ODBC driver > > > > > > > > > > provided > > > > > > > > > > > by IBM. So it was a part LAMP and part LA[db2]P website. Since > > > > this > > > > > > > is > > > > > > > > > > > Linux goodness, you can also write cron jobs that run php on the > > > > > > > > > > command > > > > > > > > > > > line, e-mail users, automatically submit e-mails into a MySQL > > > > table, > > > > > > > > whatever. > > > > > > > > > > > > I also highly recommend http://safari.oreilly.com/ . > > > > > > > > > > > > --Alexander > > > > > > > > > > I personally recommend PostgreSQL over MySQL as well, I failed to > > > > > mention this earlier. I would also recommend using something like > > > > PEAR > > > > > > > to abstract the accesses to the database so that you can plug > > > > different > > > > > > > database servers into the back of your scripts. > > > > > > > > > > Alex > > > > > > > > > > --------------------------------------------------- > > > > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > > > > To subscribe, unsubscribe, or to change you mail settings: > > > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > > > > > This message has been scanned for viruses by the VEI Internet > > > > Automatic Email Spam and Virus Scanner, and is believed to be free > > > > of spam > > > > > > or viruses. Please report spam to spamtrap@vei.net. If you would > > > > like 98.9 > > > > > > % spam blocked from your E-mail then go to VEI Internet for details. > > > > Anti-spam/Anti-virus is FREE with every account. > > > > > > > > > > > > http://www.vei.net/ > > > > mailtospamtrap@vei.net > > > > --------------------------------------------------- > > > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > > > To subscribe, unsubscribe, or to change you mail settings: > > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > > > -- > > > Registered Linux User: 275424 > > > Today's Fortune: Traveling through hyperspace isn't like > > > dusting crops, boy. > > > -- Han Solo > > > --------------------------------------------------- > > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > > To subscribe, unsubscribe, or to change you mail settings: > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > --------------------------------------------------- > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > To subscribe, unsubscribe, or to change you mail settings: > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > > > > This message has been scanned for viruses by the VEI Internet > Automatic Email Spam and Virus Scanner, and is believed to be free of spam > or viruses. > Please report spam to spamtrap@vei.net. If you would like 98.9 % spam > blocked from your > E-mail then go to VEI Internet for details. Anti-spam/Anti-virus is FREE > with every account. > > > http://www.vei.net/ > mailtospamtrap@vei.net > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change you mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change you mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss