From: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Final pg_dumpall should happen in Single-User-Mode |
Date: | 2017-09-20 07:59:44 |
Message-ID: | 0256c1bd-c3c3-01c2-e23e-32b572eb101f@thomas-guettler.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Just for the records, I asked here the same question and got some replies:
https://dba.stackexchange.com/questions/186045/how-do-i-prevent-changes-to-my-database
Am 11.09.2017 um 15:25 schrieb Thomas Güttler:
> I did a stupid mistake. I run the final pg_dumpall without switching to single-user-mode first.
>
> With "final" I mean that the dump should be transferred to a different machine. After the dump
> the old machine was shut down forever.
>
> My mistake was that I stopped the services, but one process was still alive and this process
> inserted to the database after pg_dumpall has started.
>
> I guess I am not the first one who did this stupid mistake.
>
> What do you think? Wouldn't it be polite to add a note about this topic to the docs?
>
> Here are the docs for pg_dumpall: https://www.postgresql.org/docs/current/static/app-pg-dumpall.html
>
> How could the wording look like? I am not a native speaker ....
>
> Or do you have a better/different idea?
>
> Regards,
> Thomas Güttler
>
>
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines
From | Date | Subject | |
---|---|---|---|
Next Message | Nicklas Avén | 2017-09-20 08:02:40 | Re: Logcal replication in large scale |
Previous Message | Magnus Hagander | 2017-09-20 07:44:06 | Re: Logcal replication in large scale |