Re: Are you frustrated with PostgreSQL

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Terence Chang <TChang(at)nqueue(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Are you frustrated with PostgreSQL
Date: 2003-07-14 23:43:14
Message-ID: 20030714234314.49481.qmail@web13403.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Terence Chang <TChang(at)nqueue(dot)com> wrote:
> I have the following questions. Please reply me
> offline, so the mailling
> list won't get flood. Thanks!

But if they don't read it, they can't correct me!
;-)

> 1. What is your favorite GUI tool for PostgreSQL?
I create apps using MS Access as the GUI front-end.
For administration, I use scripts and the command
line.

> 2. In your organization, do you have someone who
> works as full time
> PostgreSQL DBA?
No. We wear a lot of hats around here.

> 3. What is the biggest challenge you have with
> PostgreSQL? Administration or
> Programming?
Programming -- if I were a Programmer or a DBA, I
could do more. A solid database, a solid operating
system and a little scripting make day-to-day
administration easy enough.

> 4. Overall, do you like PostgreSQL? Would you
> recommend it over MySQL?
Yes, and yes. MySQL has a reputation for ease of
administration; however, I moved from MySQL to
PostgreSQL because missing features in MySQL meant
difficult work-arounds for users. Also, the \help
system in psql is very useful for people learning SQL.
As an end-user, I found PostgreSQL easier to use
than MySQL.

> 5. How often do your PostgreSQL run into problem or
> crash? Are most of the
> problem caused by PostgreSQL itself?
At work, I haven't had any unplanned down time since I
started using PostgreSQL over 3 years ago. At home, I
had a hard drive crash; but the databases were
restored from backup files without any problems.
Dependable backups should _not_ be taken for granted!

Best regards,

Andrew Gould

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-07-15 01:55:33 Re: Are you frustrated with PostgreSQL
Previous Message Jay O'Connor 2003-07-14 22:55:15 more performance questions