Re: [ADMIN] Question about upgrading multiple clusters in v9.0.2

2011-03-16 Thread Vibhor Kumar
On Mar 16, 2011, at 4:37 AM, wrote: > When I start the second cluster and log into it with psql, it tells me that > the database is still v9.0.1 in parentheses. This means you have used PG9.0.1 Binary to start the database. Please update your Startup script to use 9.0.2 Binaries. Thanks

Re: [ADMIN] Off topic - Japanese PostgreSQL community

2011-03-16 Thread Lou Picciano
Mr. Masao, Our thoughts, prayers and best wishes must go out to the Japanese People at this time, not only for your great loss... But also with our fervent hopes that any larger tragedy will still be avoided. I cannot help but think of the small group of workers in those plants who may wel

Re: [ADMIN] accout password

2011-03-16 Thread raghu ram
On Sun, Mar 13, 2011 at 11:40 PM, Fredy Khan wrote: > Hello i have postgresql 9.0 and i am using windows xp. In command prompt i > go to my installation bin c:\postgresql\9.0\bin n run pgsql.exe. The problem > is that after that it asks for a password for my window account which is > 'fredy' . I

Re: [ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-16 Thread raghu ram
On Wed, Mar 16, 2011 at 1:28 PM, leslie samuel wrote: > Dear friends, > >I would like to know the particular table's insert,update and delete > record history. > I have done some googling and got to know about pg_stat_all_tables and > pg_stat_user_tables. These tables having this below field

Re: [ADMIN] Temporary table failed to drop after power failure

2011-03-16 Thread Gnanakumar
Any ideas/recommendation? -Original Message- From: Gnanakumar [mailto:gna...@zoniac.com] Sent: Monday, March 14, 2011 1:40 PM To: pgsql-admin@postgresql.org Subject: Temporary table failed to drop after power failure Hi, We're using PostgreSQL v8.2.3. Ours is a web-based application, l

[ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-16 Thread leslie samuel
Dear friends, I would like to know the particular table's insert,update and delete record history. I have done some googling and got to know about pg_stat_all_tables and pg_stat_user_tables. These tables having this below field , which has the tables insert,update and delete history, n_t