Debian and Postgres 9.0

[Fernando Duran]

Another more likely possibility is that you still need to do this step: http://www.postgresql.org/docs/8.4/interactive/creating-cluster.html , funny enough I don't remember doing it, I think apt-get must have taken care of it.


---------------------
Fernando Duran
http://www.fduran.com


--- On Tue, 4/19/11, Fernando Duran <liberosec-FFYn/CNdgSA at public.gmane.org> wrote:

> From: Fernando Duran <liberosec-FFYn/CNdgSA at public.gmane.org>
> Subject: Re: [TLUG]: Debian and Postgres 9.0
> To: tlug-lxSQFCZeNF4 at public.gmane.org
> Received: Tuesday, April 19, 2011, 12:10 PM
> Weird, it seems you installed (or it
> was already installed) a cluster facility in postgres and
> now psql is asking which cluster to use. I don't know about
> clusters, what's the output of?:
> 
> dpkg --get-selections |grep postgres
> 
> 
> ---------------------
> Fernando Duran
> http://www.fduran.com
> 
> 
> --- On Tue, 4/19/11, William O'Higgins Witteman <william.ohiggins-H217xnMUJC0sA/PxXw9srA at public.gmane.org>
> wrote:
> 
> > From: William O'Higgins Witteman <william.ohiggins-H217xnMUJC0sA/PxXw9srA at public.gmane.org>
> > Subject: Re: [TLUG]: Debian and Postgres 9.0
> > To: tlug-lxSQFCZeNF4 at public.gmane.org
> > Received: Tuesday, April 19, 2011, 11:46 AM
> > On Tue, Apr 19, 2011 at 08:15:09AM
> > -0700, Fernando Duran wrote:
> > 
> > >Then just change to the postgres user:
> > >
> > ># su postgres -
> > >
> > >And call the postgres command line utility:
> > >
> > >$ psql
> > 
> > Installation is easy - it is Debian, after all.  I
> had
> > to create a
> > password for the postgres user (not obvious), but once
> I
> > was in I get
> > this:
> > 
> > ~ ] psql
> > Error: No existing local cluster is suitable as a
> default
> > target. Please
> > see man pg_wrapper(1) how to specify one.)
> > 
> > Reading man pg_wrapper(1) is not as helpful as I have
> > hoped. How (and
> > where) do I specify a local cluster, on Debian, for
> > 9.0?  The docs are
> > not clear, and I have read reams of advice just like
> the
> > very helpful
> > advice above.  So far, all of it is missing steps
> > somewhere, or the
> > commands are not valid under my version or distro.
> > -- 
> > 
> > yours,
> > 
> > William
> > 
> >
> --
> The Toronto Linux Users Group.     
> Meetings: http://gtalug.org/
> TLUG requests: Linux topics, No HTML, wrap text below 80
> columns
> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
> 
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists