pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpx_resetlog Archiving doesn't work now
5+ messages / 3 participants
[nested] [flat]
* px_resetlog Archiving doesn't work now
@ 2017-06-21 09:30 EDELPINO <enrique_delpinowork@outlook.es>
0 siblings, 2 replies; 5+ messages in thread
From: EDELPINO @ 2017-06-21 09:30 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: px_resetlog Archiving doesn't work now
@ 2017-06-21 13:08 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: EDELPINO <enrique_delpinowork@outlook.es>
1 sibling, 1 reply; 5+ messages in thread
From: Albe Laurenz @ 2017-06-21 13:08 UTC (permalink / raw)
To: 'EDELPINO *EXTERN*' <enrique_delpinowork@outlook.es>; pgsql-admin
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: px_resetlog Archiving doesn't work now
@ 2017-06-21 13:14 EDELPINO <enrique_delpinowork@outlook.es>
parent: Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 0 replies; 5+ messages in thread
From: EDELPINO @ 2017-06-21 13:14 UTC (permalink / raw)
To: pgsql-admin
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-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: px_resetlog Archiving doesn't work now
@ 2017-06-21 14:28 Ashish Tiwari <tashish786@gmail.com>
parent: EDELPINO <enrique_delpinowork@outlook.es>
1 sibling, 1 reply; 5+ messages in thread
From: Ashish Tiwari @ 2017-06-21 14:28 UTC (permalink / raw)
To: EDELPINO <enrique_delpinowork@outlook.es>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: px_resetlog Archiving doesn't work now
@ 2017-06-22 06:00 EDELPINO <enrique_delpinowork@outlook.es>
parent: Ashish Tiwari <tashish786@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: EDELPINO @ 2017-06-22 06:00 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-06-22 06:00 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-06-21 09:30 px_resetlog Archiving doesn't work now EDELPINO <enrique_delpinowork@outlook.es>
2017-06-21 13:08 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2017-06-21 13:14 ` EDELPINO <enrique_delpinowork@outlook.es>
2017-06-21 14:28 ` Re: px_resetlog Archiving doesn't work now Ashish Tiwari <tashish786@gmail.com>
2017-06-22 06:00 ` Re: px_resetlog Archiving doesn't work now EDELPINO <enrique_delpinowork@outlook.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox