Thread: Postgres Recovery

Postgres Recovery

From
Ramesh T
Date:
Hi All,
          What i need to know for postgres recovery..?let me know in detail.

Re: Postgres Recovery

From
Michael Paquier
Date:
On Mon, Jul 20, 2015 at 7:00 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:
> Hi All,
>           What i need to know for postgres recovery..?let me know in detail.

Documentation is always a good start:
http://www.postgresql.org/docs/devel/static/backup.html
--
Michael


Re: Postgres Recovery

From
Ramesh T
Date:
archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'  # Unix
restore_command = 'cp /mnt/server/archivedir/%f %p'
 above two commands and checkpoint settings .as i read doc we need to change postgres.conf.But other way i want try it from server commmand mean from putty is it possible..?
i want commands to execute the set to the server without open the postgres.conf...?

On Mon, Jul 20, 2015 at 6:23 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Mon, Jul 20, 2015 at 7:00 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:
> Hi All,
>           What i need to know for postgres recovery..?let me know in detail.

Documentation is always a good start:
http://www.postgresql.org/docs/devel/static/backup.html
--
Michael