In case corruption of SQL server, you can try any third party application to
repair sql database. when you search on the internet you will get lots of
option but i would suggest you "RecoveryFix for SQL Database" software
because this company offer the free trial version of software to get the
resu
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednesday, October 03, 2012 2:47 PM
> To: Igor Neyman
> Cc: Robert Sosinski; Merlin Moncure; pgsql-general@postgresql.org;
> Spike Grobstein
> Subject: Re: [GENERAL] Postgres will not start
Igor Neyman writes:
> I wonder if there is a column in pg catalog, that indicates the type of the
> index. I couldn't find one.
join relam to pg_am.oid
> So, I ran the following sql trying to find system indexes of gin or gist type:
There aren't any.
regards, tom lane
From: Robert Sosinski [mailto:rsosin...@ticketevolution.com]
Sent: Wednesday, October 03, 2012 10:54 AM
To: Merlin Moncure
Cc: pgsql-general@postgresql.org; Spike Grobstein
Subject: Re: Postgres will not start due to corrupt index
Hey Merlin,
Thanks. Starting postgres with -P was something tha
Robert Sosinski writes:
> We are running Postgres 9.1.3, and after stopping it by physically shutting
> off the machine, we rebooted and now get this error whenever we try to start
> it.
> 2012-10-02 13:54:30 PDT PANIC: GIN metapage disappeared
This looks like an issue that was fixed in 9.1.4
Hey Merlin,
Thanks. Starting postgres with -P was something that I did not try. Does
postgres have any GIN or GIST system indexes though?
I would love to try it out, but the database has already been restored. Will
definitely keep this in mind for the future though.
Thanks again for the hel
On Wed, Oct 3, 2012 at 9:33 AM, Robert Sosinski
wrote:
> We are running Postgres 9.1.3, and after stopping it by physically shutting
> off the machine, we rebooted and now get this error whenever we try to start
> it.
>
> 2012-10-02 13:54:30 PDT LOG: database system was interrupted; last known up
We are running Postgres 9.1.3, and after stopping it by physically shutting off
the machine, we rebooted and now get this error whenever we try to start it.
2012-10-02 13:54:30 PDT LOG: database system was interrupted; last known up at
2012-10-02 13:46:20 PDT
2012-10-02 13:54:30 PDT LOG: data
