Hi, Sometimes when I try to recreate a database using pg_dump I get the following error :
-------------------------------------------- ERROR: copy: line 747, Invalid UNICODE character sequence found (0xd021) lost synchronization with server, resetting connection psql:dbcurrent.sql:11355: ERROR: copy: line 747, Invalid UNICODE character sequence found (0xd021) psql:dbcurrent.sql:11355: lost synchronization with server, resetting connection -------------------------------------------- Why am I getting this error ? What does this error indicate ? What I will have to do so that everytime I do -------------------------------------------- pg_dump <databasename> > dump.sql psql <database> < dump.sql -------------------------------------------- it should work without errors ? Is pg_dump reliable for backup ? Because if I get the above type of error during restore than I am doomed. Thanks for any advice. Peace -- Rajesh : ####[ GNU/Linux One Stanza Tip (LOST) ]####################### Sub : Lesser known commands (tac) LOST #165 Everybody has heard of cat, to concatanate files and print to standard output. But have you heard of "tac" ? This reads file reverse. Try 'tac somefile.txt' and have a look ... or better still 'tac somesound.au > /dev/audio' ... Enjoy ! ####[bish (at) nde.vsnl.net.in]############################### : ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The best thread debugger on the planet. Designed with thread debugging features you've never dreamed of, try TotalView 6 free at www.etnus.com. _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
