Hi All,
I am doing some database related queries and this is working fine at fedora
core 4.
But the same database queries giving the FATAL error on fedora 9.
If I restarts the database on fedora core 9 then this is perfectlry working
without giving any error.
My postgres version is
On Fedora co
009-06-23
14:49:10.37602+05:30
FATAL: the database system is in recovery mode
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
With Regards,
Bhushan
On 6/24/09, Craig Ringer wrote:
>
> Bhushan Verma wrote:
>
> > server closed the connection un
spcefic path for the postgres executable?
I have already checked for ulimit -c unlimited etc.
On my system core file for some other application are generating properly.
With Regards,
Bhushan
On 6/24/09, Heikki Linnakangas wrote:
>
> Bhushan Verma wrote:
> > I am doing some database rel
OG: server process (PID 14255) was terminated by signal 11: Segmentation
fault" is wriiten in the log file.
With Regards,
Bhushan
On 6/24/09, Heikki Linnakangas wrote:
>
> Bhushan Verma wrote:
> > I have searched for the core file for this pid.
> > Is there any spcefi
ou that its happening after sometime ie at random. time is
not fixed.
>>Is it a particular one, or does it crash at random?
its crash at random.
On 6/24/09, Heikki Linnakangas wrote:
>
> Bhushan Verma wrote:
> >>> postmaster -D /var/lib/pgsql/data
> > I am using
Hi All,
I am trying to run as follows queries
--
SELECT PageIndex,
(SUM(ConnectDoneTime - StartTime) * 100) / SUM(EndTime - StartTime)
AS "ConnectTimePct",
(SUM(WriteCompleTime - ConnectDoneTime) * 100) / SUM(EndTime -
StartTime) AS "RequestSentTimePct",
(SUM(FirstBy
ata.
On 8/31/09, Heikki Linnakangas wrote:
>
> Bhushan Verma wrote:
> > Hi All,
> >
> > I am trying to run as follows queries
> > --
> > SELECT PageIndex,
> >(SUM(ConnectDoneTime - StartTime) * 100) / SUM(EndTime -
> StartTime)
&
getting the problem on Fedora 9 not on fedora 4.
On 9/1/09, Tom Lane wrote:
>
> Bhushan Verma writes:
> > - What version of PostgreSQL you are using?
> > #rpm -qa|grep postgres
> > postgresql-server-8.0.3-1
>
>
> 8.0.3 is four years obsolete. If you can still rep
I have tried to install postgres version 8.3.7 as follows
rm -rf /var/lib/pgsql
mkdir /var/lib/pgsql
./configure --prefix /var/lib/pgsql
gmake
su
gmake install
adduser postgres
mkdir /var/lib/pgsql/data
chown postgres /var/lib/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /var/lib/pgsql/
