On 04/01/2016 10:44 AM, Brahim EL ALLIOUI wrote:
> Hi,
>
> Following a power failure the database is corrupt.
> I found that the file "pg_control" missing.
> I executed the command "pg_resetxlog" and he gave me the message:
What version of Postgres?
Exactly what was the command you gave?
In particular did you specify the data directory?
>
> run : touch global/pg_control
>
> Please, what should be done ?
If you have the space back up the existing data directory somewhere
before going any further.
Confirm that pg_control does not actually exist.
If pg_control does not exist, read the instructions for the -f option here:
http://www.postgresql.org/docs/9.5/static/app-pgresetxlog.html
Be aware of this:
"After running this command, it should be possible to start the server,
but bear in mind that the database might contain inconsistent data due
to partially-committed transactions. You should immediately dump your
data, run initdb, and reload. After reload, check for inconsistencies
and repair as needed."
>
> Thanks,
>
>
>
>
> *Brahim EL ALLIOUI*
> *General Manager*
> belallioui@e-acta.com <mailto:belallioui@e-acta.com>
> Skype : belallioui
> Tel : +212535749410
> Mobile : +212661940077
> www.e-acta.com <http://www.e-acta.com/>
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com