Re: re-instalation

El Vie 19 Ene 2001 22:32, Brett W. McCoy escribió:
> On Fri, 19 Jan 2001, Martin A. Marques wrote:
> > 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:
>
> You probably should have used pg_dumpall to backup the databases and
> restore them after the rebuild. That's a more reliable way of migrating
> your data.

The problem was that the server got downgraded from Solaris 8 to Solaris 7
and the binaries didn't work, so I recompiled. There was no way of using
pg_dump because I couldn't get the postmaster up.

> > 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?
>
> Those are system tables created and used by pgAccess.

They never apeared before.

And by the way, I see all the system tables when looking at any database with
pgaccess (another thing that didn't happen before).

Saludos... :-)

--
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
-----------------------------------------------------------------