Re: re-instalation

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.

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

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Never look a gift horse in the mouth.
        -- Saint Jerome