Re: PostgreSQL (file based) database restore

From: Leonel Nunez <lnunez(at)enelserver(dot)com>
To: Bit Byter <takashi_949(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL (file based) database restore
Date: 2006-04-08 14:28:49
Message-ID: 4437C8A1.5020009@enelserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bit Byter wrote:
> I just did a file based database backup (stopped postmaster and
> zipped/copied all files under /usr/local/pgsql/data/* to a differnt
> location)
>
> How can I 'restore' the database and start using it?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>

stop the "other" postmaster

then Unzip it

then start the postmaster with the PGDATA pointed to the location of
your files

leonel

In response to

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-04-08 14:32:04 Re: postmaster going down own its on
Previous Message Gavin Hamill 2006-04-08 14:10:28 Load testing across 2 machines