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
