Thread: [ADMIN] px_resetlog Archiving doesn't work now
Hi for anybody can help me. 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? Thanks in advance. -- View this message in context: http://www.postgresql-archive.org/px-resetlog-Archiving-doesn-t-work-now-tp5967811.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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
Hi Albe, Thank you very much for your quick response. The case is that we not have a cluster, we have an isolate postgres instance. I think it would be a risk to do a initdb do you agree? Greetings Enrique del Pino -- View this message in context: http://www.postgresql-archive.org/px-resetlog-Archiving-doesn-t-work-now-tp5967811p5967846.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Hi EDELPINO,
If your Pgdata is safe the restore the DB using File system backup in fresh Postgresql instance and enable the Archive .
Or you take the db backup using pg_dump and restore on another fresh Postgresql installation .it is more suitable since you have already executed the pg_resetxlog.
Thanks.
On Jun 21, 2017 6:20 PM, "EDELPINO" <enrique_delpinowork@outlook.es> wrote:
Hi for anybody can help me.
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?
Thanks in advance.
--
View this message in context: http://www.postgresql-archive.org/px-resetlog-Archiving- doesn-t-work-now-tp5967811. html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi Ashish, Thank you very much for your response. I appreciate it. Cheers -- View this message in context: http://www.postgresql-archive.org/px-resetlog-Archiving-doesn-t-work-now-tp5967811p5968053.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.