re-instalation

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: pgsql-general(at)postgresql(dot)org, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: re-instalation
Date: 2001-01-19 20:23:22
Message-ID: 01011917232202.29883@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)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(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Len Morgan 2001-01-19 20:36:11 Re: re-instalation
Previous Message Nathan Heagy 2001-01-19 20:23:00 SQL on startup

Browse pgsql-hackers by date

  From Date Subject
Next Message Len Morgan 2001-01-19 20:36:11 Re: re-instalation
Previous Message Ian Lance Taylor 2001-01-19 20:06:15 Re: Re: [PATCHES] s_lock.h cleanup