Re: PostgreSQL (file based) database restore - Mailing list pgsql-general

From Leonel Nunez
Subject Re: PostgreSQL (file based) database restore
Date
Msg-id 4437C8A1.5020009@enelserver.com
Whole thread Raw
In response to PostgreSQL (file based) database restore  ("Bit Byter" <takashi_949@hotmail.com>)
List 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


pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: Re: postmaster going down own its on
Next
From: User Roman
Date:
Subject: Re: pgAdmin3 question