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