Re: question

Create a password for the postgresql user and use something like 'md5' for the authentication method in
$PGDATA/pg_hba.conf.

thank you!

~ Troy Campano ~

-----Original Message-----
From: zurron@vesta.tmf.bg.ac.yu [mailto:zurron@vesta.tmf.bg.ac.yu]
Sent: Friday, December 27, 2002 2:40 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] question



ok, I want that my data base be safe.
so, why if a put this command in the prompt like a regular user

zurron@gpsis:~$ /usr/local/pgsql/bin/psql -d colegio -U postgres

i get this:

Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

colegio=#

and here i can do whatever i want
what must i do for fix it?


colegio=# SELECT version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3 (1 row)


and

test_ip=# select version();
                                                 version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)
(1 row)

test_ip=#



thanks.

Fabian


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html