On 08/19/2011 02:37 PM, Mik Rose wrote:
Its a postgresdb. Is there a similar method for postgres?
Mik Rose | Director, IT - Support Services | *PowerSoft Development Corp*
1 (250) 642-0295 x23 http://www.power-soft.com <http://www.power-soft.com/> Live
Support <https://secure.logmeinrescue.com/Customer/Download.aspx?EntryID=15095831>
This e-mail may be privileged and/or confidential, and the sender does not waive
any related rights and obligations. Any distribution, use or copying of this
e-mail or the information
it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or
otherwise) immediately.
On 2011-08-19, at 11:36 AM, Carlos Andrés Gallego Arboleda wrote:
if you dont stop the mysql during the data copy, maybe the DB is corrupted.
use this command.
mysqlcheck --repair -p otrs
Regards.
2011/8/19 Mik Rose <[email protected] <mailto:[email protected]>>
Happy Friday people!
I was wondering if anyone had any suggestions on how to resolve this
issue... I am moving otrs to another server and during the backup process I am
running into this error
pg_dump: dumping contents of table article_attachment
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: unexpected chunk number 7
(expected 6) for toast value 77281 in pg_toast_57366
pg_dump: The command was: COPY public.article_attachment (id, article_id,
filename, content_size, content_type, content, create_time, create_by,
change_time, change_by, content_id, content_alternative) TO stdout;
pg_dump: *** aborted because of error
I have tried a vacuum and reindex with no successes.
You would be better off posting this to the postgresql-users list.
--
Stephen Clark
*NetWolves*
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: [email protected]
http://www.netwolves.com
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
