On 3/20/17 3:40 PM, Jan de Visser wrote:
On Monday, March 20, 2017 3:30:49 PM EDT Robert Haas wrote:
On Sat, Mar 18, 2017 at 4:12 PM, Magnus Hagander <mag...@hagander.net>
wrote:
createdb, dropdb - also not clear they're about postgres, more likely to
be
used by mistake but not that bad. That said, do they add any *value*
beyond
what you can do with psql -c "CREATE DATABASE"? I don't really see one, so
I'd suggest dropping these too.
That would annoy me, because I use these constantly. I also think
that they solve a problem for users, which is this:
[rhaas ~]$ psql
psql: FATAL: database "rhaas" does not exist
[rhaas ~]$ psql -c 'create database rhaas;'
psql: FATAL: database "rhaas" does not exist
[rhaas ~]$ gosh, i know i need to connect to a database in order to
create the database to which psql tries to connect by default, so
there must be an existing database with some name, but what exactly is
that name, anyway?
-bash: gosh,: command not found
There was an occasion when this exact problem almost caused me to give
up on using PostgreSQL. Everybody here presumably knows that
template1 and postgres are the magic words you can add to the end of
that command line to make it work, but that is NOT self-evident to
newcomers.
Same here. I worked on a system with a shrink-wrap installer which installed
pgsql as well and initialized it for use by the system user of our software.
If a tester or sales engineer wanted to play with the DB, it would be about 30
minutes before they would end up at my desk, in tears.
How about adding a hint?
--
-David
da...@pgmasters.net
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
