Re: px_resetlog Archiving doesn't work now

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



EDELPINO wrote:
> My colleagues have delete the files from the pg_xlog
>   after that they did a px_resetlog and start de database and it's working
> now but when I set the archiving on in other path, this one doesn't work and
> the files from pg_xlog folder are not rotated.
> 
> Can anyone help in this?

Dump the database.

Stop the cluster and take a physical file system backup.
Keep this if it turns out that the dump was not good.

Remove the cluster and create a new one with "initdb".

Restore the dump into the new cluster.

Check if all data are there and look good.

Yours,
Laurenz Albe

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux