Re: Recovered data directory

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Recovered data directory
Date: 2021-04-18 12:54:01
Message-ID: 20210418125401.licfzimvoor25gdn@nol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2021-04-18 17:19:27 Re: Reordering the fields in a table
Previous Message Yambu 2021-04-18 12:44:03 Recovered data directory