Loeke <LoekeDoeLoekeDoe(at)hotmail(dot)com> writes:
> why does template0 not work?
It's not supposed to.
> is this the only way to use psql : psql -d templateXX
> or can you also get something working like: psql -d mydb
You need to create some databases in your installation. You may care to
read a little in the Administrator's Guide, eg
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html
which in particular explains what template0 is for and why the system
won't let you into it.
regards, tom lane