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

>>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 wrote: > CM J writes: > >I am running Postgres 8

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

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 MEVS

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

ConfigReader configReader = ConfigReader.getInstance(); > configReader.modifyHbmToDdl(true); > * > > Thanks, > Saurabh > > > On Wed, Jun 24, 2009 at 6:06 PM, CM J wrote: > >> Hi , >> >> I installed postgres 8.3.7-1 in my windows machin

[GENERAL] Postgres 8.3.7 -- EOF on client connection

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 17:55:0

Re: [GENERAL] Postgres 8.2 Memory Tuning

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 wrote: > CMJ, > > same system.E

[GENERAL] Postgres 8.2 Memory Tuning

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 start

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

Hi, I backup my database using the following command: pg_dump.exe -f Backup.sql -U -p MYDB Now,before restoring, i drop all my tables,indexes,foreign key constraints.Then, i restore using the cmd below: psql.exe -U -p -d MYDB -f Backup.sql The above results in following

[GENERAL] Postgres: Transaction Connections

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

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 c

Re: [GENERAL] Postgres: Installing as a service

Hi, The following cmd can be used for installating postgres as a service: pg_ctl.exe register -N -U -P -D and "pgctl.exe unregister -N " can be used to uninstall. Thanks. On Mon, Apr 13, 2009 at 12:15 PM, Craig Ringer wrote: > CM J wrote: > > Hi , &g

[GENERAL] Postgres: Installing as a service

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

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

hanks. On Thu, Apr 9, 2009 at 3:52 PM, Craig Ringer wrote: > 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_c

[GENERAL] Postgres: Starting Server in background mode

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 ge

Re: [GENERAL] Postgres: Packaging & Server Startup

ot;D:\pgsql\bin\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 wrote: > On 31/03/2009 12:14, CM J wrote: > > > D:\pgsql\bin\pg_ctl.exe -U postgres -P -w start -D > D:\pgsql\data &g

Re: [GENERAL] Postgres: Packaging & Server Startup

...FATAL: postgres: could not locate matching postgres executable* Thanks ! On Tue, Mar 31, 2009 at 4:31 PM, CM J 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\bin&

Re: [GENERAL] Postgres: Packaging & Server Startup

: Invalid argument 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 wr

[GENERAL] Postgres: Packaging & Server Startup

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 th