Final pg_dumpall should happen in Single-User-Mode

From: Thomas Güttler <guettliml(at)thomas-guettler(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Final pg_dumpall should happen in Single-User-Mode
Date: 2017-09-11 13:25:26
Message-ID: fed030c4-2181-bff2-8fa3-95e1c11e476f@thomas-guettler.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2017-09-11 13:51:38 Re: pg_ident mapping Kerberos Usernames
Previous Message Craig Ringer 2017-09-11 01:55:29 Re: BDR, limit number of groups in a cluster