Thread

1. opening old database

   Will Smith <wsmith@powerup.com.au> — 2000-05-20T06:04:35Z

   Hi,
   I have a problem, I was experimenting with postgresql-6.5.2 under RH6.1
   linux, made the changover to RH6.2 - at the last minute remembered the
   database I had been using and simply saved it to a partition that wasn't
   being overwritten. My problem now is that I can't access it, it all
   seems to be there and postgresql seems to work ok but I can't see how to
   either import the database or open it. I have trawled through
   documentation but the only way I can find is 'import table' in pgaccess,
   which refuses to do anything with the table - says it doesn't exist.
   Have tried many different ways to hack it up also but no joy.
   Can anyone tell me how to import a database.
   
   Will Smith
   
   
   

2. Re: opening old database

   Jacques Williams <jacques@panix.com> — 2000-05-20T16:44:50Z

   Try this:
   
   Start postgresql with the PGDATA environment variable pointing to the old database -- "postmaster -D /mount/point/of/old/database "
   
   then do "pg_dumpall > db.out"
   
   Kill the postmaster and restart it pointing to the new database, and do "psql < db.out".
   
   HTH.
   
   Jacques Williams
   
   On Sat, May 20, 2000 at 04:04:35PM +1000, Will Smith wrote:
   > Hi,
   > I have a problem, I was experimenting with postgresql-6.5.2 under RH6.1
   > linux, made the changover to RH6.2 - at the last minute remembered the
   > database I had been using and simply saved it to a partition that wasn't
   > being overwritten. My problem now is that I can't access it, it all
   > seems to be there and postgresql seems to work ok but I can't see how to
   > either import the database or open it. I have trawled through
   > documentation but the only way I can find is 'import table' in pgaccess,
   > which refuses to do anything with the table - says it doesn't exist.
   > Have tried many different ways to hack it up also but no joy.
   > Can anyone tell me how to import a database.
   > 
   > Will Smith
   > 
   
   

3. Re: opening old database

   D. Duccini <duccini@backpack.com> — 2000-05-20T18:16:22Z

   This brings up a excellent question, can you have your stores on more one
   directory / device / mount point?
   
   not that its too critical with the big drives that are available these
   days, but was wondering if some performance could be gained by having
   indexes managed on one drive and the store managed on another?
   
   -D. Duccini
   
   On Sat, 20 May 2000, Jacques Williams wrote:
   
   > Try this:
   > 
   > Start postgresql with the PGDATA environment variable pointing to the old database -- "postmaster -D /mount/point/of/old/database "
   > 
   > then do "pg_dumpall > db.out"
   > 
   > Kill the postmaster and restart it pointing to the new database, and do "psql < db.out".
   > 
   > HTH.
   > 
   > Jacques Williams
   > 
   > On Sat, May 20, 2000 at 04:04:35PM +1000, Will Smith wrote:
   > > Hi,
   > > I have a problem, I was experimenting with postgresql-6.5.2 under RH6.1
   > > linux, made the changover to RH6.2 - at the last minute remembered the
   > > database I had been using and simply saved it to a partition that wasn't
   > > being overwritten. My problem now is that I can't access it, it all
   > > seems to be there and postgresql seems to work ok but I can't see how to
   > > either import the database or open it. I have trawled through
   > > documentation but the only way I can find is 'import table' in pgaccess,
   > > which refuses to do anything with the table - says it doesn't exist.
   > > Have tried many different ways to hack it up also but no joy.
   > > Can anyone tell me how to import a database.
   > > 
   > > Will Smith
   > > 
   > 
   
   
   -----------------------------------------------------------------------------
   david@backpack.com            BackPack Software, Inc.        www.backpack.com
   +1 651.645.7550 voice       "Life is an Adventure.    
   +1 651.645.9798 fax            Don't forget your BackPack!"   
   -----------------------------------------------------------------------------