[GENERAL] Problem with timestamp

Hi, We have our application which uses postgres 7.1.3 version in that we use a time functions like now(),timestamp. etc mostly timestamp without timezone.We don't need the timezone in that variable so we ignore it using timestamp without timezone. The same is not working with high

[GENERAL] Postgres Replication

Hi , Is there any way to do replication in postgres.. Please give me any idea to do replication... Regards J Mageshwaran ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or

[GENERAL] Postgres Database size

Hi all, how to find the size of a particular database in postgres... please do reply Regards J Mageshwaran DBA ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to

[GENERAL] UPGRADATION TO 8.1

Hi, In our company there are many postgres servers in 7.X version,we are in the process of upgrading to 8.1 version, can anyone tell me the method to do this upgradation. Regards J Mageshwara DBA ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprie

[GENERAL] Incremental backups

hi everyone, please any one give any methods to do incremental backups. it is urgent .. help me Regards J Mageshwaran ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or

[GENERAL] Postgresql Help

Hi , I am new to postgresql, I have been assigned a task of upgrading postgresql to higher version. In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql, can you please tell me which is the stable and suitable version in 8.x version. Please reply me, Regards J Mageshwaran

[GENERAL] Major differences between 7.1.1 and 7.4.x

Hi , can any one tell me the major difference between 7.1.1 and 7.4.x version of postgresql, also please tell me what are things to considered when upgrading postgresql from 7.1.1 to 7.4.x. Please reply me.. Thanks & Regards J Mageshwaran ** DISCLAIMER ** Informa

[GENERAL] Regarding WAL

Hi , I want to do replication using WAL , please tell the methods by which log shipping is done ie moving the wal files to slaves and executing it. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only

[GENERAL] Kill a Long Running Query

Hi , Any body tell me how to kill a long running query in postgresql, is there any statement to kill a query, and also tell me how to log slow queries to a log file. Regards J Mageshwaran ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to

[GENERAL] Regarding autocomplete

Hi all, Can anybody tell me how to enable autocomplete and history in psql. Thanks in advance. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is address