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