Thread: template0 1 psql -d .. (newbie)
ls, really newbie questions summary: i installend postgres 7.2 (on suse), -> ( so now, for the first time, i did) initdb /var/pg postmaster -D var/pg psql doenst work psql -l returns template0 and template1 psql -d template0 gives an error : not currently accepting connections (dont know why, how do i fix this) psql -d template1 works question: why does template0 not work? is this the only way to use psql : psql -d templateXX or can you also get something working like: psql -d mydb tnx,
Loeke <LoekeDoeLoekeDoe@hotmail.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