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(at)vesta(dot)tmf(dot)bg(dot)ac(dot)yu [mailto:zurron(at)vesta(dot)tmf(dot)bg(dot)ac(dot)yu]
Sent: Friday, December 27, 2002 2:40 PM
To: pgsql-general(at)postgresql(dot)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(at)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