[GENERAL] Locale problem

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

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 fold

Re: [GENERAL] Postgres Host

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 wrote: > 2010/1/26 S Arvind > > Hi Everyone, >> m

[GENERAL] Postgres Host

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] Session based transaction!!

Web application have single DB only.. On Fri, Dec 25, 2009 at 7:03 PM, Bill Moran wrote: > S Arvind 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!!

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 stage(of

Re: [GENERAL] About logging

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 wrote: > On Thu, Sep 24, 2009 at 21:06, wrote: > > Is it po

[GENERAL] Data folder in differnet filesystem

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

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.

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); org.postgresql.util.PSQLExcep

Re: [GENERAL] max execution time of query

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 wrote: &g

[GENERAL] max execution time of query

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 t

[GENERAL] Upgrading from postgres 8.1 to 8.3

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 the

[GENERAL] From 8.1 to 8.3

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 rea

[GENERAL] Reg: Logging log_min_duration_statement

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 realiz