Community mailing list archives

community@mail.odoo.com

Re: Broken DB

by
sengottuvel
- 08/12/2014 04:54:53
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