re-instalation

Поиск
Список
Период
Сортировка
Искать
От
Martin A. Marques
Тема
re-instalation
Дата
Msg-id
01011917232202.29883@math.unl.edu.ar
Список
Дерево обсуждения
Re: re-instalation "Len Morgan" <len-morgan@crcom.net>
Re: re-instalation "Martin A. Marques" <martin@math.unl.edu.ar>
I had to re-compile and re-install postgresql-7.1-beta1.
I changed the directory where it was installed from /usr/local/pgsql to 
/dbs/postgres/. After re-installing I copied the data/ directory that was 
under the old instalation to where I have the new instalation.
After a bit of work I got it to work, but when I conect to any of the 
databases I see tables that don't belong there:

postgres@ultra31:~ > psql horde
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
 
horde=# \dt
         List of relations
      Name       | Type  |  Owner
-----------------+-------+----------
 active_sessions | table | postgres
 imp_addr        | table | postgres
 imp_pref        | table | postgres
 pga_forms       | table | postgres
 pga_queries     | table | postgres
 pga_reports     | table | postgres
 pga_schema      | table | postgres
 pga_scripts     | table | postgres
(8 rows)


Any ideas why those pg* tables are there?

TIA.

-- 
System Administration: It's a dirty job, 
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------
В списке pgsql-general по дате отправления
От: Nathan Heagy
Дата:
Сообщение: SQL on startup
От: Peter Eisentraut
Дата:
FAQ