Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
5078 Lượt xem

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.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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



Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 6 24
1622
1
thg 12 23
1333
1
thg 4 23
1516
1
thg 3 23
2356
0
thg 12 22
1931