Discussion:
[ADMIN] px_resetlog Archiving doesn't work now
EDELPINO
2017-06-21 09:30:51 UTC
Permalink
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Albe Laurenz
2017-06-21 13:08:02 UTC
Permalink
Post by EDELPINO
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsq
EDELPINO
2017-06-21 13:14:54 UTC
Permalink
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.
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Ashish Tiwari
2017-06-21 14:28:43 UTC
Permalink
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" <***@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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
EDELPINO
2017-06-22 06:00:01 UTC
Permalink
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.
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...