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
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
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
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
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
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
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
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.
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
...@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
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
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
, 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
\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
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
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
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
17 matches
Mail list logo