Timeline for Error while restoring Postgres DB Dump
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 8, 2017 at 4:37 | vote | accept | RBB | ||
| Apr 8, 2017 at 4:37 | |||||
| Oct 19, 2015 at 11:06 | history | tweeted | twitter.com/StackDBAs/status/656063779025850368 | ||
| Jul 8, 2015 at 15:38 | history | edited | Daniel Vérité |
added postgresql tag (not version-specific)
|
|
| Jul 8, 2015 at 13:14 | answer | added | Daniel Vérité | timeline score: 1 | |
| Jul 8, 2015 at 11:37 | comment | added | Craig Efrein | you can also use zcat my_db_dump.sql.gz | psql -d new_database -U my_username | |
| Jul 8, 2015 at 9:42 | comment | added | RBB | same command (restoration command) was working fine earlier. so, I hope no issue with command syntax. db size might be an issue? or any corrupted format data in tuple? | |
| Jul 8, 2015 at 9:33 | comment | added | user1822 |
Not really proficient in Linux shell, but shouldn't that be gunzip -c my_db_dump.sql.gz | psql ...?
|
|
| Jul 8, 2015 at 9:17 | history | edited | user1822 | CC BY-SA 3.0 |
added 16 characters in body
|
| Jul 8, 2015 at 9:07 | history | asked | RBB | CC BY-SA 3.0 |