Re: [GENERAL] Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index

2009-07-07 Thread CM J
Sounds like a data corruption problem After reindexing, the problem seems to go away. Is there any way to determine what caused the data corruption in the first place ?? Thanks. On Mon, Jul 6, 2009 at 8:29 PM, Tom Lane t...@sss.pgh.pa.us wrote: CM J postgres.new...@gmail.com writes

[GENERAL] Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index

2009-07-05 Thread CM J
Hi, I am running Postgres 8.3.7 on Windows 2003 with my java application.Off late, the server crashes with the following trace: *2009-07-01 14:47:07.250 ISTPANIC: failed to add item to the right sibling in index mevservices2_ndx* *2009-07-01 14:47:07.250 ISTSTATEMENT: insert into

Re: [GENERAL] [JDBC] Postgres 8.3.7 -- EOF on client connection

2009-06-25 Thread CM J
this: *ConfigReader configReader = ConfigReader.getInstance(); configReader.modifyHbmToDdl(true); * Thanks, Saurabh On Wed, Jun 24, 2009 at 6:06 PM, CM J postgres.new...@gmail.com wrote: Hi , I installed postgres 8.3.7-1 in my windows machine. The server starts all right.However when

[GENERAL] Postgres 8.3.7 -- EOF on client connection

2009-06-24 Thread CM J
Hi , I installed postgres 8.3.7-1 in my windows machine. The server starts all right.However when i attempt a JDBC connection(Driver used: postgresql-8.3-604.jdbc4.jar), the following error is thrown: 2009-06-24 17:55:03.564 ISTERROR: relation befailover does not exist 2009-06-24

Re: [GENERAL] Postgres 8.2 Memory Tuning

2009-06-16 Thread CM J
Hi, I need to measure the memory used by postgres under various loads in my application.How to calculate the exact memory used by postgres for OS:Windows as well as linux ? Thanks, CM J On Mon, Jun 15, 2009 at 5:37 PM, Massa, Harald Armin c...@ghum.de wrote: CMJ, same system.Even

[GENERAL] Postgres 8.2 Memory Tuning

2009-06-15 Thread CM J
Hi , I have installed Postgres 8.2 in windows with default configuration.The windows machine has dual processor(2 GHZ,1GHZ) with 1 GB RAM.I use my java application with postgres and my database connection pool has some 25 connections.I understand from the documentation that postgres

[GENERAL] Postgres BackUp and Restore: ERROR: duplicate key violates unique constraint pg_largeobject_loid_pn_index

2009-05-12 Thread CM J
Hi, I backup my database using the following command: pg_dump.exe -f Backup.sql -U username -p port MYDB Now,before restoring, i drop all my tables,indexes,foreign key constraints.Then, i restore using the cmd below: psql.exe -U username -p port-d MYDB -f Backup.sql The

[GENERAL] Postgres: Transaction Connections

2009-05-05 Thread CM J
Hi , I use postgres database server 8.2.12 with my java application. I was wondering if postgres supports transactions by default or do i have to turn some parameter on to enable transaction support ? Thanks.

[GENERAL] Postgres server startup

2009-04-15 Thread CM J
Hi, When logged in as administrator, i start the postgres server with the following command: runas /user:postgres D:\postgres_new\pgsql\bin\pg_ctl.exe start -D D:\postgres_new\pgsql\data The problem is runas cmd is not script friendly as i can not pass the password as a cmd

Re: [GENERAL] Postgres: Installing as a service

2009-04-13 Thread CM J
...@postnewspapers.com.auwrote: CM J wrote: Hi , I have extracted postgres from postgres-noinstaller.zip file. How do i install postgres as a service from cmd line ? Search: http://msdn.microsoft.com/ You can use the `net' command to start/stop services. I don't recall the command(s) used

[GENERAL] Postgres: Installing as a service

2009-04-12 Thread CM J
Hi , I have extracted postgres from postgres-noinstaller.zip file. How do i install postgres as a service from cmd line ? Are there are any binaries provided by postgres to install it as a service ? Please note that i am aware that msi installer automatically does all this. I want to know

[GENERAL] Postgres: Starting Server in background mode

2009-04-09 Thread CM J
Hi, To start the postgres server in background mode in windows, i executed the following command: *runas /user:postgres D:\postgres_new\pgsql\bin\pg_ctl.exe -W start -D D:\postgres_new\pgsql\data -l D:\postgres_new\pgsql\data\logfile* The postgres starts up all fine and logs get

Re: [GENERAL] Postgres: Starting Server in background mode

2009-04-09 Thread CM J
, Apr 9, 2009 at 3:52 PM, Craig Ringer cr...@postnewspapers.com.auwrote: CM J wrote: Hi, To start the postgres server in background mode in windows, i executed the following command: *runas /user:postgres D:\postgres_new\pgsql\bin\pg_ctl.exe -W start -D D:\postgres_new\pgsql

Re: [GENERAL] Postgres: Packaging Server Startup

2009-04-01 Thread CM J
\pg_ctl.exe -w start -D D:\pgsql\data and it started fine.Thanks to Richard and Ray ! On Tue, Mar 31, 2009 at 6:13 PM, Raymond O'Donnell r...@iol.ie wrote: On 31/03/2009 12:14, CM J wrote: D:\pgsql\bin\pg_ctl.exe -U postgres -P mypasswd -w start -D D:\pgsql\data I wonder if that -P is causing

[GENERAL] Postgres: Packaging Server Startup

2009-03-31 Thread CM J
Hi, I am working on packaging postgres database in our java based application.I downloaded postgresql-8.2.12-1-binaries-no-installer.zip from the postgres site and installed it on a windows 2003 machine using administrator account.I later created a postgres service login account and changed

Re: [GENERAL] Postgres: Packaging Server Startup

2009-03-31 Thread CM J
There is no data directory created by default (i used no-installer-zip file to install postgres), so i went ahead and created a dummy data directory which gave the same result as above. Any suggestions ?? Thanks. On Tue, Mar 31, 2009 at 4:09 PM, Richard Huxton d...@archonet.com wrote: CM

Re: [GENERAL] Postgres: Packaging Server Startup

2009-03-31 Thread CM J
to start...FATAL: postgres: could not locate matching postgres executable* Thanks ! On Tue, Mar 31, 2009 at 4:31 PM, CM J postgres.new...@gmail.com wrote: Hi, I don't have multiple postgres installed.Anyway, tried your suggestion to use the full path name and here is what i get: D:\pgsql