[GENERAL] pg_dump: dumpBlobs(): could not open large object: ERROR: large object 27729547 does not exist

2014-01-24 Thread Manoj Agarwal
tion goes wrong/bust? Please suggest. Kind Regards, Manoj Agarwal

[GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

2012-06-06 Thread Manoj Agarwal
ssues with them. Is there a way to restore the database from SQL_ASCII to UTF-8? Is there a way to restore the database as SQL_ASCII and then convert the Encoding to UTF-8? What is the consistency level? Or are there chances of getting garbage? Kind Regards, Manoj Agarwal

Re: [GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

2012-06-07 Thread Manoj Agarwal
Hi, The encoding that is used by the clients that supplied data to the database is ISO-8859-1. Kind Regards, Manoj Agarwal -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Wednesday, June 06, 2012 6:43 PM To: Manoj Agarwal Cc: pgsql-general@postgresql.org

Re: [GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

2012-06-08 Thread Manoj Agarwal
Perl module. After installing the module, I used the following command to restore SQL_ASCII database to UTF-8: pg_restore -O db_dump_sql_ascii | fix_latin | psql -d db_utf The conversion was done successfully without any errors. The database was restored as UTF-8. Kind Regards, Manoj Agarwal

[GENERAL] File system level backup

2012-07-26 Thread Manoj Agarwal
x27;pg_restore' commands. Any help will be highly appreciated. Kind Regards, Manoj Agarwal

Re: [GENERAL] File system level backup

2012-08-08 Thread Manoj Agarwal
abase in a cluster, but as a whole, is it possible? Kind Regards, Manoj Agarwal -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Thursday, August 02, 2012 2:18 AM To: Manoj Agarwal; pgsql-general@postgresql.org Subject: Re: [GENERAL] File system le