[GENERAL] pgrestore command

Hi Is there any chances for any performance issues with pg_restore when changing the servers, like openvz, xen, etc.? Will the server difference make the time of restore longer in this case? ThanksArun

[GENERAL] Wrap around id failure and after effects

Hi all, We had a wraparound failure in the db and most of the tables and data were missing. So we have done a full vacuum in db and after that the tables reappeared but now the problem is, all the tables have duplicate when listing tables with /dt. And also after the vacuum we recievied the foll

[GENERAL] Old record migration to another table made the db slower

Hi all, I have moved a lot of old records from one table say original_data_table to another table say old_data_table which is newly created for the old records. There were around 15 milliion old records to move. After this migration I have done standard vacuum on new old_data_table as well as o

[GENERAL] Delete duplicate records with same fields

Hi all, Is there any way to delete duplicate rows in psql with no unique fields? I have a set of old records with their duplicates in my db and they are all having the same fields. How can I delete duplicates? Thanks in Advance,Arun

[GENERAL] User defined cast creation

Hi friends, When I try to create a function which is used in user defined type cast I get the following error, CREATE FUNCTION pg_catalog.text1(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));'; ERROR: permission denied for schema pg_catalog I am not trying

[GENERAL] missing FROM-clause in version 9.2

Hi All, Getting an error in version 9.2 "ERROR: missing FROM-clause entry for table" for some queries. Server parameter "add_missing_from" is removed from version 9 as per release notes, so is there any workaround for fixing this issue? or is the better way is modifying all these queries ? T

[GENERAL] Strict mode in postgresql??

Hi, Is there any settings in postgresql version 9.2 similar to mysql strict mode? I need to get rid of some type casting errors in the upgrading process from version 7.4 to 9.2, if this mode is not available I have to modify queries in the system to make it work... Thanks in Advance, Arun

[GENERAL] Type cast errors in version 9.2 while upgrade

Hi All, We are doing a postgresql upgrade from version 7.4.30 to 9.2. While testing the queries in newer version, the following error is obtained for some of the queries which were working fine in older version. "ERROR: operator does not exist: character varying = integer.HINT: No operator

Re: [GENERAL] Upgrading postgresql from version 7.4.3

Hi, And the way to deal with this? Any ideas on that? Whether changing encoding to utf-8 in dump work? Regards~ Arun

Re: [GENERAL] Upgrading postgresql from version 7.4.3

Since there was some issue with hotmail I couldn't reply earlier. Encoding in version 7.4 was SQL_ASCII. What's the best way to deal with this? I hope changing the encoding to UTF-8 while taking dump will work. Surely I will have an eye on release notes in order to deal with the typecasting is

[GENERAL] Re: [GENERAL] Upgrading postgresql from version 7.4.3‏

Since there was some issue with hotmail I couldn't reply earlier. Encoding in version 7.4 was SQL_ASCII. What's the best way to deal with this? I hope changing the encoding to UTF-8 while taking dump will work. Surely I will have an eye on release notes in order to deal with the t

[GENERAL] Upgrading postgresql from version 7.4.3

Hi, How can I upgrade to latest postgresql version 9.2 from my current version 7.4.3? How complicated this will be as the db contains large amount of data? I have installed the latest version 9.2 in new server and while restoring the dump from old version, data in some of the large tables are n