跳至內容
選單
此問題已被標幟
1 回覆
7751 瀏覽次數

Hi,

How to restore database using .dump file in odoo V7 in windows

I have tried using   psql testdb < test.dump and pg_restore -U user_name -d database_name -1 test.dump

and the following error occurs psql: FATAL:  password authentication failed for user "Administrator"

thanks in advance

頭像
捨棄
最佳答案

do dump as a postgres user.

>> sudo su postgres

>> psql testdb < test.dump

>> pg_restore -U user_name -d database_name -1 test.dump


頭像
捨棄
作者

Hi Hilar,

This works well for ubuntu but not in windows.

okay, go to pg_hba.conf and change the postgres user permissions.

相關帖文 回覆 瀏覽次數 活動
0
2月 21
6434
1
4月 17
18370
2
6月 16
2722
0
3月 15
4544
1
3月 15
15026