[LRUG] Reasons for Postgres

[Omar Qureshi]

The best thing is not have to worry about the confusion over whether to use
InnoDB over MyISAM on certain tables. Postgres offers the FTS that MyISAM
gives (if you're into having the FTS not tied into Sphinx or something
else), whilst also giving you the referential integrity that InnoDB gives -
without a thought!

On Mon, Nov 16, 2009 at 6:20 PM, Jocke Selin <jocke at selincite.com> wrote:

>
> On 16 Nov 2009, at 18:00, Sam Stokes wrote:
> >
> > I've heard before that the PostgreSQL CLI is nicer than MySQL's.  Is its
> permission system any easier to administer?  I don't think I've ever
> successfully run a GRANT ALL PERMISSIONS TO fred at localhost AND HIS DOG
> without having to look up the syntax every time.
>
> A cut-n-paste from my install notes:
> ----
> aptitude install postgresql
> su postgres
> createuser -S -D -R -P -E -e theusername
> createdb -E UTF-8 -O spine -e thedatabase_production
> Test by logging in:
> psql -h localhost -U theusername -W thedatabase_production
> ----
>
> Those commands create and run the SQL for you. :)
>
> /Jocke
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20091116/4cdc7209/attachment-0003.html>