[GENERAL] Locale problem

2010-03-19 Thread S Arvind
Hello PG support, Recently i am facing locale problem in postgres 8.3. In my home machine i have 8.4 which have db schema as CREATE DATABASE impulse_travel WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'English_India.1252' LC_CTYPE = 'English_India.1252'

[GENERAL] Postgres physical directory structure meaning

2010-02-15 Thread S Arvind
I want to know about the meaning of various directory present in data folder. Mostly what will the 'base' folder contains? The reason of this is recently in the datafolder 'global' was deleted unknowingly which leads to entire DB crash in a second. We found a tool to get the data from the base

[GENERAL] Postgres Host

2010-01-26 Thread S Arvind
Hi Everyone, me and my friend wants a central db to do our development as we are in different location. Do any one know postgres service provider who is doing service which can help us? Arvind S

Re: [GENERAL] Postgres Host

2010-01-26 Thread S Arvind
most of the site provided there r not have postgres,.. i think its better to clear up the links in that page... As Craig told i am also interested in cloud.. have to check it up.. On Tue, Jan 26, 2010 at 6:51 PM, Thom Brown thombr...@gmail.com wrote: 2010/1/26 S Arvind arvindw...@gmail.com

Re: [GENERAL] Session based transaction!!

2009-12-26 Thread S Arvind
Web application have single DB only.. On Fri, Dec 25, 2009 at 7:03 PM, Bill Moran wmo...@potentialtech.comwrote: S Arvind arvindw...@gmail.com wrote: Hi Everyone, In a web application running in Tomcat and Postgres 8.3 as DB, i need to know whether my given task is feasible

[GENERAL] Session based transaction!!

2009-12-24 Thread S Arvind
Hi Everyone, In a web application running in Tomcat and Postgres 8.3 as DB, i need to know whether my given task is feasible or not. All the db operation which is done by that web application must be rollback at the end(session dies) and the DB data must be same as the starting

Re: [GENERAL] About logging

2009-09-25 Thread S Arvind
ok thanks Magnus from saving my time in googling -Arvind S Many of lifes failure are people who did not realize how close they were to success when they gave up. -Thomas Edison On Fri, Sep 25, 2009 at 12:39 AM, Magnus Hagander mag...@hagander.netwrote: On Thu, Sep 24, 2009 at 21:06,

[GENERAL] Data folder in differnet filesystem

2009-09-03 Thread S Arvind
I have 2 doubts related to Filsesytem and Postgres data folder 1.Currently in CentOS, our postgres data folder is in single filesystem. Is there any possibility to have a single data folder of single postgres in more then one file system. 2.I am having three big DB, is it possible to have a data

[GENERAL] Table replication

2009-07-09 Thread S Arvind
Hi Members, Is there any way to sync a single table across the DBs. We need a single table alone to be equal in all DBs in the single postgres. Presenly we are doing this with the help of Update, insert, delete trigger. Is there any other best way for that. Arvind S

[GENERAL] ResultSet is FORWARD_ONLY.

2009-06-16 Thread S Arvind
Hi everyone, Recently we have upgraded postgres driver jdbc4 for 8.3. After that while executing rst.first(), it raise the exception. The statment was created correctly as dbconnection..createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

[GENERAL] max execution time of query

2009-06-05 Thread S Arvind
Is there any possibility to mention max time a query can execute from DBCP side? our DB is Postgres and Container is tomcat 6. we dont want to give the timeout in postgres for all query but need to set in application side based on differnet needs? Is it possible? Is there anyother way to specify

Re: [GENERAL] max execution time of query

2009-06-05 Thread S Arvind
Thanks Chris kretschmer. But one small doubt in it,, What happens to update or insert query? - Arvind S * Many of lifes failure are people who did not realize how close they were to success when they gave up. -Thomas Edison * On Fri, Jun 5, 2009 at 11:59 AM, Chris dmag...@gmail.com wrote: S

[GENERAL] Upgrading from postgres 8.1 to 8.3

2009-05-07 Thread S Arvind
Our 600GB data was currently loaded in postgres 8.1 , we want to upgrade from postgres 8.1 to 8.3 . Can we able to point the data directly or should we have to do any porting work for transfering data from 8.1 to 8.3. Arvind S * Many of lifes failure are people who did not realize how close

[GENERAL] Reg: Logging log_min_duration_statement

2009-04-22 Thread S Arvind
I set log_min_duration_statement to 1 and restart the postgres. But when i check the tail to log i am getting all queries. please tell is it bug ? i have log_statement = all . is there any relation between this and min_duaration? Arvind S * Many of lifes failure are people who did not

[GENERAL] From 8.1 to 8.3

2009-04-22 Thread S Arvind
Our company wants to move from 8,1 to 8.3 latest. In irc they told me to check realse notes for issues while upgrading. But there are lots of release notesss. Can anyone tell some most noticable change or place-of-error while upgrading? Arvind S * Many of lifes failure are people who did not