Обсуждение: [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 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.