跳至内容
菜单
此问题已终结
1 回复
5077 查看

Hello Greetings,

I got error as "Database restore error: Too much data for base64 line" when i try to restore my database. Its around 1.9 GB in size.

Please assist me to overcome this problem. Else any alternative way to restore the database through back-end.

Thank you.

形象
丢弃
最佳答案

don't use database manager page for this. use pg tools with correct user credentials and you won't have any problem.

psql -h localhost -U username -d database -W < /path/to/dump.sql
password: ****


if you have any permission problems after importing the database from command line: you can fix them using the following commands on tables, views, sequences. good luck.



-- alter permissions [optional]

REASSIGN OWNED BY old_user TO newuser;


ALTER DATABASE old_user OWNER TO newuser;


Tables [ownership]

for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" dbname` ; do psql -c "alter table $tbl owner to username" dbname ; done


Sequences [ownership]

for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" dbname` ; do psql -c "alter table $tbl owner to username" dbname ; done


View [ownership]

for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" dbname` ; do psql -c "alter table $tbl owner to username" dbname ; done



形象
丢弃
相关帖文 回复 查看 活动
2
6月 24
1622
1
12月 23
1333
1
4月 23
1516
1
3月 23
2356
0
12月 22
1931