Re: Recovered data directory - Mailing list pgsql-admin

From Julien Rouhaud
Subject Re: Recovered data directory
Date
Msg-id 20210418125401.licfzimvoor25gdn@nol
Whole thread Raw
In response to Recovered data directory  (Yambu <hyambu@gmail.com>)
List pgsql-admin
On Sun, Apr 18, 2021 at 02:44:03PM +0200, Yambu wrote:
> Hello
> 
> I lost data when my server crashed, so i have rebuilt a new server and have
> recovered the directory /var/lib/pgsql/10/data  is there anything i need to
> do to start a new postgres instance after having copied the old recovered
> /var/lib/pgsql/10/data to new data directory with the same path

You also need all tablespaces directory if you had any, and possibly the pg_wal
directory if it was a symlink.

Note that if you get any error when trying to start the server it would
actually be useful to mention them.



pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: Recovered data directory
Next
From: Alvaro Herrera
Date:
Subject: Re: Reordering the fields in a table