[PostgreSQL-Brasil] Instalando o PostgreSQL no UBUNti 6.06

[Raul Iavelberg]

Tiago,

Consegui o texto abaixo na internet; está em inglês (sorry...); 
funcionou perfeitamente.
Qualquer dúvida me contacte ( o sudo é muito chato...).

[]s
Raul Iavelberg

===============================================================================


    Installing Postgres-8.1 on Ubuntu

Here's how I setup Postgres on my Ubuntu(6.06) development machine.

*Install*

Postgres 8.1 is now in Universe so you don't have to modify 
*/etc/apt/sources.list* any more before doing this.

|*sudo apt-get install \*|*

|      postgresql-8.1 \|

|      postgresql-client-8.1 \|

|      postgresql-doc-8.1 \|

|      postgresql-server-dev-8.1 |*

* *

*Configure postgres*

I set all local accounts to be trusted so that I don't have to be 
bothered with passwords. This will let me leave the password field blank 
in my database.yml files. This wouldn't be a good idea outside your 
development environment.

Edit the file: */etc/postgresql/8.1/main/pg_hba.conf*

Change the line that looks like this...

|*local all all ident sameuser*|**

To this...

|*local all all trust*|**

*Reload Postgres*

We changed postgres's configuration so we need to let it know.

|*/etc/init.d/postgresql-8.1 reload*|**

*Become Superuser*

I give my normal user account superuser access to postgres. This will 
allow me to create db user's and databases to match what ever project 
I'm working on.

|*sudo su postgres*|*

|createuser -s username|*

========================================================================================

		
_______________________________________________________ 
Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular. Registre seu aparelho agora! 
http://br.mobile.yahoo.com/mailalertas/