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