Re: File System Restore

From: "Scot L(dot) Harris" <webid(at)cfl(dot)rr(dot)com>
To: Carter Harrison <gtg459b(at)mail(dot)gatech(dot)edu>
Cc: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: File System Restore
Date: 2004-06-19 20:56:09
Message-ID: 1087678569.28385.42.camel@lathe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 2004-06-19 at 16:34, Carter Harrison wrote:
> I'm running the latest version of PostgreSQL. I backed up one of my
> databases following the instructions in the postgresql documentation.
> This means that I did shut down postmaster and I tarred the data
> directory just like it says to. Now, I'd like to restore the file
> system. I started by just copying the data directory back, but that
> hasn't worked for me. Can somebody please give me some detailed
> directions on restoring the file system correctly. I think the only
> thing that is different about this new install of postgresql is that it
> is owned by a different user than before. Thanks.
>
> -Carter

I just recently upgraded from 7.2.4 to 7.4.2 postgresql. What I did was
a pg_dumpall to save my databases. Then after the upgrade I did a
pg_restore using the saved dump file. Worked perfectly for me.

After I installed the new version of postgresql I did a initdb to setup
the new database cluster then a started postgresql. After that I ran a
psql -d template1 -f databasebackupfile. The databasebackupfile was
created from the pg_dumpall. This recreated all my tables and loaded
the data.

Very easy and clean.

Not sure you can just copy the file systems around like you describe.

--
Scot L. Harris
webid(at)cfl(dot)rr(dot)com

After an instrument has been assembled, extra components will be found
on the bench.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2004-06-19 20:56:44 Re: PostgreSQL 7.4.3 Now Available ...
Previous Message Carter Harrison 2004-06-19 20:34:42 File System Restore