Community mailing list archives

community@mail.odoo.com

Re: Broken DB

by
Koketso Mabuse, Koketso Mabuse
- 08/16/2014 05:07:06
Hi there

I think my description might have not been correct.

I backed up my DB then restored it. After restoration, I can see it on my list and after selection. I get a blank screen no place to login so cant go on further.

Regards

On 13/08/2014 11:47, Kingsley wrote:
<blockquote cite="mid:53EB33A2.4040205@yahoo.com" type="cite"> I tried the backup with what you have described, but it says "Permission denied"
On 12/08/14 09:59, Sengottuvel wrote:
<blockquote cite="mid:CAHtjdTYRddN=3efiA7w=qAaQCJrKbLT2r=8KHYdHQM0WjeVQGQ@mail.gmail.com" type="cite">
Hi,

If you are using linux platform the following way you can take db dump and restore,

Dump:

sudo su postgres

pg_dump databasename > back_db.sql


Restore :

createdb databasename

psql databasename < back_db.sql




On Mon, Aug 11, 2014 at 7:54 PM, Carlos Enrique Contreras Vara <carlosecv@realsystems.com.mx> wrote:
Maybe you created the backup vía postgresql, if that is the case you must change the owner of database and tables to make openerp able to use it, I hope these link help you.

http://www.realstec.com/como-cambiar-el-dueno-a-todas-las-tablas-de-una-base-de-datos-postgresql/

Please tell us:

Postgresql versión
How you make the backup
Hoy you reactores the backup

Regards


El Sunday, August 10, 2014, Koketso Mabuse <koketsom@tluka.co.za> escribió:

Hi there.

Don't mean to be a bother. I have never fixed this before. Any step by step methods on repair?



Carlos Enrique Contreras Vara <carlosecv@realsystems.com.mx> wrote:

The pender of the database and tables

El Saturday, August 9, 2014, Koketso Mabuse <koketsom@tluka.co.za> escribió:

Hi all.

I broke db. This is how: I created a backup. Changed the name and restored it then can't open it.

Any thoughts?

Koketso Mabuse: South Africa. Soweto

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--
Enviado con Gmail Mobile

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--
Enviado con Gmail Mobile

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
with regards,
T.Sengottuvel

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


--
<img src="cid:part21.04020902.04030700@tluka.co.za" border="0">