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
>