Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-06 Thread Nikhil G Daddikar
Folks, This is bad news as I run Ubuntu 12.04 LTS. However, my ubuntu 12.04 LTS boxes have been updated to "3.5.0-32-generic" (official update). Any idea whether the Postgresql has problems with this kernel? I'd like to follow the "official" LTS updates because I am not sure what other surpri

[GENERAL] How to check if Postgresql files are OK

2013-05-27 Thread Nikhil G Daddikar
Folks, I was using PostgreSQL 8.x in development environment when one day I started getting all kinds of low-level errors while running queries and eventually had to reinstall. Maybe it was salvageable but since it was a test database anyway it didn't matter. We use PostgreSQL 9 on our produ

[GENERAL] How to know the exact time to which the database was recovered

2013-05-27 Thread Nikhil G Daddikar
Hello, We use the basebackup + WAL files strategy to backup our database i.e. take a basebackup every day and copy WAL files to a remote server every 15 minutes. In case of a disaster on the master, we'd recover the database on the slave. If this happens, I would like to tell the customer the

[GENERAL] Error while vacuuming table

2011-12-07 Thread Nikhil G. Daddikar
Hello, When I run vacuum, I get: vacuumdb: vacuuming of database "pm50" failed: ERROR: catalog is missing 1 attribute(s) for relid 4210163 How do I go about debugging this? I have googled around and tried a few things to no avail. Any pointers will be appreciated. Thanks. Nikhil -- Sent

Re: [GENERAL] PostgreSQL Performance issue

2010-04-27 Thread Nikhil G. Daddikar
Most likely you are inserting one per transaction. Set autocommit to false and commit only after all the inserts are done. -n. On 27-04-2010 13:41, a.bhattacha...@sungard.com wrote: Dear All Experts, I am using in PostgreSQL 8.3.5 database on windows 64 bit OS. However, I have a batch pr

[GENERAL] Postgresql on EC2/EBS in production?

2010-04-25 Thread Nikhil G. Daddikar
Folks, I was wondering if any of you are using (or tried to use) PG+EC2/EBS on a production system. Are any best-practices. Googling didn't help much. A few articles I came across scared me a bit. Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] "1-Click" installer problems

2010-04-06 Thread Nikhil G. Daddikar
On 07-04-2010 10:04, Craig Ringer wrote: Nikhil G. Daddikar wrote: I have tried earlier versions of 8.4 installer on Vista x32 and they'd failed too. But let me try the latest installer again. I will let you know. Any luck with the call? Or are we still at "it doesn

Re: [GENERAL] "1-Click" installer problems

2010-04-05 Thread Nikhil G. Daddikar
I have tried earlier versions of 8.4 installer on Vista x32 and they'd failed too. But let me try the latest installer again. I will let you know. -n. On 06-04-2010 10:09, Craig Ringer wrote: Nikhil G. Daddikar wrote: Hi Craig, I have a call with EDB folks in an hour. I will

Re: [GENERAL] "1-Click" installer problems

2010-04-05 Thread Nikhil G. Daddikar
Hi Craig, I have a call with EDB folks in an hour. I will post when I have something concrete. Meanwhile, if you need anything specific about the system, please let me know. I have Vista Business x64 with Microsoft Security Essentials and UAC turned ON. I have tried (at least) the following:

Re: [GENERAL] "1-Click" installer problems

2010-04-01 Thread Nikhil G. Daddikar
Peter, Are you sure about that? Have you actually tested that? Even if you find that the old 8.3 pginstaller works where the EDB installer failed, that doesn't actually demonstrate that pginstaller is inherently superior to the EDB installer. It is likely due to a fluke. Perhaps it is down to so

Re: [GENERAL] "1-Click" installer problems

2010-04-01 Thread Nikhil G. Daddikar
Folks, I received a call from EnterpriseDB trying to understand what the problem is. We are scheduled to meet on Monday. I will post the findings as soon as I have something concrete. Thank you all. -n. Unless you are prepared to help us understand exactly what is unique about your systems

Re: [GENERAL] "1-Click" installer problems

2010-04-01 Thread Nikhil G. Daddikar
Maybe I'm missing something, but I see 5 responses from 2 of our engineers over the last 2 days on that thread, all asking valid questions and trying to figure out why this is failing for you, when it does not for the vast majority of other users. I appreciate that you do not want to do a manual

Re: [GENERAL] "1-Click" installer problems

2010-04-01 Thread Nikhil G. Daddikar
On 01-04-2010 12:39, Thomas Kellerer wrote: Nikhil G. Daddikar, 01.04.2010 08:04: In about 30 seconds I found the following unanswered threads relating to installation on Windows Vista. If anybody is interested I can find more. The problem with this kind of statistics is that you will

Re: [GENERAL] "1-Click" installer problems

2010-03-31 Thread Nikhil G. Daddikar
In about 30 seconds I found the following unanswered threads relating to installation on Windows Vista. If anybody is interested I can find more. And I can tell you that a lot of our customers are facing the same problem with this 1-click gimmicky installer.. something that they never faced t

Re: [GENERAL] "1-Click" installer problems

2010-03-31 Thread Nikhil G. Daddikar
Folks, Here is my original ticket. It has the screen shot as well as the logs. Like many other threads on this forum it remains unresolved. http://forums.enterprisedb.com/posts/list/2235.page If you want to know the number of people who complain about this one-click installer, just search t

[GENERAL] "1-Click" installer problems

2010-03-31 Thread Nikhil G. Daddikar
Hi, I have been trying to install 8.4 on my Vista without success. Earlier I'd tried to install 8.3 and that failed too. I tried installing these on other Vista machines and they failed too. I searched for google and enterprisedb forums and there are innumerable requests like mine. Same with

Re: [GENERAL] Reliability Stability of PgSQL & it's JDBC driver

2000-12-13 Thread Nikhil G. Daddikar
Nathan, Thanks for your response. It is great to know that Postgres is working out fine. However, I don't understand what "Vaccum of the DB" means nor what the "WAL" functionality is. If you could briefly explain these, that would be great. Thanks again! -ngd. > The main problem that you have