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
(text/plain)