[HACKERS] Re: [GENERAL] re-instalation

2001-01-22 Thread Len Morgan
> 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? > You have apparently used pg_access at least once. It

Re: [HACKERS] Re: [GENERAL] re-instalation

2001-01-20 Thread Martin A. Marques
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 pga

Re: [HACKERS] Re: [GENERAL] re-instalation

2001-01-20 Thread Peter Eisentraut
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 > pgacce

Re: [GENERAL] re-instalation

2001-01-20 Thread Brett W. McCoy
On Sat, 20 Jan 2001, Tom Lane wrote: > > 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. > > AFAIK, there are *not* any location dependencies in a standard PG >

Re: [GENERAL] re-instalation

2001-01-20 Thread Tom Lane
"Brett W. McCoy" <[EMAIL PROTECTED]> writes: > On Sat, 20 Jan 2001, Martin A. Marques wrote: >> 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

Re: [GENERAL] re-instalation

2001-01-20 Thread Brett W. McCoy
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 t

[HACKERS] Re: [GENERAL] re-instalation

2001-01-20 Thread Martin A. Marques
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/ dir

Re: [GENERAL] re-instalation

2001-01-19 Thread Brett W. McCoy
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 hav

Re: [GENERAL] re-instalation

2001-01-19 Thread Martin A. Marques
El Vie 19 Ene 2001 17:36, Len Morgan escribió: > > 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 ar

[GENERAL] re-instalation

2001-01-19 Thread Martin A. Marques
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 t