[SLL] PostgreSQL installs with no role, tutorial leaves me stranded

[Bill Campbell]

On Mon, Aug 21, 2006, Xeno Campanoli wrote:
>I tried some tutorials I found for PostgreSQL today, and the version 
>that installs with Ubuntu leaves me with some kind of role missing 
>(presumably a username).  Is there a recent tutorial that takes this 
>kind of thing into account anyone know?  I'd like to get up to speed on 
>late postgreSQL, but I really don't want to beat myself up much doing 
>it, as I'm busy with lots of other stuff too.

I would have look at the installation scripts to see how ubuntu
initializes postgresql.  Typically it's initialized with a default
user like ``postgres'' or ``postgresql'' with the password the same
as the username.

You should be able to access it with ``psql -U postgres template1''
or ``psql -U postgresql template1'', entering the same password
as the username.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

Make no laws whatever concerning speech and, speech will be free; so soon as
you make a declaration on paper that speech shall be free, you will have a
hundred lawyers proving that ``freedom does not mean abuse, nor liberty
license;'' and they will define and define freedom out of existence.
	- Voltarine de Cleyre (1866-1912)