[ADMIN] Urgent --- Installation error on UltraSPARC-IIi processor version Postgres 7.3.2

Hi All, I have installed postgres 7.3.2 on Linux Redhat 9 EE on intel processors. I am copying (tar) the installed directories and then I am installing the same on different flavors of linux like turbolinux ,Chinasoft on intel processors etc. The installation went just fine. No compiling of p

Re: [ADMIN] determining when a database was created

Hi All, Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. thanks in advance som -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 7:17 AM To: Ian Lipsky Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] determining when a dat

[ADMIN] Need a Reporting Tool for postgres 7.3.2

,   Somasekhar Bangalore.

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

very best. Somasekhar -Original Message- From: Jaime Casanova [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [GENERAL][ADMIN][HACKERS]data fragmentation Hi, i have a theorical question. i was thought

Re: [ADMIN] Field Size

There is no harm in having a field size of 1000 character provided u use the proper datatype. Don’t user char(1000). Try using varchar(1000).   For character data it is recommended to use the VARCHAR type, since PostgreSQL manages it very well.  On the contrary, if you use the CHAR dataty

[ADMIN] Need Urgent Help in case of postgres Database Crash.

Steps needed to recover the data in case of database crash or hardware crash. I would appreciate if some could help me out on these issues. Thanks in advance Somasekhar Bangalore Principle Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham

[ADMIN] Is there a concept of Redo log files in postgres.?

re data incase of media failure.? thanks in advance Somasekhar Bangalore ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[ADMIN] how to take a single table data backup in postgres 7.2.3 database.?

Hi , I would appreciate if some one could help me how to take a single table back up in postgres 7.2.3. Thanks in Advance. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052

[ADMIN] how to find multi-byte is enabled or not for 7.2.3

Hi All, I have 7.2.3 postgres database running. how to find that the multi-byte is enabled or not for my database. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India

Re: [ADMIN] Report Generator Proposal

Sounds good ...it will save lot of emails floating around and time.. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: [EMAIL

[ADMIN] Blob Data type in postgres ?

Hi ,   I would like to create a table with blob as a datatype.I found that postgres doesn't have a datatype called BLOB. Is there any equivalent data type for this or a short cut ?   I appreciate if some one can help me in this regard.   Thank you all, Regards, Somasekhar Bang

Re: [ADMIN] postgresql and replication

x27;t locate object method "connect" via package "DBI" (perhaps you forgot to load "DBI"?) at ./ers_setup line 73. I would be very thankful if any one can give the solution. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies P

Re: [ADMIN] postgresql and replication

] message = invalid LOC header (bad signature) BUILD FAILED /home/postgres/erserver/erserver_v1.2/java/build.xml:146: Compile failed, messages should have been provided. I appreciate if some one can help me how to install & configure erserver. Regards, Somasekhar Bangalore Principal Soft

[ADMIN] Need Help on query tuning

' and b.record_flag = '01'and c.rol_guid = b.rol_guid and c.OBJ_TYPE =  b.OBJ_TYPEand c.record_flag ='01'and d.rgt_guid = c.rgt_guidand d.record_flag = '01';   I appreciate if some one can direct me how to enhance the performance. Regards, Somasekhar Bangalo

[ADMIN] Urgent help need on French language.

x27; comes along the data.I really don't know what setting need to be done on the database front. I would appreciate if some one can throw some light on how to solve this problem? Thanks in advance. Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd

[ADMIN] Need Help on Japanese language

Hi, I have a postgres database running on a english linux box.what settings need to be done , so that i can insert japanese characters into the database. thanks in advance. Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14