I am getting the following error. I can't backup and cant't restore any database. This will be a huge issue if the database crashes:
Database restore error: Postgres subprocess ('/usr/bin/pg_restore', u'--dbname=back', '--no-owner', '/tmp/tmpKY434e') error 1
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmp40EUve/dump.sql', u'Live_GasandOil') error 1
Please help this is very critical
Well Thanks for the help. But the issue was that there was an extra table in the database which was not supposed to be there. on drooping that table i got that fixed.
Hmm interesting, I haven't heard that causing this issue before. I've converted your comment as an answer and accepted it so that it might help others in the future.
How can i find the extra table which was not supposed to be in DB?
well done,
how did your perform it, please ??
Actually My server was on open IP with out any firewall, security and protection. Therefore my odoo server got hacked. The hacker acessed my database and created a new table to make his message visible. I change the ips, bring the server under firefall and after applying proper securities I deleted that table created by the hacker.
After deletion the backup schedular started creating correct backups.
Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!
Registrera dig| Relaterade inlägg | Svar | Vyer | Verksamhet | |
|---|---|---|---|---|
|
2
juli 24
|
12449 | ||
|
1
apr. 25
|
3748 | ||
|
1
mars 15
|
5766 | ||
|
3
sep. 25
|
12217 | ||
|
1
nov. 23
|
4349 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Please check some other errors in the server logs and post it here.
For alternate way, you can backup of your database from postgres / pgadmin to be safe side until this issue gets resolved.
Hi Mian,
You get this because there is no owner set. Make sure you have a postgresql user and that this user is set as owner of this database. You'll then be able to backup. You can do it by switching to the postgresql console and executing the following query:
Regards,
Yenthe
what do you mean by extra table plz ,is it a customized table or what?