Very impressive software IMO
I really came into contact with PSQL during the process of replacing my Solaris (office) server with Win2k3 servers. One of the problems back then; the SQL backend. I didn't want any Oracle-based solutions anymore so the choice was simple (sort off).
After I installed it I was expecting something like I've seen with MySQL /years/ ago; namely an installed product and basically an approach like: "Ok, this is how it looks like on Linux so this is what you get on Windows. Have fun!". Iow; deeply diving into the documentation to check up on editing the config files (postgresql.conf, pg_hba.conf, etc.). And all using commandline of course; a bit like using Apache on Windows. Now, using cli this isn't a con or something, far from it, but it would have meant a slightly longer time to get my stuff going.
"When on Windows do like Windows does", I think the PSQL guys must have thought or realized that. And so I had the option to install pgAdmin. Simply during installation of the product, no special options or features or looking for solutions. Nah; you just install it. And not "just" a program ("quick hack which works on Windows and when it doesn't its probably your fault") but something which is very usable too!
PSQL for dummies ?
Perhaps. But it sure has helped this 'dummy' to get up to speed with PSQL but at my own pase. Of course I checked the important stuff first (host setting in pg_hba.conf for example) but once I was convinced all was securely setup I first relied on pgAdmin to setup some roles to logon, setup databases and in the first weeks to make some manual backups.
And so I could easily put PSQL to work even though I wasn't familiar with all the details yet, I looked into those during the weeks after installation and eventually setup a (commandline based) automated backup through means of a cronjob, err, "scheduled task". (yes, you even get pg_dump and pg_dumpall just as you'd expected).
Right now PSQL is powering my office CRM and both company mailservers (also using an automated replicated database) and even though my hardware is dated (these critters probably wouldn't be able to run Win 2k8 server (perhaps barely)) their performance certainly isn't!
I'm also very impressed with what I can squeeze out of my servers (context: hundreds (sometimes peeking at thousand) emails per day, a few (low profile) websites using a sql backend, Java based crm which is at least used by one person during the day (often 2 or 3), and (I'm proud of this one:) sometimes a remote connection from my workstation (odbc) to retrieve customer info from the crm database which is then used within Office 2010 (through means of vba macros).
Its no enterprise but it sure manages to do an impressive job, day in and day out. I've been highly impressed with PSQL the day I started using it and I fully realize that I haven't even /scratched/ the surface yet (stored procedures anyone?).
Still; if there's one team which can tackle the enterprise its them! IMVHO of course.