Thread: Re: [GENERAL] 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 -----------------------------------------------------------------
Martin A. Marques writes: > > > Any ideas why those pg* tables are there? > > > > Those are system tables created and used by pgAccess. > > They never apeared before. You probably never ran pgaccess 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). Go to the menu Databases -> Preferences and check off "View system tables". -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
El Sáb 20 Ene 2001 18:43, Peter Eisentraut escribió: > Martin A. Marques writes: > > > > Any ideas why those pg* tables are there? > > > > > > Those are system tables created and used by pgAccess. > > > > They never apeared before. > > You probably never ran pgaccess before. No, I used to run pgaccess daily. > > And by the way, I see all the system tables when looking at any database > > with pgaccess (another thing that didn't happen before). > > Go to the menu Databases -> Preferences and check off "View system > tables". Great Peter!! That did it! (I'm clueless!!!! :-P ) -- 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 -----------------------------------------------------------------
On Sat, 20 Jan 2001, Martin A. Marques wrote:
> > 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.
Doh! You should smack the admin who downgraded without warning you so you
could take appropriate measures! :-) Why did you downgrade in the
firstplace? Just curious...
The problem with just moving your database to the new location is that
there are location dependencies built into it when you use initdb to
initialize it, so it's not reliable. Of course, if you have no other
choice, you have no ther choice... but this may be why hidden tables are
suddenly showing up everywhere.
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
I'm a Lisp variable -- bind me!